Re: Problem wth postgresql.conf

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(at)ca(dot)afilias(dot)info>

> 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.
>
>

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