Thread: Requiring pass and database psql shell command
Hi Guys,
do you have also problem that every time you have to log into your database using shell and psql?
I have to write over and over localhost, username, password...how to force shell to remember this?
Best,
Jacek
Attachment
Well, it's not a problem, it's the way it's designed and it's a sensible design. Check https://www.postgresql.org/docs/9.3/static/libpq-envars.html for more info on doing what you want.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych" <jaryszek@gmail.com> wrote:
Hi Guys,do you have also problem that every time you have to log into your database using shell and psql?I have to write over and over localhost, username, password...how to force shell to remember this?Best,Jacek
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
thank you!!
Jacek
2018-03-05 14:33 GMT+01:00 James Keener <jim@jimkeener.com>:
Well, it's not a problem, it's the way it's designed and it's a sensible design. Check https://www.postgresql.org/docs/9.3/static/libpq-envars. html for more info on doing what you want. --On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych" <jaryszek@gmail.com> wrote:Hi Guys,do you have also problem that every time you have to log into your database using shell and psql?I have to write over and over localhost, username, password...how to force shell to remember this?Best,Jacek
Sent from my Android device with K-9 Mail. Please excuse my brevity.
The password file is also a solution.
https://www.postgresql.org/docs/current/static/libpq-pgpass.html
On 03/05/2018 07:33 AM, James Keener wrote:
https://www.postgresql.org/docs/current/static/libpq-pgpass.html
On 03/05/2018 07:33 AM, James Keener wrote:
Well, it's not a problem, it's the way it's designed and it's a sensible design. Check https://www.postgresql.org/docs/9.3/static/libpq-envars.html for more info on doing what you want.On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych" <jaryszek@gmail.com> wrote:Hi Guys,do you have also problem that every time you have to log into your database using shell and psql?I have to write over and over localhost, username, password...how to force shell to remember this?Best,Jacek
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
Hi Guys,do you have also problem that every time you have to log into your database using shell and psql?I have to write over and over localhost, username, password...how to force shell to remember this?
Use a service file.
psql "service=mydb" -c "SELECT 1;"
I also, for scripts, simply define a function at the top of the script psql_* and invoke that function instead of psql directly.
I use .pgpass for passwords
David J.