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

Re: Problem wth postgresql.conf

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Григорий Никоноров <grigory(dot)nikonorov(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Problem wth postgresql.conf
Date: 2008-09-08 20:36:49
Message-ID: 1220906209.6179.238.camel@bnicholson-desktop (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, 2008-09-05 at 11:28 -0400, Tom Lane wrote:
> "=?KOI8-R?B?59LJx8/Sycog7snLz87P0s/X?=" <grigory(dot)nikonorov(at)gmail(dot)com> writes:
> > FATAL:  syntax error in file "/opt/PostgreSQL/8.3/data/postgresql.conf" line
> > 108, near token "MB"
> > How can i fix it ?
> 
> > shared_buffers = 128MB                  # min 128kB or max_connections*16kB
> 
> I think you need quotes here:
> 
> shared_buffers = '128MB'
> 

Pretty sure you don't need quotes (checking a running 8.3 instance -
nope, no quotes).

I'll bet you are using an older version of PG binaries to try and start
the databases.  Postgres did not recognize units like MB prior to 8.2.
If you try and start an 8.3 cluster with an older binary, it will throw
this error (I did this by mistake on a test cluster last week, I
recognize the error).

Make sure that you are using the PG 8.3 binaries.  Run 

pg_ctl --version

If that's not 8.3.x, that's your problem. 
-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


In response to

Responses

pgsql-novice by date

Next:From: Григорий НиконоровDate: 2008-09-09 08:15:06
Subject: Re: Problem wth postgresql.conf
Previous:From: Bruce MomjianDate: 2008-09-06 20:14:54
Subject: Re: looking to have 7.x behavior on 8.2/8.3

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