Re: Bug #756: suggestion: file with password instead of

From: Rod Taylor <rbt(at)zort(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Reinhard Max <max(at)suse(dot)de>, pg(at)wojtus(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #756: suggestion: file with password instead of
Date: 2002-09-05 16:33:53
Message-ID: 1031243634.71961.75.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

On Thu, 2002-09-05 at 12:14, Bruce Momjian wrote:
> Rod Taylor wrote:
> > On Thu, 2002-09-05 at 05:13, Reinhard Max wrote:
> > > On 4 Sep 2002 at 12:48, Rod Taylor wrote:
> > >
> > > > This item:
> > > > Add file to hold passwords using PGPASSWORDFILE environment variable
> > > >
> > > > Has been completed, and will be a part of the 7.3 release.
> > >
> > > Is there a default file name like ~/.pgpassword so that this feature
> > > can be used without setting yet another environment variable?
> >
> > I'm not entirely sure, but I don't believe so. You can read the 7.3
> > docs at developer.postgresql.org.
>
> Is there a good reason for a default for this? If we have a default,
> there will be no way to disable the lookups except by renaming the file.
> On the other hand, no default means that people will make up their own
> names for the file, and that seems bad.

My understanding is that it's a single password, not a list.

As such you would probably not want a default, as each database you
connect to will (should?) have a different password. By setting a
default file we may encourage users to use the same password throughout
all PostgreSQL databases.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-05 16:36:57 Re: Bug #756: suggestion: file with password instead of
Previous Message Bruce Momjian 2002-09-05 16:14:23 Re: Bug #756: suggestion: file with password instead of

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-09-05 16:36:57 Re: Bug #756: suggestion: file with password instead of
Previous Message Bruce Momjian 2002-09-05 16:14:23 Re: Bug #756: suggestion: file with password instead of