Thanks, Steve. You are exactly right. pg_restore was the right command to use! Janet 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
