> Try on both servers:
>
> show lc_collate
>
> Unfortunately you have to initdb to set the locale. You can't set it per
> database or change it once it's initialized.
>
>
>
Right you are, but I suppose I can do a dump using pg_dumpall overwrite the cluster
with initdb --locale=en_US and restore it again without the different collation giving problems ?
Poul