From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |
Date: | 2006-01-19 22:59:06 |
Message-ID: | Pine.LNX.4.63.0601191455260.20481@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-01-19 23:06:07 | Re: A tale of two similar databases |
Previous Message | Jim C. Nasby | 2006-01-19 22:58:35 | Re: No heap lookups on index |