pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chuck Amadi <chuck.amadi@rokcorp.com>
To: postgresql <pgsql-admin@postgresql.org>
Subject: Investigating upgrading from version 8.0.1 to 8.2.3 to allow for easy replication and upgrades.
Date: Wed, 28 Mar 2007 14:23:07 +0100
Message-ID: <460A6C3B.1030302@rokcorp.com> (raw)

Hi List

My Organisation are currently investigating upgrading from version 8.0.1 
to 8.2.3 to allow for easy replication and upgrades.

The Primary database server  **houses both the TEST and LIVE Postgresql 
databases and are synchronised to a Secondary database server.

Thus I am looking at RSERV (Master/Slave concept) and pg_dumpall.

PS I also like to know about the RESRV failover concept.

Please is there any good links or gotcha's.

Cheers
Chuck


-- 
Chuck Amadi
ROK Corporation Limited
Ty ROK,
Dyffryn Business Park,
Llantwit Major Road,
Llandow,
Vale Of Glamorgan.
CF71 7PY
 
Tel: 01446 795 839
Fax: 01446 794 994
International Tel:   +44 1446 795 839

email: chuck.amadi@rokcorp.com

This email is confidential to the addressee only. If you do not believe
that you are the intended recipient, do not pass it on or copy it in any
way. Please delete it immediately.





Message-ID: <460A6C3B.1030302@rokcorp.com>
Permalink:  ../460A6C3B.1030302@rokcorp.com/
Also on:    postgresql.org/message-id/460A6C3B.1030302@rokcorp.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: chuck.amadi@rokcorp.com
  Subject: Re: Investigating upgrading from version 8.0.1 to 8.2.3 to allow for easy replication and upgrades.
  In-Reply-To: <460A6C3B.1030302@rokcorp.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox