Re: .ini support for .pgpass - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: .ini support for .pgpass
Date
Msg-id 1302044683.29588.74.camel@jd-desktop
Whole thread Raw
In response to Re: .ini support for .pgpass  (Aidan Van Dyk <aidan@highrise.ca>)
Responses Re: .ini support for .pgpass  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Tue, 2011-04-05 at 18:52 -0400, Aidan Van Dyk wrote:
> On Tue, Apr 5, 2011 at 6:34 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> 
> > Bare, useful, but not really friendly nor flexible. I would love to be
> > able to do this:
> 
> > [ecom]
> > hostname=
> > port=
> > database=
> > username=
> > password=
> 
> That looks a lot like a pg_service file.
> 
> > psql ecom
> >
> > boom, I am in.
> >
> > Thoughts?
> 
> So you're really looking to make psql use "service" connection
> definitions more easily, not just retrieve the password associated
> with the given (maybe defaulted) host:port:database:user, right?

Well any libpq app but yes. I actually wonder as to the legitmacy of
having both a pgpass and a pg_service. Why not just one of them?

JD

> 
> a.
> 
> -- 
> Aidan Van Dyk                                             Create like a god,
> aidan@highrise.ca                                       command like a king,
> http://www.highrise.ca/                                   work like a slave.
> 

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt



pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: .ini support for .pgpass
Next
From: Masanori Yamazaki
Date:
Subject: GSoC Proposal - Caching query results in pgpool-II