Clicky

Hi,

I have two PostgreSQL server's, one with ubuntu + PostgreSQL 8.3 as a master and the other with CentOS 5 + PostgreSQL 8.4 as a slave.

I want to configrure a one-way synchronization between master and slave.

How can I do this? What is the best program?

Best regards

André Bolinhas

asked 09/29/2011 02:08

abolinhas's gravatar image

abolinhas ♦♦


13 Answers:
How can I upgrade from 8.X to 9.X in ubuntu and centos ?
link

answered 2011-09-29 at 15:52:49

abolinhas's gravatar image

abolinhas

A important question before try upgrade, postgres 9.X support postgis ?
link

answered 2011-09-29 at 16:43:38

abolinhas's gravatar image

abolinhas

One way is to use the 9.1 PostgreSQL source and compile and install on your machine.
The commands are basically ./configure and make install
pg_dump can be used to create a database backup.  psql can be used to create the new database.

You'll have to recompile Postgis as well with new PostgreSQL server headers.

Postgis requrements state PostgreSQL 8.3 or higher.
link

answered 2011-09-29 at 16:44:46

earthman2's gravatar image

earthman2

My cpanel / whm don't support the postgres 9.X

I already have the 8.3.16 on both sides  (mastes and slave)

To configrure a one-way synchronization between master and slave, the slony-I is the best choise ?
link

answered 2011-10-02 at 14:29:17

abolinhas's gravatar image

abolinhas

I would highly recommend Slony.  I used it several years ago to keep three machines synchronized and it worked quite well, though the documentation wasn't as clear in some areas as I'd like.  From personal experience, it would be a good idea to have something that specifically monitors Slony, just so you're aware if it gets stuck.
link

answered 2011-10-04 at 05:37:08

crazedsanity's gravatar image

crazedsanity

I need to install slony on both server or only in master ?
link

answered 2011-10-04 at 06:32:27

abolinhas's gravatar image

abolinhas

Unless something has changed, it must be installed (and configured) on both.  It has been a few years since I've dealt with it, though.
link

answered 2011-10-04 at 06:37:37

crazedsanity's gravatar image

crazedsanity

I'm starting read slony documentation but is very very confuse and hard.

Starting i can not install on my server (master), I get this error on make
 
1:
2:
3:
slony1_funcs.c:23:23: error: miscadmin.h: No such file or directory
slony1_funcs.c:24:29: error: nodes/makefuncs.h: No such file or directory
slony1_funcs.c:25:29: error: parser/keywords.h: No such file or directory


You had this kind of problems to ?
link

answered 2011-10-04 at 07:41:40

abolinhas's gravatar image

abolinhas

Did you compile it from source?  It might be easier (though not necessarily as up-to-date) to install a package, such as using "apt-get install" in Debian/Ubuntu.
link

answered 2011-10-04 at 07:45:16

crazedsanity's gravatar image

crazedsanity

yes I compile from source.

Ok, I will try apt-get
link

answered 2011-10-04 at 09:49:30

abolinhas's gravatar image

abolinhas

just an advice on terms - you do not want synchronisation (two events happening at the same moment in time)

You are looking into database replication.

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

Or for Java-only http://c-jdbc.ow2.org/
link

answered 2011-10-04 at 09:51:22

gheist's gravatar image

gheist

Thank for help to find rubygrep.

Rubygreps works  very well on my postgres and do exactly what I need.
link

answered 2011-11-13 at 06:57:59

abolinhas's gravatar image

abolinhas

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×6
×9
×9
×4

Asked: 09/29/2011 02:08

Seen: 370 times

Last updated: 11/13/2011 07:09