Hosting Provided By

Re: Backup Postgressql

From: Tinus Nijmeijers <mlists(at)deephosting.com>
Date: Wed Sep 26 2007 - 11:46:15 EDT

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

PGPASSWORD=secret
export PGPASSWORD
pg_dump database > /tmp/database.dump
PGPASSWORD=
export PGPASSWORD

while the backup is running your password is out in the open, but in my case that doesn't matter.

gr.
tinus

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

Received on Wed Sep 26 11:51:25 2007

This message: [ Message body ]
Next message: Wojciech Ziniewicz: "PPPoE server performance / problem with uploads [long]"
Previous message: Rodolfo Barbosa: "Backup Postgressql"
In reply to: Rodolfo Barbosa: "Backup Postgressql"
Next in thread: Turbo Fredriksson: "Re: Backup Postgressql"
Reply: Turbo Fredriksson: "Re: Backup Postgressql"
Reply: Marc Schiffbauer: "Re: Backup Postgressql"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 00:08:14 EDT