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
