Greetings,
> But your 8.1 cluster was UTF8? Can you please give me the output of
It wasn't, because also the system wasn't utf8 originally, but we changed the
encoding at a certain point.
> /usr/lib/postgresql/8.1/bin/pg_controldata
> /var/lib/postgresql/8.1/main|grep LC
I used pg_controldata from postgresql8.3, should be the same.
LC_COLLATE: t...@euro
LC_CTYPE: t...@euro
> /usr/lib/postgresql/8.3/bin/pg_controldata
> /var/lib/postgresql/8.3/main|grep LC
LC_COLLATE: it_IT.UTF-8
LC_CTYPE: it_IT.UTF-8
> The default mode for pg_upgradecluster is to use the same encoding as
> the old cluster. This is also checked in postgresql-common's test
> suite, so I'm fairly sure that it works in the general case.
I don't know.. the original encoding doesn't seem to be latin9, and with
latin9 i had trouble, so i should have been them before upgrading too if the
encoding was the same.
> Did you use pg_upgradecluster for this migration or used
> pg_dump/pg_restore manually?
Yes originally, but i had the unwanted result of having it Latin9, which broke
the auth from postfix/pam, so after some attempts to change the encoding
without dropping, i decided to dump, manually create a new cluster and then
importing the old data.
Bye
--
Salvo
________________________________________
/ Il test di un programma può essere \
| usato per mostrare la presenza di bug, |
| ma mai per mostrare la loro assenza. |
| |
\ -- Dijkstra /
----------------------------------------
\ ^__^
\ (oo)\_______
(__)\ )\/\
||----w |
|| ||
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
