[BUGS] BUG #6007: pg_restore -C -d does not behave as expected when dump is done with pg_dump

[gab]

The following bug has been logged online:

Bug reference:  6007
Logged by:  gab
Email address:  kors...@free.fr
PostgreSQL version: 8.4.8
Operating system:   FreeBSD
Description:pg_restore -C -d  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 ...

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #6008: Can't contact Tom Lane :)

[gab]

The following bug has been logged online:

Bug reference:  6008
Logged by:  gab
Email address:  kors...@free.fr
PostgreSQL version: 8.4.8
Operating system:   FreeBSD
Description:Can't contact Tom Lane :)
Details: 

I opened a bug (#6007), that was handled by Tom Lane. He wrote me a mail,
but when I answer the mail come back to me ("Returned to sender")

I write here my response :
->8--

Hi,
Here : http://www.postgresql.org/docs/8.4/static/app-pgrestore.html
You can read :
-C
--create

Create the database before restoring into it. (When this option is used,
the database named with -d is used only to issue the initial CREATE DATABASE
command. All data is restored into the database name that appears in the
archive.)


-d dbname
--dbname=dbname

Connect to database dbname and restore directly into the database.

Although "All data is restored into the database name that appears in the
archive" is unclear, as when dumping with "pg_dump -F c" the dump does not
contain the database name ...

- "Tom Lane"  a écrit :

> "gab"  writes:
> > 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 ...
>
> Well, if the docs say that they shouldn't.  When you use -C, the
> database named by -d is just the one where pg_restore initially
> connects
> to issue the CREATE DATABASE command.  Please specify where you think
> the documentation is telling you something else.
>
> regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs