From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Correct pg_dumpall Syntax |
Date: | 2008-06-18 17:42:51 |
Message-ID: | Pine.LNX.4.64.0806181039390.10791@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 18 Jun 2008, Joshua D. Drake wrote:
> You need to remove the directory, not the files underneath then:
Ah, so.
Redid, after removing /var/lib/pgsql/data
>>> Then restore as normal using psql -U postgres < mydatabase.sql
Postgres is now running (whew!), but I'm still doing something
incorrectly.
In /usr4/postgres-backups, I did:
[rshepard(at)salmo /usr4/postgres-backups]$ pg_restore -U postgres < pg814data.sql
pg_restore: [archiver] input file does not appear to be a valid archive
But it was created using the 8.3.3 pg_dumpall in /usr/bin/.
Much closer,
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-06-18 17:47:52 | Re: Correct pg_dumpall Syntax |
Previous Message | Joshua D. Drake | 2008-06-18 17:31:28 | Re: Correct pg_dumpall Syntax |