BUG #6007: pg_restore -C -d <database> does not behave as expected when dump is done with pg_dump

From: "gab" <korsani(at)free(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6007: pg_restore -C -d <database> does not behave as expected when dump is done with pg_dump
Date: 2011-05-05 13:35:30
Message-ID: 201105051335.p45DZUIe006513@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6007
Logged by: gab
Email address: korsani(at)free(dot)fr
PostgreSQL version: 8.4.8
Operating system: FreeBSD
Description: pg_restore -C -d <database> does not behave as expected
when dump is done with pg_dump
Details:

Create a database name 'test' and fill it :
CREATE TABLE t (
t text
);

ALTER TABLE public.t OWNER TO postgres;

--
-- Data for Name: t; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY t (t) FROM stdin;
plop
\.

Then dump it :
pg_dump -F c -f /tmp/plop test

Drop it :
psql -c 'drop database test;'

Try to restore it using :
pg_restore -C -d test /tmp/plop
pg_restore: [archiver (db)] connection to database "test" failed: FATAL:
database "test" does not exist

But the doc says that -C use the parameter of -d to CREATE the database ...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message francis.brown 2011-05-05 13:39:12 Re: BUG #6006: Will not install
Previous Message Dave Page 2011-05-05 13:08:18 Re: BUG #6006: Will not install