Re: Upgrade Problem: 7.4.3 -> 8.1.2

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