Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-14 Thread Jeff Davis
On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote: > Simon Riggs writes: > > 2011/4/13 Tom Lane : > >> Short answer is to test the case you have in mind and see. > > > That's the long answer, not least because the absence of a failure in > > a test is not conclusive proof that it won't fail at so

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread Tom Lane
Simon Riggs writes: > 2011/4/13 Tom Lane : >> Short answer is to test the case you have in mind and see. > That's the long answer, not least because the absence of a failure in > a test is not conclusive proof that it won't fail at some point in the > future while in production. Not really. Eve

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread Simon Riggs
2011/4/13 Tom Lane : > Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: >> On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote: >>> Is there any limitations to configure streaming replication between >>> different operating systems i.e solaris 64 bit to RHEL 64 bit. > >> It won't work. > > As long as it'

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread AShved
since your onine logs are in different endian notation. I do not see how it would work. Sony may be an option in this case. Andrew Shved From: Tom Lane To: Devrim GÜNDÜZ Cc: raghu ram , pgsql-ad...@postgresql.org, pgsql-general@postgresql.org Date: 04/13/2011 02:14 PM Subject: Re: [ADMIN]

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread AShved
just hit me what if we use pg_standby and convert archive logs from one notation to the other. and after apply them to our standby. can this work? Andrew Shved DBA, Symcor Inc, Delivery Support Services ( Phone: 905-273-1433 ( BlackBerry: 416-803-2675 * Email: ash...@symcor.com From: Tom La

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: > On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote: >> Is there any limitations to configure streaming replication between >> different operating systems i.e solaris 64 bit to RHEL 64 bit. > It won't work. As long as it's the same machine architectur

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-13 Thread Devrim GÜNDÜZ
Hi, On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote: > Is there any limitations to configure streaming replication between > different operating systems i.e solaris 64 bit to RHEL 64 bit. It won't work. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enter