Re: Upgrade Problem: 7.4.3 -> 8.1.2

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

In response to

Responses

Browse pgsql-general by date

  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