From: | basti <basti(at)unix-solution(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: WAL replication wrong collate |
Date: | 2017-08-14 19:45:22 |
Message-ID: | 64af2572-724d-f1ae-22b3-bdda903a39b5@unix-solution.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
i have fixed. pg_update has create a wrong cluster
On 14.08.2017 20:52, basti wrote:
> Hello,
>
> i try to replicate my database. what i have done?
>
> - create a cluster on slave (UTF8, en_US.utf8 collate/c_type)
> - stop cluster and cleanup datadir
> - do basebackup from master
> - start db-cluster
>
> Master has utf8, en_us.uft8 collate/c_type
> Now my db on slave has UTF8, c.utf8 collate/c_type.
> Whats wrong here?
>
> master and slave had set the same locales.
> I dont unterstand that i can create a database in en_us.utf8 and then
> when i did the basebackup it's change to c locale.
> I cant find any option for pg_basebackup to set locale/collate.
> I use this howto
> https://wiki.postgresql.org/wiki/Streaming_Replication and had install
> an other cluster in the past with successful.
>
> How can help please?
>
> Best regards,
> basti
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | stimits | 2017-08-14 22:30:32 | Re: Queries for Diagramming Schema Keys |
Previous Message | Scott Marlowe | 2017-08-14 19:34:56 | Re: Queries for Diagramming Schema Keys |