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
