Hello Pat, Just advice from another user -- I always used the dump facility and have restored the data successfully using this method. Thge only glitch that I can ever recall was self-inflicted as I upgraded the DB and then the data couldn't be directly restored. That was a while ago and my memory may not be perfect on that detail.
Bob Lee Quoting Pat Maddox <[EMAIL PROTECTED]>: > I've got postgresql 8 running on my system, and want to do nightly > backups of the database. I took a look at the docs, and there are a > few methods of doing backups - pg_dump, file system level, and using > WAL. I just want to be able to rsync my data every night, maybe every > few hours, so that I can recover it if there are any problems...so > what's the best way to do this. Are there any scripts or utilities > available to make my life easy? > > Thanks, > Pat > _______________________________________________ > [email protected] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" -- ********* I prefer mail in plain text format ********** PGP/GnuPG: D3EE2269 <pgp.mit.edu> _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
