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