[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] regular backups - super user
From: Stuart Johnston <sjohnston () haisolutions ! com>
Date: 2003-10-31 21:48:31
[Download RAW message or body]
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 to backup without passwords ?
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).
If you need passworded local connections for users then you'll probably
want to turn on 'ident' mode just long enough to set the password for
the postgres user (or some other 'super user'). Then you may also want
to use the PGPASSWORD environment variable or the .pgpass file to avoid
typing the password repeatedly.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic