Re: Backup Postgressql

[Brett Parker <iDunno@sommitrealweird.co.uk>]

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:

---
#!/bin/bash

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

Might also be useful.

Cheers,
-- 
Brett Parker