Thread: About postgreSQL database Synchorization

About postgreSQL database Synchorization

From
Emi Lu
Date:
Hello all,

Could someone suggest some online documents/links about postgreSQL DB
synchronization please?

Thanks a lot,
Emi

Re: About postgreSQL database Synchorization

From
"Onyx"
Date:
Emi,
Hmm, I might be wrong but, I believe the topic you are asking about is
Replication.  Google for PostgreS(QL) Replication and see if that helps.


- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration & imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO  80524
970-482-4400 voice
970-482-4499 fax
www.i3.com


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Emi Lu
> Sent: Tuesday, October 18, 2005 8:52 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] About postgreSQL database Synchorization
>
> Hello all,
>
> Could someone suggest some online documents/links about
> postgreSQL DB synchronization please?
>
> Thanks a lot,
> Emi
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



Re: About postgreSQL database Synchorization

From
Richard Huxton
Date:
Emi Lu wrote:
> Hello all,
>
> Could someone suggest some online documents/links about postgreSQL DB
> synchronization please?

What is "DB synchronization"? Are you talking about replication?

PDF discussion by Bruce
   http://candle.pha.pa.us/main/writings/pgsql/replication.pdf
Slony
   http://gborg.postgresql.org/project/slony1/projdisplay.php
Commercial support from Command Prompt
   http://www.commandprompt.com/
Pgpool
   http://pgcluster.projects.postgresql.org/
PGcluster
   http://pgcluster.projects.postgresql.org/

They are all different, but I've tried to guess what you might find useful.
--
   Richard Huxton
   Archonet Ltd

Re: About postgreSQL database Synchorization

From
Emi Lu
Date:
Thanks all. They are very helpful!

 - Emi

> Emi Lu wrote:
>
>> Hello all,
>>
>> Could someone suggest some online documents/links about postgreSQL DB
>> synchronization please?
>
>
> What is "DB synchronization"? Are you talking about replication?
>
> PDF discussion by Bruce
>   http://candle.pha.pa.us/main/writings/pgsql/replication.pdf
> Slony
>   http://gborg.postgresql.org/project/slony1/projdisplay.php
> Commercial support from Command Prompt
>   http://www.commandprompt.com/
> Pgpool
>   http://pgcluster.projects.postgresql.org/
> PGcluster
>   http://pgcluster.projects.postgresql.org/
>
> They are all different, but I've tried to guess what you might find
> useful.



Re: About postgreSQL database Synchorization

From
"Onyx"
Date:
>
> PDF discussion by Bruce
>    http://candle.pha.pa.us/main/writings/pgsql/replication.pdf
> Slony
>    http://gborg.postgresql.org/project/slony1/projdisplay.php
> Commercial support from Command Prompt
>    http://www.commandprompt.com/
> Pgpool
>    http://pgcluster.projects.postgresql.org/
> PGcluster
>    http://pgcluster.projects.postgresql.org/
>
> They are all different, but I've tried to guess what you
> might find useful.
> --
>    Richard Huxton
>    Archonet Ltd
>

FYI: There was a typo on one of Richard's URLs.  Pgppool's site should be
http://pgpool.projects.postgresql.org/ .  Thanks for the links Richard.


- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration & imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO  80524
970-482-4400 voice
970-482-4499 fax
www.i3.com