Re: .ini support for .pgpass

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Aidan Van Dyk <aidan(at)highrise(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: .ini support for .pgpass
Date: 2011-04-05 23:04:43
Message-ID: 1302044683.29588.74.camel@jd-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)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(at)highrise(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masanori Yamazaki 2011-04-06 00:09:53 GSoC Proposal - Caching query results in pgpool-II
Previous Message Aidan Van Dyk 2011-04-05 22:52:21 Re: .ini support for .pgpass