Re: Problem wth postgresql.conf - Mailing list pgsql-novice

From Григорий Никоноров
Subject Re: Problem wth postgresql.conf
Date
Msg-id 1c016dc90809090115g7f7005a7i144914d6aec298d6@mail.gmail.com
Whole thread Raw
In response to Re: Problem wth postgresql.conf  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-novice
Thanks Brad! 

When i start pg_ctl from postgresql v 8.3 i have this error but how i think pg_ctl used postgresql.conf from v. 8.1.4. Next thing - completely delete Postgresql v. 8.1.4 from server. Now all fine :)

Thank you all!

2008/9/9 Brad Nicholson <bnichols@ca.afilias.info>
On Fri, 2008-09-05 at 11:28 -0400, Tom Lane wrote:
> "Григорий Никоноров" <grigory.nikonorov@gmail.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.




--
С уважением,
Никоноров Григорий

pgsql-novice by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: Problem wth postgresql.conf
Next
From: "Shabala Deshpande"
Date:
Subject: problem with group-by clause/aggreate functions