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.0I 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