Re: [ADMIN] pg_dump vs pg_dumpall - small database cluster,

2003-12-22 Thread scott.marlowe
On Sat, 20 Dec 2003, C. Bensend wrote: 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

Re: [ADMIN] pg_dump vs pg_dumpall - small database cluster,

2003-12-20 Thread C. Bensend
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,

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

2003-12-19 Thread C. Bensend
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

Re: [ADMIN] pg_dump vs pg_dumpall - small database cluster,

2003-12-19 Thread A.Bhuvaneswaran
databases, and pg_dumpall is suited to dumping a database _system_ (ie, multiple databases on one host). Right. 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