From: | "Milen Kulev" <makulev(at)gmx(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Create database bug in 8.1.3 ? |
Date: | 2006-04-09 10:51:30 |
Message-ID: | 001d01c65bc3$8f0f1b00$0a00a8c0@trivadis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Listers,
I have the following problem (OS= RHELU2 , PG version= 8.1.3) when I try to Create a database :
postgres=# CREATE DATABASE world3 TEMPLATE=template1 ENCODING='UTF8' TABLESPACE=tbs1 ;
CREATE DATABASE
Then I am backup-ing the database (a small toy DB) with pg_dumpall:
pg_dumpall > alldb.bak
Less alldb.bak:
--------------------
....
CREATE DATABASE world3 WITH TEMPLATE = template0 OWNER = pg ENCODING = 'UTF8' TABLESPACE = tbs1; ....
--------------------
Why pg_dumpall is stating that my template db is template0 and not template1 ? Is there any way to check what db
(template0 or template1 ) was actually used a template when creating world2 db ? I am having the same problem with all
my databases
I have compiled and installed PG 8.1.3 from sources
Any hints are highly appreciated
Regards. Milen
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Mayrhofer | 2006-04-09 11:04:54 | index growth |
Previous Message | Ottavio Campana | 2006-04-09 06:58:44 | Re: how to document database |