Re: roll back to 8.1 for PyQt driver work-around

Поиск
Список
Период
Сортировка
От Scott Frankel
Тема Re: roll back to 8.1 for PyQt driver work-around
Дата
Msg-id A98A6E98-0E1B-45A8-B94E-E8AD84A0B0AA@circlesfx.com
обсуждение исходный текст
Ответ на Re: roll back to 8.1 for PyQt driver work-around  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: roll back to 8.1 for PyQt driver work-around  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Sorry to drag this on further.  Though I'm now able to start pg8.3
again (thanks!), I still can't launch pg8.1.  Rolling back to 8.1 is
my goal in order to work around a driver issue in Qt.

Is there an example postgresql.conf file for pg 8.1 I can review?
Mine appears to be valid only for pg8.3.

Adding quotes to the shared_buffers value allows pg8.3 to start
successfully.  Unfortunately, pg8.1 continues to have issues with it.
eg:


FATAL:  syntax error in file "/Library/PostgreSQL8/data/
postgresql.conf" line 107, near token "kB"
FATAL:  parameter "shared_buffers" requires an integer value
FATAL:  unrecognized configuration parameter
"default_text_search_config"

Thanks again!
Scott




On Jul 6, 2008, at 10:48 AM, Tom Lane wrote:

> Scott Frankel <frankel@circlesfx.com> writes:
>> When I try to start 8.3, the log file lists a fatal error in the
>> postgresql.conf file.  But there are no obvious errors in that file.
>> Line 107 reads:  "shared_buffers = 1600kB".
>
> You need quotes, like
>     shared_buffers = '1600kB'
>
>> FATAL:  incorrect checksum in control file
>
> This looks like a version compatibility problem, though I'm surprised
> it wasn't complained of earlier.
>
>             regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Scott Frankel
President/VFX Supervisor
Circle-S Studios
510-339-7477 (o)
510-332-2990 (c)





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


В списке pgsql-general по дате отправления:

Предыдущее
От: "Eric Bangug"
Дата:
Сообщение: Re: Quick way to alter a column type?
Следующее
От: Dushyanth
Дата:
Сообщение: Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?