From: | Gregory Wood <gwood(at)ewebengine(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.4.1 Server Not Starting? |
Date: | 2004-01-05 19:30:52 |
Message-ID: | 3FF9BB6C.9040407@ewebengine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>Perhaps a combination of those settings is what did it?
>
> Maybe --- what was the failure message exactly, once you got it?
Managed to fix it before I got any errors actually. Simple enough to
re-break it however:
FATAL: max_fsm_pages must exceed max_fsm_relations * 16
Looks like I was 60000 short on my 100000 max_fsm_pages setting for a
max_fsm_relations of 10000. Anyway, the error message was a good one, I
just couldn't get to it last night.
> Also, if you hand-edited these settings, it's fair to ask what
> the port package defaults are ...
Sounds fair to me, IIRC:
max_connections = 100
shared_buffers = 1000
max_fsm_relations = 1000
max_fsm_pages = 20000
sort_mem = 1024
vacuum_mem = 8192
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2004-01-05 19:35:52 | Re: Announce: Search PostgreSQL related resources |
Previous Message | Peter Eisentraut | 2004-01-05 19:15:09 | Re: Photos of PostgreSQL booth |