Re: Requiring pass and database psql shell command
On Mon, Mar 5, 2018 at 5:55 AM, Łukasz Jarych 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? > > Use a service file. psql "service=mydb" -c "SELECT 1;" https://www.postgresql.org/docs/10/static/libpq-pgservice.html 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.
Re: Requiring pass and database psql shell command
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: 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" 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.
Re: Requiring pass and database psql shell command
thank you!! Jacek 2018-03-05 14:33 GMT+01:00 James Keener : > 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" > 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. >
Re: Requiring pass and database psql shell command
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" 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.
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