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

Streaming replication between different OS

2021-02-21 Thread Atul Kumar
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 running on centos 7. Suggestions are welcome as the Centos versions are different one is 6.8 and second one is 7. Also please let me know