pg_restore problem.
pg_restore problem.
От:
"Alex Hudich" <altx@mail.ru>
Дата:
I'm trying to backup and restore database from DBname to DBname2 (e.g. copy database. it is for example). When i'm trying to use these commands : #pg_dump -f DBname.tar -b -o -Ft DBname #createdb DBname2 #pg_restore -Ft -d DBname2 -f DBname.tar pg_dump works fine, but pg_restore produce this error message : Archiver(db): Could not execute query. No result from backend. What's wrong? Help me, please. --- cul8er!
Re: pg_restore problem.
От:
Srinivasa R Chava <s.chava@wcom.com>
Дата:
hi, Before taking backup with pg_dump, give createdb and createuser privileges to all the users of the first database.Then restore it in the second database with pg_restore.I don't know why they made the privileges required for taking backup. --with regrard chava -- Srinivasa R Chava (Chava) - Boss: Sean T Laduderdale vnet4603575 Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257