Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
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)






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux