Skip site navigation (1) Skip section navigation (2)

system database flag?

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: system database flag?
Date: 2009-04-23 10:29:33
Message-ID: 20090423102933.248340@gmx.net (view raw or flat)
Thread:
Lists: pgadmin-support
Hello,

in order to get a clean template1 I dropped and recreated it:

UPDATE pg_database SET datistemplate = false WHERE datname = 'template1';

DROPDB -U postgres template1

CREATEDB -U postgres -T template0 template1

UPDATE pg_database SET datistemplate = true WHERE datname = 'template1';
GRANT CONNECT ON DATABASE template1 TO public;
GRANT ALL ON DATABASE template1 TO postgres;
COMMENT ON DATABASE template1 IS 'default template database'; 

However, when I view the properties of the new template1 in pgAdmin III it isn't stated that it's a system database anymore. Is it because that the OID is different from 1 or is there a hidden flag? In pg_database I don't see any significant difference from other servers' template1?

Could you tell me, please?

Thank you very much,

Peter

P.S. I used the hints on http://www.postgresql.org/docs/8.3/interactive/manage-ag-templatedbs.html

-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01

Responses

pgadmin-support by date

Next:From: Tore HalvorsenDate: 2009-04-23 10:54:04
Subject: pgAmin 1.10 beta 2 and slony schema
Previous:From: Willy-Bas LoosDate: 2009-04-23 10:14:29
Subject: Re: pgAdmin hang on connection drop/reconnect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group