On Wed, 2011-04-06 at 07:47 +0300, Peter Eisentraut wrote:
> On tis, 2011-04-05 at 16:04 -0700, Joshua D. Drake wrote:
> > 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?
>
> So you can keep passwords in a safer place (= less permissions) than the
> rest of the connection information.
>
> Note also that .pgpass is a mapping from connection information to
> password, whereas pg_service.conf is a mapping from service name to
> connection information. So they operate on different levels.
>
> It's not actually clear from your syntax example what semantics you are
> trying to achieve.
I want to achieve two things:
1. More understandable .pgpass format. Yes, I understand our standard
format, most people won't. Like JoshB said, hard to debug.
2. psql foo, gets me into foo. A macro for connections if you will.
JD
>
>
--
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