I had noticed in a previous post the following information:
NOTICE: Unrecognized variable client_encoding
It means you're running a MULTIBYTE-enabled psql (or more specifically
libpq) against a non-MULTIBYTE server. Perhaps you are invoking a copy
of libpq from an older installation that was compiled with different
configure options.
The notice is harmless enough, but you may want to get your client and
server into sync...
NOTICE: Unrecognized variable client_encoding
It means you're running a MULTIBYTE-enabled psql (or more specifically
libpq) against a non-MULTIBYTE server. Perhaps you are invoking a copy
of libpq from an older installation that was compiled with different
configure options.
The notice is harmless enough, but you may want to get your client and
server into sync...
I'm running into the same error message & I'm not sure how I got my client
and server out of sync.
I did an install of 7.0.3 on a RedHat Linux 6.2 box that has had all
previous versions of postgreSQL removed.
When I configured it, I did ./configure --with-perl --with-odbc
--enable-syslog --enable-debug --enable-cassert . Since my database will
not need any multibyte characters, I specifically did not use
--enable-multibyte. My regression test went great, and after I edited the
system's sysctl.conf to set the shmall and shmmax, postmaster started up
like a trooper. I then did the quickie test of
$ createdb
$ psql
postgres=>SELECT datetime 'now';
postgres=>\q
$ destroydb
When I did the create and the destroy, I got the "Unrecognized variable
client_encoding" notice, so obviously I'm out of sync. The question is how
did I get that way?
I also tried recompiling with the multibyte enabled. This time I got an
error along the lines of : multibyte is not enabled.
Your installation may not have been successful.
Any suggestions?
Thanks.
