Re: schema creation during initdb

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: NikhilS <nikkhils(at)gmail(dot)com>
Cc: sharath kumar <k(dot)sharat(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: schema creation during initdb
Date: 2007-04-18 14:25:07
Message-ID: 46262A43.1010904@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

NikhilS wrote:
>
>
> One way that I can think of doing this would be by adding the details
> about the new schema and the tables that lie therein in the
> src/backend/catalog/information_schema.sql file (I dont know if this
> is the recommended way though). These will end up becoming a part of
> template1 and any subsequent databases that are created will contain
> them.
>

Well, *I* wouldn't recommend it. That installed version of that file
(which if anything is what he should mangle rathwer than the source) is
really just an implementation artefact.

Why would this be better than either loading the schema+table directly
into template1 after initdb, or making your own template db and loading
them into that?

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2007-04-18 14:49:06 Re: Autovacuum vs statement_timeout
Previous Message Harvell F 2007-04-18 14:08:18 Backend Crash