"ENGEMANN, DAYSE" <dayse.engemann@xxxxxx> wrote: > Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: >> pg_dump | psql > And to restore it.. Can I use pg_restore -d new_db_name ?? I usually pipe the output of pg_dump to psql, and thereby avoid making a copy of the dump output entirely. If you want to dump in custom format, yeah, you would use pg_restore instead. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
