Re: pg_restore
От | Bob Pawley |
---|---|
Тема | Re: pg_restore |
Дата | |
Msg-id | 001901c819b3$822878f0$6401a8c0@owner обсуждение исходный текст |
Ответ на | pg_restore (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: pg_restore
Re: pg_restore |
Список | pgsql-general |
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 ----- Original Message ----- From: "Adrian Klaver" <aklaver@comcast.net> To: <pgsql-general@postgresql.org> Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Tom Lane" <tgl@sss.pgh.pa.us> Sent: Sunday, October 28, 2007 3:15 PM Subject: Re: [GENERAL] pg_restore > On Sunday 28 October 2007 3:01 pm, Bob Pawley wrote: >> The latest in the saga - >> >> By using - pg_restore -h localhost -d PDW -U postgres aurel.sql >> >> I get the message - pg_restore: input file does not appear to be a valid >> archive. >> >> I get this message when I used the aurel.sql file which I previously >> loaded >> successfully in 8.1 and also when I use an aurel.sql file which I just >> successfully dumped a few minutes ago from the 8.1 on my other computer. >> >> Could pg_restore in my 8.2 be corrupted?? >> >> Bob > What does your dump command look like? My guess is your are doing a plain > text > dump and pg_restore only works with the custom formats. If you want to use > the plain text version than you need to use psql. This maybe how you got > to > the point of having both pg_restore and psql on the same line. > -- > Adrian Klaver > aklaver@comcast.net > > ---------------------------(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
В списке pgsql-general по дате отправления: