1

I have PostgreSQL 8.4 installed on a headless Ubuntu 10.04 server. Sometimes the server is not available. I would like to continue working on the database, so I thought of installing PostgreSQL onto my laptop. I'm familiar with PostgreSQL, but not with replication. Would I setup replication so that the two databases are kept synchronized when the server becomes available again? This does not need to be automated. What is the easiest and simplest approach? The database is not used extensively by others at this stage and is small, so a simple, lightweight solution would be adequate.

1 Answer 1

1

For reference, one of these may be suitable:

A general discussion of replication and clustering in PostgreSQL is here.

There are also many questions on StackOverflow and this useful one on ServerFault.

9
  • An update to to 9.1 which offers out-of-the-box asynchronous and synchronous replication is also an option.
    – user1822
    Jun 25, 2012 at 21:10
  • I considered that. Ubuntu 10.04 provides PostgreSQL version 8.4 from the repositories. I don't know how involved installing a different version would be.
    – SabreWolfy
    Jun 25, 2012 at 21:23
  • I will never understand why Linux makes it so hard to install up-to-date software. Can't you just download the RPM's (or whatever is needed for Ubuntu) from the Postgres website?
    – user1822
    Jun 25, 2012 at 22:34
  • Ubuntu 10.04 is a long-term support (LTS) release. Ubuntu, like most distributions, provides versions of software in the repositories for "easy" installation. The paradigm is different to Windows. Other versions of Debian (testing/unstable) and other distributions provide "always-updated" rolling releases which will have the latest versions of software. This is not what you would want on a server though, where you want stability. The next LTS release of Ubuntu, released recently, includes PostgreSQL 9. This would be the natural upgrade route.
    – SabreWolfy
    Jun 25, 2012 at 22:49
  • Not that I'm about to upgrade "just" for replication functionality, but here is a link for .deb packages for PostgreSQL 9: openscg.com/se/postgresql/packages.jsp
    – SabreWolfy
    Jun 25, 2012 at 23:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.