Forum OpenACS Q&A: Postgres Backups: pg_dump -D still necessary?

Collapse
1: Postgres Backups: pg_dump -D still necessary?
Posted by Carl Coryell-Martin on 03/14/02 01:54 AM
Back in the Dark ages I remember having to do pg_dump with the -D
option (sql inserts with attributes) to have any hope for a successful
(but slow) restore.

Is this still true with 7.1.2 and 7.2?

Can I get away with the straight pg_dump?

cheers,

Collapse
2: Response to Postgres Backups: pg_dump -D still necessary? (response to 1)
Posted by Rocael Hernández Rizzardini on 03/14/02 04:19 AM
I've always done the dump in 7.1.2 with pg_dump without flags, and have worked fine, then when I want to reload,
after creating the database,

I createlang plpgsql, pltcl

and do psql -f /web/yourservice/www/doc/sql/postgres.sql yourservice

and psql -f yourdump yourservice