Обсуждение: State of Postgresql Replication?
Is there any OSS solutions (stable) for postgresql replication for postgresql 8.0? Sincerely, Wei Weng
On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote: > Is there any OSS solutions (stable) for postgresql replication for > postgresql 8.0? Slony, pgmirror, and I think there's another one. google:postgresql replication -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Wei Weng wrote: > Is there any OSS solutions (stable) for postgresql replication for > postgresql 8.0? There is Slony http://www.slony.info/ which is OSS and Replicator which is commercial and it is at: http://www.commandprompt.com/ Joshua D. Drake > > Sincerely, > > Wei Weng > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/
On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote: > On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote: > > Is there any OSS solutions (stable) for postgresql replication for > > postgresql 8.0? > > Slony, pgmirror, and I think there's another one. > google:postgresql replication pgpool does syncrhonous query level replication, in addition to connection pooling. It also makes a good front end to slony.
On Fri, Jun 09, 2006 at 01:51:23PM -0500, Scott Marlowe wrote: > On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote: > > On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote: > > > Is there any OSS solutions (stable) for postgresql replication for > > > postgresql 8.0? > > > > Slony, pgmirror, and I think there's another one. > > google:postgresql replication > > pgpool does syncrhonous query level replication, in addition to > connection pooling. It also makes a good front end to slony. There's also PITR, depending on your needs... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
On 10/6/2006 4:37, "Jim C. Nasby" <jnasby@pervasive.com> wrote: > On Fri, Jun 09, 2006 at 01:51:23PM -0500, Scott Marlowe wrote: >> On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote: >>> On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote: >>>> Is there any OSS solutions (stable) for postgresql replication for >>>> postgresql 8.0? >>> >>> Slony, pgmirror, and I think there's another one. >>> google:postgresql replication >> >> pgpool does syncrhonous query level replication, in addition to >> connection pooling. It also makes a good front end to slony. > > There's also PITR, depending on your needs... Also look at pgcluster - you can find it at http://pgfoundry.org/projects/pgcluster/