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

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