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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Sunday, April 09, 2006 8:24 PM
To: Milen Kulev
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
"Milen Kulev" <makulev@gmx.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