On Feb 13, 2010, at 7:36 PM, Janet S Jacobsen wrote: > Hi. I am trying to restore a database from a pgdump file, something > that I've sucessfully done before. > > I created a new database cluster, created the database that I want > to restore using > > create database subptf with template = template0; > > and then I tried to restore the database using > > ./psql subptf < subptf.pgdump > > The first part of what I get is > > ERROR: syntax error at or near "PGDMP"
I'd guess that you created the dump in custom format, rather than sql format. If so, you'd need to use pg_restore to restore it rather than psql. Cheers, Steve -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
