Re: [ADMIN] Question about backing up PostgreSQL databases

[David C. Brown]

Well, we currently use pg_dumpall and pipe it to a tar file.  It backups 
up all data and the database schema.  So if a database goes down, I can 
just pipe that file to pgsql and it will reload everything including all 
tables, users, grant rights, etc.

There is also a company called Bakbone software that has a module for 
their software that will backup PostgreSQL databases.  You can see it at 
their website.  http://www.bakbone.com 

Good luck,
Dave
Van L. Loggins wrote:

What methods are available to easily backup the contents of a PostgreSQL database?

We are in the process of converting over to it from Progress, and we need to figure 
out what our best option is to have a complete backup in case of disaster.

Thanks for the input,

Van

 



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])