On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote: > [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/. pgdumpall (and pgdump by default) will produce output in SQL format. Restoring is just a simple matter of: psql dbname -f pg814data.sql Hope that helps! Sam
