Thread

1. Replication

   Nathan Reilly <nreilly@bigpond.net.au> — 2001-10-16T03:30:38Z

   I'm sure this is not the correct place to ask this, but:
   
   
   I've been looking for documents and other info on replication efforts in 
   PostgreSQL. If anyone here can point me to places where I can find 
   these, it would be really appreciated.
   
   Also, if any of you have any comments and warnings about current 
   implementations (if there are any) I'd like to hear those too.
   
   
   
   Many thanks
   
   
   
   Nathan
   
   
   

2. Re: Replication

   Darren Johnson <darren.johnson@home.com> — 2001-10-16T19:59:31Z

   > 
   > I've been looking for documents and other info on replication efforts 
   > in  PostgreSQL. If anyone here can point me to places where I can 
   > find  these, it would be really appreciated. 
   
   Here is some research work that was conducted a few months ago.
   
   http://gborg.postgresql.org/genpage?replication_research
   
   The project page for this research is here. 
   
   http://gborg.postgresql.org/project/pgreplication/projdisplay.php
   
   > 
   > 
   > Also, if any of you have any comments and warnings about current  
   > implementations (if there are any) I'd like to hear those too.
   > 
   It really depends on what type of replication your looking for.  
   Synchronous or Asynchronous.  Master/Slave or
   Multi-Master. 
   
   
   Darren
   
   
   

3. Re: Replication

   lockhart@fourpalms.org — 2001-10-16T23:45:31Z

   > I've been looking for documents and other info on replication efforts in
   > PostgreSQL. If anyone here can point me to places where I can find
   > these, it would be really appreciated.
   
   PostgreSQL Inc offers asynchronous one-way replication, used and proven
   in high throughput environments. The original prototype implementation
   is available as a contrib package in the PostgreSQL source tree. 
   
   I think that there are other efforts at different styles of replication
   but do not know the current status.
   
   HTH
   
                        - Thomas
   
   

4. Re: Replication

   bpalmer <bpalmer@crimelabs.net> — 2001-10-16T23:56:22Z

   > I've been looking for documents and other info on replication efforts in
   > PostgreSQL. If anyone here can point me to places where I can find
   > these, it would be really appreciated.
   
   It really depends on your replication needs.  I would suggest taking a
   look at gborg.postgresql.org for any of the replication projects there.
   There are some that work,  some that don't and some that are still in the
   works.
   
   > Also, if any of you have any comments and warnings about current
   > implementations (if there are any) I'd like to hear those too.
   
   Also in the works is adding the ability to postgresql native to do
   replication.  That is,  however,  at least as far away as the next version
   (7.3,  ~6-8 months).
   
   - Brandon
   
   ----------------------------------------------------------------------------
    c: 646-456-5455                                            h: 201-798-4983
    b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5
   
   
   

5. Re: Replication

   Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2001-10-17T03:28:17Z

   Try http://techdocs.postgresql.org/
   
   Chris
   
   > -----Original Message-----
   > From: pgsql-hackers-owner@postgresql.org
   > [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Nathan Reilly
   > Sent: Tuesday, 16 October 2001 11:31 AM
   > To: pgsql-hackers@postgresql.org
   > Subject: [HACKERS] Replication
   > 
   > 
   > I'm sure this is not the correct place to ask this, but:
   > 
   > 
   > I've been looking for documents and other info on replication efforts in 
   > PostgreSQL. If anyone here can point me to places where I can find 
   > these, it would be really appreciated.
   > 
   > Also, if any of you have any comments and warnings about current 
   > implementations (if there are any) I'd like to hear those too.
   > 
   > 
   > 
   > Many thanks
   > 
   > 
   > 
   > Nathan
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 4: Don't 'kill -9' the postmaster
   >