Re: [GENERAL] WAL replication wrong collate

2017-08-15 Thread Michael Paquier
On Tue, Aug 15, 2017 at 4:45 AM, basti wrote: > i have fixed. pg_update has create a wrong cluster Let's be sure that we are not talking about a bug here, because you are giving no details so it is hard to know if what you are seeing is caused by an incorrect operation, or if that's an actual bug

Re: [GENERAL] WAL replication wrong collate

2017-08-15 Thread basti
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

Re: [GENERAL] WAL replication wrong collate

2017-08-14 Thread Michael Paquier
On Tue, Aug 15, 2017 at 3:52 AM, basti wrote: > 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 how

[GENERAL] WAL replication wrong collate

2017-08-14 Thread basti
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.