Обсуждение: pg_restore problem.
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!
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) <s.chava@wcom.com> - Boss: Sean T Laduderdale <sean.lauderdale@wcom.com> 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