pg_dump vs pg_dumpall - small database cluster, complete recovery method needed

From: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump vs pg_dumpall - small database cluster, complete recovery method needed
Date: 2003-12-20 05:51:06
Message-ID: 59830.63.227.74.41.1071899488.squirrel@webmail.stinkweasel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hey folks,

I'm a systems/network guy and not a developer/DBA, FYI. I'm in the
process of redoing a personal, low-traffic website to use PHP and
PostgreSQL as a learning exercise. I've got all the code done and the
database is populated, so now I'm tying up the loose ends, namely backups.
I am using PostgreSQL 7.3 on OpenBSD 3.4-STABLE.

I've been going over the docs for pg_dump and pg_dumpall, and I just
want to make sure I'm understanding things correctly. If I'm reading
things right, pg_dump is probably better suited to dumping individual
databases, and pg_dumpall is suited to dumping a database _system_ (ie,
multiple databases on one host).

What I need: In case of complete system failure, I need to be able to
recreate a database cluster from step 0 through accepting connections.
I can easily reproduce the database machine with PostgreSQL in a matter
of an hour. From that specific point, having a completely clean DB, I
need to restore all users, passwords, databases, sequences, etc.

pg_dumpall seems to do this for me, without any command-line args
needed. Am I correct in saying that 'pg_dumpall > filename' will produce
a PostgreSQL dump that includes _everything_ I need to go from a clean
PG install to accepting connections again with data intact? Users,
passwords, etc?

I just want to be _very_ sure of this, before I automate the entire
process. :) I did attempt to search the archives for pgsql-admin, but
the archives seem to not be happy at the moment. Hopefully, this isn't
a FAQ, I did read through the FAQs on postgresql.org (it's always
possible I missed something).

Thanks folks! PostgreSQL is a very impressive project.

Benny

--
"Hey, get in here, Boozy! You're late for your drunkening!"
-- Moe, "The Simpsons"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-12-20 06:12:27 Re: Index is not used
Previous Message Oliver Elphick 2003-12-20 04:47:07 {Virus?} Re: Debian Install 7.4