Thread: PostgreSQL Databse Migration to the Latest Version and Help for Database Replication.

Hello,

I am Java Solutions Developer. I have my servers that run PostgreSQL v8.1.11 and they are quit stable.
Recently i was supposed to install a Database Replication tool for the Databases. I realized that i might have to upgrade my database from v8.1 .11 to v8.4
1) Would there be any compatibillity issue if i do this migration at one shot?

2) I have my Java Code that is very vast and it has at many places the PostgreSQL queries well compatible with the current running version( i.e v8.1.11), would the Migration need some changes to be done in the queries?

3) Are there any compatibility mismatch from the version 8.1.11 to the version 8.4 or 8.3

4) Following are the details of the platform on which i have my project running:
    Operating System: CentOS v5.1
    Java Version: v1.4 for the Java Code.
    Web Server: tomcat4
    PostgreSQL Version: PostgreSQL v8.1.11

5) I want to implement a Master-Slave Replication system, and found that SLONY-I is the best that matches with PostgreSQL database system. But this is advisable in an environment where none of the master/slave(s) are having a problem of being detached from the network or frequent power failures. Here with my project this is the case.
Can you suggest a good database replication tool that would replicate my postgreSQL databases it cud be a master-master DB replication tool as well. Not  a problem.
I have tried RubyRep, Bucardo, but none of these have a stable rpm release for CentOS version of Linux Operation System.


Need Help Urgently.

Thanks in advance.

Regards,
Krishna Komarpant
Java Solutions Developer
Online Productivity Solutions Pvt. Ltd.
Verna - Goa
India

Krishna Komarpant wrote:
> Hello,
>
> I am Java Solutions Developer. I have my servers that run PostgreSQL
> v8.1.11 and they are quit stable.
> Recently i was supposed to install a Database Replication tool for the
> Databases. I realized that i might have to upgrade my database from v8.1
> .11 to v8.4

You should be running a newer 8.1 release - it's up to 8.1.17. There are
only bugfixes in that branch, no new features - so you won't have any
issues just upgrading postgres.

> *1) _Would there be any compatibillity issue if i do this migration at
> one shot_?*

Probably. 8.3 introduced some stricter type and language checking (eg
stricter checks for utf8 characters) and I'm sure 8.4 did on top of
that. Check the changelogs:

http://www.postgresql.org/docs/current/static/release.html

<snip same question asked again>

> *5) *I want to implement a Master-Slave Replication system, and found
> that SLONY-I is the best that matches with PostgreSQL database system.
> But this is advisable in an environment where none of the
> master/slave(s) are having a problem of being detached from the network
> or frequent power failures. Here with my project this is the case.
> *_Can you suggest a good database replication tool that would replicate
> my postgreSQL databases it cud be a master-master DB replication tool as
> well. Not  a problem_.
> *I have tried *RubyRep, Bucardo, *_but none of these have a stable rpm
> release for CentOS version of Linux Operation System_.

No idea about that one unfortunately.

--
Postgresql & php tutorials
http://www.designmagick.com/

On Jul 20, 9:29 am, dmag...@gmail.com (Chris) wrote:
> > *I have tried *RubyRep, Bucardo, *_but none of these have a stable rpm
> > release for CentOS version of Linux Operation System_.
Just to mention this: rubyrep comes with a bundled package.
     http://www.rubyrep.org/installation.html
Just unzip and it will work*. No need to hunt down libraries or
something like this.

*: rubyrep requires JDK >= 1.5. But that's it.

Best Regards,
  Arndt