Date: Mon, 24 Oct 2005 10:50:44 -0700 From: "Bob Lee" <bob@bobleeit.net> To: freebsd-questions@freebsd.org Subject: Re: Backing up postgresql data Message-ID: <20051024175044.GA8036@mach.cnsisp.com> In-Reply-To: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com> References: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <pergesu@gmail.com>: > 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 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" -- ********* I prefer mail in plain text format ********** PGP/GnuPG: D3EE2269 <pgp.mit.edu>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051024175044.GA8036>