Skip site navigation (1) Skip section navigation (2)

Re: postgresql.conf

From: Steve Wampler <swampler(at)noao(dot)edu>
To: John Cunningham <fatbobo(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql.conf
Date: 2004-12-22 16:01:22
Message-ID: 41C99A52.206@noao.edu (view raw or flat)
Thread:
Lists: pgsql-general
John Cunningham wrote:
...
> The machine in question will do nothing but serve databases.  It's a
> dual 3.2Ghz Xeon with 100GB or 15K RPM RAID 5 and 8 GB of RAM.  I'd
> like to configure it to get the most out of the server possible as far
> as shared memory, sort memore, etc.  I haven't found a lot of
> documentation on this.

What OS?

> By the way, for some reason Postgres 7.4.x wouldn't install properly -
> had a problem with initdb - had to use 7.3.6

I had a similar problem under Fedora Core 3 that Tom Lane solved quickly
for me.  From my notes:

    Run '/usr/sbin/setenforce 0' before intializing database.
    Ok to turn back on with '/usr/sbin/setenforce 1' afterwards.

Has to do with the Fedora using SELinux by default now.

Dunno if that is your situation...

-- 
Steve Wampler -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-12-22 16:05:52
Subject: Re: 8.0 Beta3 worked, RC1 didn't!
Previous:From: Frank D. Engel, Jr.Date: 2004-12-22 15:59:43
Subject: Re: postgresql.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group