Re: pg_restore
От | Bob Pawley |
---|---|
Тема | Re: pg_restore |
Дата | |
Msg-id | 005b01c819a7$65a7aea0$6401a8c0@owner обсуждение исходный текст |
Ответ на | pg_restore (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: pg_restore
Re: pg_restore |
Список | pgsql-general |
Hi Adrian With pg_restore psql -h localhost -d PDW -U postgres aurel.sql the error message is - pg_restore: could not open input file: No such file or directory exists. I get this message with aurel.sql - or aurel - or the path to aurel (......8,2\bin) or when aurel is not even mentioned. This is becoming quite frustrating. Bob ----- Original Message ----- From: "Adrian Klaver" <aklaver@comcast.net> To: <pgsql-general@postgresql.org> Cc: "Bob Pawley" <rjpawley@shaw.ca> Sent: Sunday, October 28, 2007 11:45 AM Subject: Re: [GENERAL] pg_restore > 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@comcast.net
В списке pgsql-general по дате отправления: