Re: Requiring pass and database psql shell command - Mailing list pgsql-general

From Ron Johnson
Subject Re: Requiring pass and database psql shell command
Date
Msg-id c8afb0cf-c65b-beef-cff8-28a42a23f548@cox.net
Whole thread Raw
In response to Requiring pass and database psql shell command  (Łukasz Jarych <jaryszek@gmail.com>)
List pgsql-general
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" <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.

pgsql-general by date:

Previous
From: Pavel Luzanov
Date:
Subject: Re: psql variables in the DO command
Next
From: "Roger Sunny"
Date:
Subject: 回复: pg_upgrade fails to restore function