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