Re: Smaller template database? - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Smaller template database?
Date
Msg-id Pine.LNX.4.33.0308010912570.29728-100000@css120.ihs.com
Whole thread Raw
In response to Smaller template database?  ("Jeremy Trammell" <jtrammell@rpco2.com>)
Responses Re: Smaller template database?
List pgsql-admin
On Fri, 25 Jul 2003, Jeremy Trammell wrote:

> Hi all,
>
> I am trying to use PostgreSQL as an embedded SQL database server, but
> the 30 meg installation size is killing me...  A quick scan of the
> various docs/FAQs around here have made no mention of any way to trim
> down that template database.  Am I missing something?  Why must it be so
> large?

Are you sure all that is the template0/1 databases?  With WAL segments
taking 16 Megs by default, that may be half of it.

If you're looking for a better choice for imbedding, look at firebird.

http://sourceforge.net/projects/firebird/

It's got a much smaller footprint and doesn't require as much regular
daily maintenance as Postgresql does.


pgsql-admin by date:

Previous
From: "Chris White (cjwhite)"
Date:
Subject: Problem restoring large objects with pg_restore
Next
From: Andrew Sullivan
Date:
Subject: Re: Starting PostgreSQL server as root