From: | Marc Munro <marc(at)bloodnok(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Spontaneous character encoding change? |
Date: | 2006-05-23 15:45:58 |
Message-ID: | 1148399158.13655.15.camel@bloodnok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Has anyone ever seen a database spontaneously change character sets? I
could have sworn that all databases in my replication slave database
cluster were set up as SQL_ASCII. Now they are all UNICODE, and slony
is failing to replicate, due to invalid byte sequences.
Now I can't really *swear* that the databases weren't UNICODE all along
but I do know for sure:
- that I intended them to be SQL_ASCII
- that I would make an effort to avoid UNICODE until we upgrade to 8.1
- that slony has been replicating without problem on this database for
some months
The only unusual thing that has been done with that database recently is
a failed attempt to upgrade slony from 1.1 to 1.5. This was about 3
days before slony ran in to character set problems.
I have looked through the logs and found nothing of interest.
Any ideas?
This is non-production, on PostgreSQL 8.0.3
__
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Allen Fair | 2006-05-23 15:55:24 | Quering by Regular Expressions stored in table |
Previous Message | Jim C. Nasby | 2006-05-23 15:33:36 | Re: password reset |