postgresql-8.4.2 error: unrecognized configuration parameter "max_fsm_pages"

Kropotkin · 12-29-2009, 09:53 AM

Hi all,

I have postgresql running under FreeBSD on a small home server. I upgraded a number of ports, including postgres client and server, bringing postgres to v8.4.2.

Alas when I try to restart the database, I get an error message:

Code:

FATAL:  unrecognized configuration parameter "max_fsm_pages"

I Googled this and it appear the following two lines in the configuration file are obsolete:

Code:

#max_fsm_pages = 20000          # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000       # min 100, ~70 bytes each

So I deleted them, both from /etc/postgresql.conf and /usr/local/etc/postgresql.conf

However, I still see the same error message when I try to restart postgres. Any idea what is going on here?

Thanks.

nilesh.3892 · 12-29-2009, 10:57 AM

Its using some other config file probably. Try to specify the config file on the command line with the corrected one and check again.

Kropotkin · 12-29-2009, 11:22 AM

Found it; the config file was in: /usr/local/pgsql/data

Because the read permissions of that directory are rather restrictive, it didn't turn up in "locate" searches.