On Fri, Oct 31, 2003 at 15:48:31 -0600,
Stuart Johnston <[EMAIL PROTECTED]> wrote:
>
> If your users always connect through TCP/IP then you can set local
> connections to not use passwords but I'm pretty sure there is no way to
> configure this just for the postgres user (I wish you could).
I
Hello,
Your pg_hba.conf controls the authentication model for your machine.
One way to handle this is to have
the database on a local machine and allow anything local (not
localhost/127.0.0.1) to be of type trust.
You should only do this if you trust the people that have access to
shell acco
quick answer: research/read the pg_hba.conf in the data directory.
Jeff MacDonald wrote:
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without pass
DeJuan Jackson wrote:
quick answer: research/read the pg_hba.conf in the data directory.
Jeff MacDonald wrote:
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without passwords ?
Thanks.
Jeff.
---(end of broadcast)---