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:

---
#!/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


-- 
To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org