LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 12-29-2009, 10:53 AM   #1
Kropotkin
Member
 
Registered: Oct 2004
Location: /usr/home
Distribution: Fedora, Mint, FreeBSD, Android
Posts: 348

Rep: Reputation: 31
postgresql-8.4.2 error: unrecognized configuration parameter "max_fsm_pages"


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.
 
Old 12-29-2009, 11:57 AM   #2
nileshgr
Member
 
Registered: Aug 2007
Location: Pune, Maharashtra, India
Distribution: Gentoo
Posts: 84

Rep: Reputation: 16
Its using some other config file probably. Try to specify the config file on the command line with the corrected one and check again.
 
Old 12-29-2009, 12:22 PM   #3
Kropotkin
Member
 
Registered: Oct 2004
Location: /usr/home
Distribution: Fedora, Mint, FreeBSD, Android
Posts: 348

Original Poster
Rep: Reputation: 31
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.

Last edited by Kropotkin; 12-29-2009 at 12:29 PM.
 
  


Reply

Tags
postgresql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
youtube-dl "t" parameter error mark_alfred Linux - Software 3 07-22-2010 02:40 AM
cc1: error: unrecognized command line option "-mapcs-32" vengat Linux - Hardware 0 04-29-2008 03:18 AM
[SOLVED] How can I fix "Error: BadWindow (invalid window parameter)" ShellyCat Linux - Desktop 1 08-17-2007 10:42 AM
getting "X Error: BadWindow (invalid Window parameter)" dipk_23 Programming 1 05-01-2007 12:43 PM
Postgresql error FATAL: user "root" does not exist" cgetty Ubuntu 4 06-21-2005 03:11 PM


All times are GMT -5. The time now is 06:05 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration