Is there a way to pass postgresql password to psql

Question

Is there a way to pass postgresql password to psql

in the command line?
psql -h 127.0.0.1 -U postgres postgres -c '\l'

this commands prompts for a password but I need a script to do this automatically

#backend #devops #pgsql #programming #russian

0

17.11.2020

6 ответов

10 просмотров

Denis Konaryov

adde: export PGPASSWORD="password_db"

0

17.11.2020

Satish Luintel Автор вопроса

Denis Konaryov
adde: export PGPASSWORD="password_db"

Is there a tutorial I can reference to please?

0

17.11.2020

Satish Luintel Автор вопроса

Sergey Gr
You can use .pgpass file https://www.postgresql.or...

I tried this, also used export command but something does not seem right. The problem is still there.

0

17.11.2020

Ильнур

Satish Luintel
Is there a tutorial I can reference to please?

jfyi - .pgpass is considered as the more correct way https://stackoverflow.com/questions/2893954/how-to-pass-in-password-to-pg-dump

0

17.11.2020

Satish Luintel Автор вопроса

Ильнур
jfyi - .pgpass is considered as the more correct w...

Thanks ) this works!

0

17.11.2020

Sergey Gr · Accepted Answer

Sergey Gr

You can use .pgpass file https://www.postgresql.org/docs/13/libpq-pgpass.html

0

17.11.2020

172 похожих чатов

Is there a way to pass postgresql password to psql

6 ответов

Похожие вопросы