On Thu, 19 Jan 2006, Doug McNaught wrote:
Yes, as I said before, 'pg_dumpall' only produces SQL format dumps, which you restore using 'psql'. 'pg_restore' is only for binary dumps.
Doug, I read the backup/restore web page to which you pointed me. I think that the new database is not initiated. When I follow the instructions and enter: psql -f /var/tmp/backup.sql I see: psql: FATAL: database "postgres" does not exist This is the same message I read when I append 'postgres' to the command. Back to the manual. Thanks, Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq