Re: BUG #2804: Incorrect encoding of comment in backup of UTF8 database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marcin Waldowski" <M(dot)Waldowski(at)sulechow(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2804: Incorrect encoding of comment in backup of UTF8 database
Date: 2006-12-02 16:36:30
Message-ID: 14222.1165077390@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Marcin Waldowski" <M(dot)Waldowski(at)sulechow(dot)net> writes:
> When I make a backup of UTF8 database then pg_dump add some comment to
> backup file:
> -- Started on 2006-11-30 16:01:15 srodkowoeuropejski czas stand.

This has been fixed for 8.2 by the expedient of omitting the timezone
from the comment when running on Windows. However, you should take a
closer look at your locale settings --- the fact that it's coming out in
an encoding other than UTF8 says to me that you're running the database
with incompatible locale and encoding, which is going to cause other
problems.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message carmelo 2006-12-02 18:44:23 BUG #2805: restore backup
Previous Message Marcin Waldowski 2006-12-02 12:45:26 BUG #2804: Incorrect encoding of comment in backup of UTF8 database