Thread: postgresql.conf basic analysis tool

Is there any interest in a basic perl script that would read through a
postgresql.conf file and calculate approximate memory (and shared
memory) usage? Also, are there any other (simple for now) things I
should look at in the process? Asking because I'm getting annoyed with
doing this by hand so... 

Drew

Andrew,

Josh did something like this and I wrote some java to do some of it.  
It's in a project called pgconfigurator (I think)

dave
On 12-Jul-06, at 2:46 PM, Andrew Hammond wrote:

> Is there any interest in a basic perl script that would read through a
> postgresql.conf file and calculate approximate memory (and shared
> memory) usage? Also, are there any other (simple for now) things I
> should look at in the process? Asking because I'm getting annoyed with
> doing this by hand so...
>
> Drew
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Drew,

> Is there any interest in a basic perl script that would read through a
> postgresql.conf file and calculate approximate memory (and shared
> memory) usage? Also, are there any other (simple for now) things I
> should look at in the process? Asking because I'm getting annoyed with
> doing this by hand so...

I would really welcome your help with the Configurator project, which is 
intended to do this (among other things).

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco