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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Milen Kulev" <makulev(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Date: 2006-04-09 18:24:15
Message-ID: 12512.1144607055@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Hamill 2006-04-09 18:27:19 Re: Load testing across 2 machines
Previous Message Milen Kulev 2006-04-09 18:15:42 Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )