470,614 Members | 1,400 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

PostgreSQL and HA?

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
2 2200
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
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.

Similar topics

1 post views Thread by Otis Green | last post: by
1 post views Thread by Mateusz [PEYN] Adamus | last post: by
reply views Thread by Bill J. | last post: by
29 posts views Thread by Paul Ganainm | last post: by
13 posts views Thread by Zlatko Matiæ | last post: by
1 post views Thread by phil campaigne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.