Output of 'psql -l':
The 8.4.0 server:
List of databases
Name | Owner | Encoding | Collation | Ctype |
Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
******** | ******** | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
psql client used on the 8.4.0 server:
~$ psql --version
psql (PostgreSQL) 8.4.0
And the 8.4.2 server:
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+----------+----------+-----------+------------+-----------------------
******** | ******** | UTF8 | C | en_US.utf8 |
postgres | postgres | UTF8 | C | en_US.utf8 |
template0 | postgres | UTF8 | C | en_US.utf8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | C | en_US.utf8 |
postgres=CTc/postgres
: =c/postgres
psql client used on the 8.4.2 server:
~$ psql --version
psql (PostgreSQL) 8.4.2
Cheers,
Flo
Quoting Tom Lane <tgl@sss.pgh.pa.us>:
> "Florian Nigsch" <contact@flo.nigsch.com> writes:
>> Description: WIN1252 encoding causes server memory leak
>
> Hmm, what server-side encoding and locale are you using?
>
> regards, tom lane
>