Re: Streaming replication between different OS

2021-02-22 Thread Peter J. Holzer
On 2021-02-22 23:02:12 +0530, Atul Kumar wrote: > As I am new to postgres, could you help me to in how to check collation show LC_COLLATE; > and what is de_DE locale ? The locale (i.e. language specific rules (sorting, formatting of numbers, dates, etc.) for German ("de") as spoken in Germany ("

Re: Streaming replication between different OS

2021-02-22 Thread Atul Kumar
Hi Tom, As I am new to postgres, could you help me to in how to check collation and what is de_DE locale ? Regards On Monday, February 22, 2021, Tom Lane wrote: > Ganesh Korde writes: > > On Mon, 22 Feb 2021, 11:48 am Atul Kumar, wrote: > >> I have postgres 9.6 cluster running on Cento

Re: Streaming replication between different OS

2021-02-22 Thread Peter J. Holzer
On 2021-02-22 10:36:56 -0500, Tom Lane wrote: > The other thing you have to worry about is whether the collations you > use sort the same on both systems ... if they don't, you'll have > effectively-corrupt indexes on text columns on the standby. > > According to > > https://wiki.postgresql.org/w

Re: Streaming replication between different OS

2021-02-22 Thread Tom Lane
Ganesh Korde writes: > On Mon, 22 Feb 2021, 11:48 am Atul Kumar, wrote: >> I have postgres 9.6 cluster running on Centos 6.8, so I just wanted to >> know that can I configure streaming replication with same postgres version >> i.e 9.6 running on centos 7. > Should not be a problem if both OS arc

Re: Streaming replication between different OS

2021-02-22 Thread Ganesh Korde
Should not be a problem if both OS archtecture (32 bit/ 64 bit) are same. On Mon, 22 Feb 2021, 11:48 am Atul Kumar, wrote: > Hi, > > > I have postgres 9.6 cluster running on Centos 6.8, so I just wanted to > know that can I configure streaming replication with same postgres version > i.e 9.6 run