On Sunday 28 October 2007 11:32 am, Bob Pawley wrote: > Please help. > > I am attempting to restore a database into PostgreSQL version 8.2 running > on Win XP Professional. > > From the 'bin' folder, I am using the command line- > pg_restore psql -h localhost -d PDW -U postgres -f aurel.sql Try pg_restore psql -h localhost -d PDW -U postgres aurel.sql No -f switch > > I get an error - > > pg_restore: cannot specify both -d and -f output. > > If the error message is correct how does pg_restore know what to put where? The -d switch tells pg_restore to the named database. The -f switch tells it to restore to named file. It won't do both. > > I used the same command to successfully install the same pg_dump file into > PostgreSQL 8.1 running on the same computer. Maybe 8.1 ignored the error. > > Any thoughts would be much appreciated. > -- Adrian Klaver aklaver@xxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
