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