Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Marc Evans
On Tue, 26 Dec 2006, Ben wrote: On Dec 26, 2006, at 7:30 AM, Marc Evans wrote: What I have not been able to come up with a good semi-general purpose solution to is cross-data-center HA. Why does log shipping not work for you? Well, it may, but is short, I believe that this comes down to

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Ben
On Dec 26, 2006, at 7:30 AM, Marc Evans wrote: What I have not been able to come up with a good semi-general purpose solution to is cross-data-center HA. Why does log shipping not work for you? ---(end of broadcast)--- TIP 1: if posting/readi

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Marc Evans
On Tue, 26 Dec 2006, Shoaib Mir wrote: We are trying to achieve High Availability over load balancing, so basically we always try and have 2 databases in the same state while >>both are active, What problems do you see with Slony + Linux HA combo there? I think a Slony failover can do the sam

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Shoaib Mir
hoaib Mir > > > > > > > EnterpriseDB (www.enterprisedb.com) > > > > > > > > > > > > > > On 12/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > > > > > > wrote: > > > > > > > > > > >

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Devrim GUNDUZ
On Tue, 2006-12-26 at 15:11 +, Andy Dale wrote: > ... You guys please avoid top-posting. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plP

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Andy Dale
12/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > Thanks Chris, > > > > > > > I see you a core member of Slony team and a replication guru > > > > > > > so I'll look > >

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Shoaib Mir
hanks Chris, > > > > > > I see you a core member of Slony team and a replication guru > > > > > > so I'll look > > > > > > into it. > > > > > > I'm not slamming Slony I think its p

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Andy Dale
ably the right tool for > > > > > type of work > > > > > your company Afilias does. Just wish you would make an official > > > > > Windows > > > > > version of Slony as well. > > > > > Anyway thanks for the education, and I

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Shoaib Mir
t; > > > version of Slony as well. > > > > Anyway thanks for the education, and I think it would be a good > > > > thing if > > > > your site on replication, was also listed on Postgresql... good > > > > research. > > > > Merry Xmas

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Andy Dale
gt; Windows > > > version of Slony as well. > > > Anyway thanks for the education, and I think it would be a good > > > thing if > > > your site on replication, was also listed on Postgresql... good > > > research. > > > Merry Xmas > &

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Shoaib Mir
research. > > Merry Xmas > > > > - Original Message - > > From: "Christopher Browne" <[EMAIL PROTECTED]> > > To: < pgsql-general@postgresql.org> > > Sent: Sunday, December 24, 2006 4:23 AM > > Subject: Re: [GENERAL] Clustering & Lo

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-26 Thread Andy Dale
esearch. > Merry Xmas > > - Original Message - > From: "Christopher Browne" <[EMAIL PROTECTED]> > To: > Sent: Sunday, December 24, 2006 4:23 AM > Subject: Re: [GENERAL] Clustering & Load Balancing & Replication > > > > Centuries ago,

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-24 Thread Shoaib Mir
"Christopher Browne" <[EMAIL PROTECTED]> To: Sent: Sunday, December 24, 2006 4:23 AM Subject: Re: [GENERAL] Clustering & Load Balancing & Replication > Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: >> Suggest you download my little applicatio

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-24 Thread org
: Re: [GENERAL] Clustering & Load Balancing & Replication Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: Suggest you download my little application and read the documentation, you'll see its very different, maybe even interesting. Maybe they should change that

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: > Suggest you download my little application and read the documentation, > you'll see its very different, maybe even interesting. > Maybe they should change that to Postgres DOES HAVE a free multi-master > replication system

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread org
tastic. I will use nothing else Thanks, Johnny - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Saturday, December 23, 2006 6:34 PM Subject: Re: [GENERAL] Clustering & Load Balancing & Replication

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread Bruce Momjian
I assume you have read this new documentation for 8.2: http://www.postgresql.org/docs/8.2/static/high-availability.html --- [EMAIL PROTECTED] wrote: > >Hi, > > > >I am currently investigating the preferred method of

[GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread org
>Hi, > >I am currently investigating the preferred method of clustering a postgresql >database on Redhat? > >i would really appreciate some suggestions or experiences you guys have had. > >note: performance & redundancy are both equally desirable and i have plenty of >resources. > >we already