Thread: Bug or not...

Bug or not...

From
"Nick Altmann"
Date:
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. A=
lso, i cannot do nightly backup if I don't use trusted connections. Cannot =
you add password command line parameter in psql and others?

Thanks,
Nick.=

Re: Bug or not...

From
Bruno Wolff III
Date:
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
passwordparameter in command line. Also, i cannot do nightly backup if I don't use trusted connections. Cannot you add
passwordcommand 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.

Re: Bug or not...

From
Bruno Wolff III
Date:
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.
> >
>