Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )

Hi Tom,
There are no error messages repored. Neiter in the logfile of the server, nor on
The tty , which I am issuing the commands from.
I am not switching the OS user (all commands are entered interactively, no cron jobs, shell scripts etc).

Regeards, Milen

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Sunday, April 09, 2006 8:24 PM
To: Milen Kulev
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )

"Milen Kulev" <makulev(at)gmx(dot)net> writes:
> I am getting the commands you mention:
> pg_restore -C -Fc tdb1b.bak 1> OUT
> Less OUT:

> CREATE DATABASE testdb1 WITH TEMPLATE = template0 ENCODING = 'UTF8'
> TABLESPACE = tbs1; ALTER DATABASE testdb1 OWNER TO pg; \connect
> testdb1 ...

> , but testdb1 is NOT created !

So why not? Try reading the error messages that are (probably) reported when you run the script. Maybe you're trying
to run the script as a user that hasn't got CREATEDB privilege?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings