I need to test and create a procedure to restore
databases.
I followed the steps based on the site, but I couldn't
finish succesfully.
I did:
1. Put the database on Backup Mode and copy
datafiles.
/pg/bin/psql cresoldev -c "SELECT
pg_start_backup('/pg/backup/');"
tar -cvf /pg/backup/bk_b
other suggestion?
Thanks for your help
Aaron Bono escreveu:
On 7/11/06, *Burbello* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
I need to test and create a procedure to restore
databases.
Why not just use pg_dump?
See http://manual.intl.indoglobal.com/ch06s07
Yes!
I followed exactly that page to do.
Thanks
Scott Marlowe escreveu:
On Wed, 2006-07-12 at 15:04, Alexander Burbello wrote:
Ok! Its a good tool, but for Production Database I think it is not
recommended.
Only using pg_dump for the second backup plain.
Suppose that you backed up at 6
