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@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