Обсуждение: replication
Hello I want to add replication capabilities to my postgresql installation. Can anyone recommend a good way (open source or otherwise) to do so? Basically, I have a web tracking application that must quickly and reliably store massive amounts of tracking data. Later, I run complex queries to analyze this tracking data. These complex queries tend to be very resource intensive, so I'd like to have them run on a separate machine altogether. I need a simple and reliable method to 'copy' any data added to the tracking database to the analysis database. Preferably, I'd be able to configure this copy process to defer to high priority queries or to be considerate of the time of day. Thanks, Peter T. Brown
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday, January 11, 2002, at 09:27 AM, Peter T. Brown wrote: > Hello > > I want to add replication capabilities to my postgresql installation. > Can > anyone recommend a good way (open source or otherwise) to do so? I read this the other day, but haven't used it (And I suspect the document may need an update) http://techdocs.postgresql.org/techdocs/settinguprserv.php The document only describes replication between databases on one server though.. Other people here probably have more experience with rserv and can let you know what its status is. - -- Best Regards David Stanaway ================================ Technology Manager Australia's Premier Internet Broadcasters Phone: +612 9357 1699 Fax: +612 9357 1169 Web: http://www.netventures.com.au Support: support@netventures.com.au ================================ The Inspire Foundation is proudly supported by Net Ventures through the provision of streaming solutions for it's national centres. The Inspire Foundation is an Internet-based foundation that inspires young people to help themselves, get involved and get online. Please visit Inspire at http://www.inspire.org.au -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (Darwin) Comment: For info see http://www.gnupg.org iQEXAwUBPD4lSr6yIDFGeSAyFALYPQP8CuuS4pRHicYDVJSpJosJa8A9CqSxMkkd kqsMELbPUKSfMDsRSXoRtRYGOoymKqf6bPru5TbyPJHBIGGTJMRLuPRkvqVWitK1 l3zjMWmBzrrUB7rPa0WR35YQ9jVVSEP87I3z623d+vDG8VluBG6dKMKuMgGURb76 t1po5JtLpYAD/0BLlg9zUsPrwl70Z2b8ctXF3u2Xv2m8inSr+4qtqlgYLkLsrUih Lv9usaNXcIrY9of5v/PBNEAmY9DlN1fhjm0Zw6vTnzrlP/EDhWSdX7omAFGaBUi7 9XWuOVcrd7iqizmxzqsN+TGbodlGsEgmfMbJMwLY90gUx/t8d3aWQREj =EbMK -----END PGP SIGNATURE-----