Redoute <redoute@xxxxxxxxxxxxxx> writes: > please help me with this problem: My postgreSQL logfiles generally are > encoded in UTF-8, but some entries are in Windows-1252. The server > status in pgAdmin III doesn't cope with this; it is unusable because of > continuous error popups. > I found several discussions regarding this issue, e. g. > http://www.postgresql.org/message-id/CAD8_UcbfncTLTPeVcihXGJtGoB5BjfqBH48R3Zor0Y91Ph0hUw@xxxxxxxxxxxxxx > http://www.postgresql.org/message-id/201012211547.oBLFl3qC019008@xxxxxxxxxxxxxxxxxxxxxxxx > but unfortunately I don't understand cause and, if possible, repair. Individual server sessions will log in their database encoding, but the postmaster (parent process) will probably log in an encoding determined by its environment. You need to make sure the postmaster's environment selects a UTF8 locale. I'm not familiar with how to do that on Windows, unfortunately. 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
