Re: shrinking the postgresql.conf - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: shrinking the postgresql.conf
Date
Msg-id 42F784DB.2030500@commandprompt.com
Whole thread Raw
In response to Re: shrinking the postgresql.conf  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: shrinking the postgresql.conf  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
> Well, if you want PostgreSQL to act a specific way, then you are going to
> have to set up the defaults somehow, right?

Of course, which is why we could use a global table for most of it.

> 
> Which is cleaner? Using a configuration file which is going to be there
> anyway, or trying to rig-up some sort of autostart.sql mechanism to put
> PostgreSQL into its desired state?

Initdb could easily create this as part of the catalog/cluster.

> 
> I periodically get into arguments on hackers because I want *more* options
> available in postgresql.conf

Then I think we will have to agree to disagree ;).

> 
> My dream is to start postgres like:
> 
> /opt/postgres/bin/postmaster --config-file=/opt/postgres/bases/tiger.conf
> or
> /opt/postgres/bin/postmaster --config-file=/opt/postgres/bases/zipcode.conf

You can do that easily if you have multiple catalogs which is what we do 
when we want that.

> 
> I also want an include directve that allows production or debugging
> settings to be easily used.
> 

Such as?

Sincerely,

Joshua D. Drake




-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: shrinking the postgresql.conf
Next
From: Tom Lane
Date:
Subject: Re: shrinking the postgresql.conf