On 28/10/2007 22:40, Bob Pawley wrote:
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
One thing that caught me, and I suspect may be catching you also -
somewhat confusingly, in pg_restore the -d option specifies the database
to which to restore; in pg_dump it instead causes the data to be dumped
as INSERT statements rather than COPY.
I can see why things may work this way (pg_dump always needs to be
pointed at a database, whereas pg_restore doesn't if the dump is going
to create the database)....but it can trap the unwary.
See the docs at
http://www.postgresql.org/docs/8.2/static/reference-client.html
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
