By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,175 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,175 IT Pros & Developers. It's quick & easy.

PostgreSQL and HA?

P: n/a
Hi,
Just having read http://developer.postgresql.org/todo.php - seems
like quite a few features for high availibility are still
missing. So - what's the recommended way to get some kind of HA
up and running using PostgreSQL at the moment? How much HA will I be
able to get?

Please Cc me on Replies (I'm not subscribed to this list and
might miss something).

Bye,
Thomas

--
Thomas Köhler Linux without limits: http://linux.s390.org/
Millenux GmbH http://www.millenux.de/ th************@millenux.de
Lilienthalstraße 2 phone: +49.711.88770.300
D-70825 Stuttgart-Korntal fax: +49.711.88770.349

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/SiIETEYXWMJlHuYRAuqpAJ9qgVLwWD0FTYKlO7TY0cQYvoJ8bg CdHGHm
+1kmz2okpp3yteUZTvQZkF4=
=scbc
-----END PGP SIGNATURE-----

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Thomas Köhler wrote:
-- Start of PGP signed section.
Hi,
Just having read http://developer.postgresql.org/todo.php - seems
like quite a few features for high availibility are still
missing. So - what's the recommended way to get some kind of HA
up and running using PostgreSQL at the moment? How much HA will I be
able to get?


You can get master/slave replication from /contrib/dbmirror or
/contrib/rserv.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #2

P: n/a
You can do HA from the OS level:

Have a SCSI disk array shared between two computers
Use a journalling filesystem on this array
Have a "serial kill switch"
Have a program that checks if each server is alive.
If the primary goes down, the secondary will:
a) Shut off the power to the primary
b) Mount the disks
c) Start necessary services
d) Do IP takeover of the main server's IP address

The "serial kill switch" is necessary when disk arrays are being shared,
so that two computers don't inadvertantly access the disk array at the
same time. That way, if the problem is just a comm problem between the
computers, the primary will be killed off completely, and not be able to
cause problems.

There are packages that automate parts of it, and if this is of interest
to you, I can find some good articles on it. Personally, I've found that
using a stable operating system, hardware with hotswappable drivers/power
supplies, power coming in from two different circuits, and a UPS, will
give you almost as much uptime, with less difficulty and cost.

Jon
On Mon, 25 Aug 2003, Thomas [iso-8859-1] Köhler wrote:
Hi,
Just having read http://developer.postgresql.org/todo.php - seems
like quite a few features for high availibility are still
missing. So - what's the recommended way to get some kind of HA
up and running using PostgreSQL at the moment? How much HA will I be
able to get?

Please Cc me on Replies (I'm not subscribed to this list and
might miss something).

Bye,
Thomas

--
Thomas Köhler Linux without limits: http://linux.s390.org/
Millenux GmbH http://www.millenux.de/ th************@millenux.de
Lilienthalstraße 2 phone: +49.711.88770.300
D-70825 Stuttgart-Korntal fax: +49.711.88770.349

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.