Re: 7.4.1 Server Not Starting?

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

In response to

Browse pgsql-general by date

  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