Re: Correct pg_dumpall Syntax

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