# Kong does not work with Postgres 14.x

**URL:** <https://discuss.konghq.com/t/kong-does-not-work-with-postgres-14-x/9929>\
**Category:** General\
**Tags:** kong-gateway\
**Created:** [March 10, 2022, 3:26am UTC](https://discuss.konghq.com/t/kong-does-not-work-with-postgres-14-x/9929 "2022-03-10T03:26:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kumarbijendra](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/kumarbijendra/32/1550_2.png) [@kumarbijendra](https://discuss.konghq.com/u/kumarbijendra)\
**Post date:** [March 10, 2022, 3:26am UTC](https://discuss.konghq.com/t/kong-does-not-work-with-postgres-14-x/9929/1 "2022-03-10T03:26:56Z")

</div>

Hello Community,

I have installed kong on our Kubernetes cluster using the latest Helm chart. We have Postgres 14.x Version installed. Its default password encryption is scram-sha-256.

I am having trouble running the migration. Here is log

Error: module ‘openssl.rand’ not found:No LuaRocks module found for openssl.rand  
no field package.preload[‘openssl.rand’]  
no file ‘/opt/openssl/rand.lua’  
no file ‘/opt/openssl/rand/init.lua’  
no file ‘./openssl/rand.lua’  
no file ‘./openssl/rand/init.lua’  
no file ‘/usr/local/openresty/site/lualib/openssl/rand.ljbc’  
no file ‘/usr/local/openresty/site/lualib/openssl/rand/init.ljbc’  
no file ‘/usr/local/openresty/lualib/openssl/rand.ljbc’  
no file ‘/usr/local/openresty/lualib/openssl/rand/init.ljbc’  
no file ‘/usr/local/openresty/site/lualib/openssl/rand.lua’  
no file ‘/usr/local/openresty/site/lualib/openssl/rand/init.lua’  
no file ‘/usr/local/openresty/lualib/openssl/rand.lua’  
no file ‘/usr/local/openresty/lualib/openssl/rand/init.lua’

here is the proxy POD log:

Error from server (BadRequest): container “proxy” in pod “kong-gateway-kong-6458d89d8c-fgvhg” is waiting to start: PodInitializing

Could you please help me resolve this issue?

---

<div class="post-metadata">

**Author:** ![pradeep](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@pradeep](https://discuss.konghq.com/u/pradeep)\
**Post date:** [June 19, 2022, 6:41pm UTC](https://discuss.konghq.com/t/kong-does-not-work-with-postgres-14-x/9929/2 "2022-06-19T18:41:36Z")

</div>

I had to do the following to fix this

1. Update the password encryption to md5 in postgresql.conf file, in my case, located at /var/lib/pgsql/14/data/postgresql.conf (amzn-linux2), and then restart the database.

2. Log into Postgres and update the password  
sudo -u postgres psql  
ALTER USER kong WITH PASSWORD ‘new\_password’;

3. run the migrations command:  
kong migrations bootstrap -c {path to kong.conf file}