Date: Mon, 24 Oct 2005 12:46:02 -0500 From: "Andrew L. Gould" <algould@datawok.com> To: Pat Maddox <pergesu@gmail.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Backing up postgresql data Message-ID: <20051024124602.15a69f63@grokwell.org> In-Reply-To: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com> References: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 24 Oct 2005 11:02:11 -0600 Pat Maddox <pergesu@gmail.com> wrote: > 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 Are your databases very large or extremely active? If not, a nightly pg_dump (or pg_dumpall) should suffice. I've found the combination of PostgreSQL and FreeBSD to be very stable. If you need more frequent backups, you might consider one of the replication solutions for PostgreSQL. Here are links to a couple of them that I found at PgFoundry: http://pgfoundry.org/projects/slony1/ http://pgfoundry.org/projects/pgpool/ I haven't used any of the replication solutions. Hopefully, someone else will chime in with additional information/advice. Best of luck, Andrew Gould
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051024124602.15a69f63>