Thread: Postgresql 9 replication
Good day all
I am busy testing the replication setup on Postgresql 9 as I will need to do this for a production system soon.
I have tried to do this twice now, following the postgresql documentation on the website, however to no avail as the documentation is terrible and keep on referring to other sections where you need to jump to and at the end of the day replication still isn't working. (even another dba tried to test it but no luck).
Does anybody have a proper tutorial or link to one on how to setup the replication on postgresql 9?
Has anybody done this yet with some pointers perhaps on what to look out for?
I would really appreciate the help.
Regards
Machiel
I am busy testing the replication setup on Postgresql 9 as I will need to do this for a production system soon.
I have tried to do this twice now, following the postgresql documentation on the website, however to no avail as the documentation is terrible and keep on referring to other sections where you need to jump to and at the end of the day replication still isn't working. (even another dba tried to test it but no luck).
Does anybody have a proper tutorial or link to one on how to setup the replication on postgresql 9?
Has anybody done this yet with some pointers perhaps on what to look out for?
I would really appreciate the help.
Regards
Machiel
On 11 November 2010 10:50, Machiel Richards <machielr@rdc.co.za> wrote:
What sort of replication are you attempting to achieve? Presumably streaming replication? And do you require hot standby with that?
If you want some sort of quickstart guide, you could try the wiki: http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0
I wouldn't say the documentation is terrible. More that it is too verbose when you want help to get this up and running.
Good day all
I am busy testing the replication setup on Postgresql 9 as I will need to do this for a production system soon.
I have tried to do this twice now, following the postgresql documentation on the website, however to no avail as the documentation is terrible and keep on referring to other sections where you need to jump to and at the end of the day replication still isn't working. (even another dba tried to test it but no luck).
Does anybody have a proper tutorial or link to one on how to setup the replication on postgresql 9?
Has anybody done this yet with some pointers perhaps on what to look out for?
I would really appreciate the help.
What sort of replication are you attempting to achieve? Presumably streaming replication? And do you require hot standby with that?
If you want some sort of quickstart guide, you could try the wiki: http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0
I wouldn't say the documentation is terrible. More that it is too verbose when you want help to get this up and running.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Hi
Basically we need replication to be done to a second machine in the instance that the master would fail.
I am trying to test streaming replication yes but I am not yet sure about the hot standby though. I am still awaiting confirmation on that.
I just need to get the replication working and a working document setup for it.
Thank you for the quick response by the way.
Regards
-----Original Message-----
From: Thom Brown <thom@linux.com>
To: Machiel Richards <machielr@rdc.co.za>
Cc: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Subject: Re: [NOVICE] Postgresql 9 replication
Date: Thu, 11 Nov 2010 11:23:50 +0000
On 11 November 2010 10:50, Machiel Richards <machielr@rdc.co.za> wrote:
What sort of replication are you attempting to achieve? Presumably streaming replication? And do you require hot standby with that?
If you want some sort of quickstart guide, you could try the wiki: http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0
I wouldn't say the documentation is terrible. More that it is too verbose when you want help to get this up and running.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Basically we need replication to be done to a second machine in the instance that the master would fail.
I am trying to test streaming replication yes but I am not yet sure about the hot standby though. I am still awaiting confirmation on that.
I just need to get the replication working and a working document setup for it.
Thank you for the quick response by the way.
Regards
-----Original Message-----
From: Thom Brown <thom@linux.com>
To: Machiel Richards <machielr@rdc.co.za>
Cc: pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Subject: Re: [NOVICE] Postgresql 9 replication
Date: Thu, 11 Nov 2010 11:23:50 +0000
On 11 November 2010 10:50, Machiel Richards <machielr@rdc.co.za> wrote:
Good day all
I am busy testing the replication setup on Postgresql 9 as I will need to do this for a production system soon.
I have tried to do this twice now, following the postgresql documentation on the website, however to no avail as the documentation is terrible and keep on referring to other sections where you need to jump to and at the end of the day replication still isn't working. (even another dba tried to test it but no luck).
Does anybody have a proper tutorial or link to one on how to setup the replication on postgresql 9?
Has anybody done this yet with some pointers perhaps on what to look out for?
I would really appreciate the help.
What sort of replication are you attempting to achieve? Presumably streaming replication? And do you require hot standby with that?
If you want some sort of quickstart guide, you could try the wiki: http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.0
I wouldn't say the documentation is terrible. More that it is too verbose when you want help to get this up and running.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
On 11 November 2010 11:28, Machiel Richards <machielr@rdc.co.za> wrote:
Hi
Basically we need replication to be done to a second machine in the instance that the master would fail.
I am trying to test streaming replication yes but I am not yet sure about the hot standby though. I am still awaiting confirmation on that.
I just need to get the replication working and a working document setup for it.
Thank you for the quick response by the way.
Well that wiki page I linked to should help get you up and started quickly. It covers the essentials.
You can also try: http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
Bear in mind that if you have a pre-existing cluster you're trying to replicate, you need to perform a base backup first, which is outlined here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-BASE-BACKUP
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935