On Sun, Jun 01, 2003 at 11:10:56 +0400,
Nick Altmann <nick@luchshe.net.ru> wrote:
> Ok. I agree about psql. But how can I do pg_dump???
Please keep discussions on the list.
Ident authentication will work for pg_dump if it is supported by your OS.
I suspect that .pgpass will work with pg_dump (with 7.3.x), but don't
know for sure. It should be easy for you to try this yourself.
>
> ----- Original Message -----
> From: "Bruno Wolff III" <bruno@wolff.to>
> To: "Nick Altmann" <nick@luchshe.net.ru>
> Cc: <pgsql-bugs@postgresql.org>
> Sent: Sunday, June 01, 2003 9:23 AM
> Subject: Re: Bug or not...
>
>
> > On Fri, May 30, 2003 at 16:33:55 +0400,
> > Nick Altmann <nick@luchshe.net.ru> wrote:
> > > Hello!
> > >
> > > I think it's not bug, but difficulty.
> > >
> > > I cannot use trusted connections for my localhost. I use password. But
> psql, pg_dump, pg_restore doesn't support password parameter in command
> line. Also, i cannot do nightly backup if I don't use trusted connections.
> Cannot you add password command line parameter in psql and others?
> >
> > You can put passwords in a file. Putting them on the command line is a bad
> > idea anyway as the command line is visible to other users on many systems.
> > However you are probably better off using ident authentication.
> >
>