Postgres Pro
Downloads
Home   >   mailing lists

Create Linux Script for PostgreSQL database backup - Mailing list pgsql-admin

From Lawrence C
Subject Create Linux Script for PostgreSQL database backup
Date
Msg-id 20040901132055.17178.qmail@web61008.mail.yahoo.com
Whole thread Raw
Responses Re: Create Linux Script for PostgreSQL database backup
List pgsql-admin
Tree view 
Hi All,

Anyone good in writing Linux scripting for backup
PostgreSQL. I just required a simple scripts only.

Normally we do the manual ways as following:

In root

root# su – postgres
bash# pgdumpall >  backup.sql
bash# exit
root#

I’m planning to write script.sh for cronjob but not
too sure about it. Can anyone contribute the scripts
for me?

Thanks  in advance


________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

pgsql-admin by date:

Previous
From: G u i d o B a r o s i o
Date:
Subject: Re: slower every day
Next
From: Tom Lane
Date:
Subject: Re: [NOVICE] Applicationl Crash - Connection reset by peer !!!