On Sunday 28 October 2007 3:40 pm, Bob Pawley wrote: > This is the dump command > > pg_dump -h localhost -d Aurel -U postgres > > Could you suggest a dump command that will match the restore command - > > pg_restore -h localhost -d PDW -U postgres aurel.sql > > > Thanks > > Bob > It depends on what you want to do. But to use pg_restore you will need to use one of either -Fc or Ft after the pg_dump command. My concern is that you are connecting to a different database name in the dump and restore commands. This may be what you want, but then again it may not.I would suggest reading the information at the URL below before proceeding further. http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html -- Adrian Klaver aklaver@xxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
