On Thu, Nov 07, 2002 at 05:08:58PM +0800, Federico Sevilla III wrote: > Have you considered backing it up using pg_dumpall(1) instead? This > tool comes wich the PostgreSQL distribution and exports your database > and table structures together with your data, allowing you to rebuild > your system from scratch on any PostgreSQL server. It is also the > recommended method for backing up PostgreSQL databases during certain > upgrades.
A number have recommended using pg_dump(1). pg_dumpall(1) is a more "complete" solution IMO. It calls pg_dump(1) for each database in your PostgreSQL cluster and further backs up important global objects, which include user and group information. Here on our server I have a script that is called by cron every other night which runs pg_dumpall as the PostgreSQL superuser, compressing the dump into a file using a pipe to gzip. --> Jijo -- Federico Sevilla III : http://jijo.free.net.ph : When we speak of free Network Administrator : The Leather Collection, Inc. : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
