system database flag?
От | Jan-Peter Seifert |
---|---|
Тема | system database flag? |
Дата | |
Msg-id | 20090423102933.248340@gmx.net обсуждение исходный текст |
Ответы |
Re: system database flag?
|
Список | 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 significantdifference 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
В списке pgadmin-support по дате отправления: