From: | "suresh adapa" <suresha(at)collab(dot)net> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Cc: | <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Subject: | Dump and Restore in postgresql-8.3.6-1PGDG |
Date: | 2010-04-15 14:33:34 |
Message-ID: | 0213965108DEAD48960CE83455E07DFF0234BC84@maa-exchmb.maa.corp.collab.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I am on Linux using postgresql-8.3.6-1PGDG
Taking Dump using
=================
export PGPASSWORD=suresha && pg_dump -b -c -C --format=c -h localhost -p
5432 -U suresha -f /tmp/dump/db/suresha.sql suresha
Trying to Restore the same like
=======================
[root(at)cu018 scripts]# pg_restore -c --format=c -h localhost -p 5432 -U
suresha -d suresha /tmp/dump/db/suresha.sql
Password:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6; 2615 2200 SCHEMA
public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of schema public
Command was: DROP SCHEMA public;
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"public" already exists
Command was: CREATE SCHEMA public;
pg_restore: [archiver (db)] Error from TOC entry 2663; 0 0 COMMENT
SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of schema public
Command was: COMMENT ON SCHEMA public IS 'standard public schema';
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges were granted for "public"
pg_restore: WARNING: no privileges were granted for "public"
WARNING: errors ignored on restore: 3
Wondering how can I suppress the Error and other messages seen above.
Thanks
SureshA
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2010-04-15 14:51:35 | Re: BUG #5422: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initinot initiate the connecti |
Previous Message | Pavel Stehule | 2010-04-15 14:22:50 | Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG) |