| From: | Allan Engelhardt <allane(at)cybaea(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | [repost] pg_restore doesn't work with custom format? |
| Date: | 2001-10-19 15:02:38 |
| Message-ID: | 3BD0408E.2090908@cybaea.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
This looks like a bug, or can somebody explain how I'm supposed to
restore a custom archive dump?
$ createdb foo
CREATE DATABASE
$ psql foo
foo=# create table users (id serial);
NOTICE: CREATE TABLE will create implicit sequence 'users_id_seq' for
SERIAL column 'users.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'users_id_key'
for table 'users'
CREATE
foo=# \q
$ pg_dump --blobs --clean --create --file=/tmp/foo.dump --format=c
--compress=9 foo
$ dropdb foo
DROP DATABASE
$ pg_restore --create -d test /tmp/foo.dump
Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR: ProcedureCreate: procedure pltcl_call_handler already
exists with same arguments
'.
$ pg_restore --create --clean -d test /tmp/foo.dump
Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR: index "users_id_key" does not exist
'.
What's the magic command that I am looking for??
Allan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-10-19 16:08:12 | Re: VACUUMing a live site OK? |
| Previous Message | Brian McCane | 2001-10-19 14:42:52 | Re: Please help - tks |