Re: [Gnumed-devel] Information and config files

[Karsten Hilbert]

On Sat, Sep 06, 2008 at 09:55:35AM -0400, Geordie wrote:

> address@hidden:~# apt-get install postgresql-8.3
> address@hidden:~# apt-get install postgresql
> address@hidden:~# apt-get install postgresql-contrib
> address@hidden:~# pg_lsclusters
> Version Cluster   Port Status Owner    Data directory                     Log 
> file
> 8.3     main      5432 online postgres /var/lib/postgresql/8.3/main       
> /var/log/postgresql/postgresql-8.3-main.log

Looks good !

> address@hidden:~# nano /etc/postgresql/8.3/main/pg_hba.conf

> # Database administrative login by UNIX sockets
> # allow some people to impersonate "postgres" when connecting to template1
> local   template1       postgres                        ident postgres-alikes
> # replace N with the database version you want to install
> local   gnumed_vN     postgres                       ident postgres-alikes

Delete the above line.

> address@hidden:~# nano /etc/postgresql/8.3/main/postgresql.conf
...
> Question:
> Autovacuum should that be enabled?

Yes, that's a good idea.

> I have been doing a little reading in the Postgres Manual. Lets just say this 
> is not high on my list of enjoyable reading. And there are too many variables 
> to deal with and when 
> you do not play with it on a regular basis, it is a tough grind.
Don't worry about it. Sidux should have taken care of
configuring PG reasonably for an "average PC".

> Any way these things that are mentioned below, I have not created or seen 
> created. I am assuming the bootstrap has 
> something to do with this.
Correct. The bootstrapper takes care of it.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346