[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Backup Postgressql

On Wed, Sep 26, 2007 at 12:33:52PM -0300, Rodolfo Barbosa wrote:
> Hi,
> How can I dunp the data bases from de postgressql without password 
> prompt? I`m using sarge.

Add a pg_hba.conf entry for the user that should be allowed to dump the
database, make it a postgres super user, let it use ident auth on the local
socket, use a local connection as that user to dump the database.

A script something like:


for database in $(psql -A -l -t | cut -d "|" -f 1); do
        pg_dump ${database} > database.dmp

Might also be useful.

Brett Parker

Reply to: