RE: [SLUG] Postgresql database replication

[Rowling, Jill]

There are a few products (non-free) which claim to do what you want.
You might have a look at Bakbone and Computer Associates.
Veritas also has plug-ins for databases (can't remember if they had Postgres
though).

Regards,

Jill.

-Original Message-
From: Howard Lowndes [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 8 April 2004 11:29 AM
To: MailList-SLUG; MailList-Oz-ISP
Subject: [SLUG] Postgresql database replication


Is anyone doing database replication from Postgresql?

If so what replication tool are you using, and how do you rate it.

rsync is not suitable for this purpose.

-- 
Howard.
LANNet Computing Associates - Your Linux people 
--
Flatter government, not fatter government - Get rid of the Australian
states.
--
To mess up a Linux box, you need to work at it;
to mess up your Windows box, you just need to work on it.
 - Scott Granneman, SecurityFocus

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

--
IMPORTANT NOTICES
This email (including any documents referred to in, or attached, to this
email) may contain information that is personal, confidential or the subject
of copyright or other proprietary rights in favour of Aristocrat, its
affiliates or third parties. This email is intended only for the named
addressee. Any privacy, confidence, copyright or other proprietary rights in
favour of Aristocrat, its affiliates or third parties, is not lost because
this email was sent to you by mistake.

If you received this email by mistake you should: (i) not copy, disclose,
distribute or otherwise use it, or its contents, without the consent of
Aristocrat or the owner of the relevant rights; (ii) let us know of the
mistake by reply email or by telephone (+61 2 9413 6300); and (iii) delete
it from your system and destroy all copies.

Any personal information contained in this email must be handled in
accordance with applicable privacy laws.

Electronic and internet communications can be interfered with or affected by
viruses and other defects. As a result, such communications may not be
successfully received or, if received, may cause interference with the
integrity of receiving, processing or related systems (including hardware,
software and data or information on, or using, that hardware or software).
Aristocrat gives no assurances in relation to these matters.

If you have any doubts about the veracity or integrity of any electronic
communication we appear to have sent you, please call +61 2 9413 6300 for
clarification.
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] Postgresql database replication

[Jamie Wilkinson]

This one time, at band camp, Howard Lowndes wrote:
>Is anyone doing database replication from Postgresql?

There is a bit of software called Mammoth which I believe has been
donated to the postgresql project, but that's all I know about it.

-- 
[EMAIL PROTECTED]   http://spacepants.org/jaq.gpg
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] Postgresql database replication

[Gavin Carr]

On Thu, Apr 08, 2004 at 11:48:19AM +1000, Jamie Wilkinson wrote:
> This one time, at band camp, Howard Lowndes wrote:
> >Is anyone doing database replication from Postgresql?
> 
> There is a bit of software called Mammoth which I believe has been
> donated to the postgresql project, but that's all I know about it.

Almost. Mammoth is a commercial release of postgresql, and they have a replicator
option, which looks quite nice, but is non-free (although source available):

  http://www.commandprompt.com/entry.lxp?lxpe=304

We spent some time looking at postgresql replication again recently, and it
depends a lot on what you're wanting it for - there's at least this many
kinds of driver:

* HA/Failover (roll over to replica, usually LAN-based)
  (Master/slave, sync or async)
* Load balancing (use a number of smaller boxen)
  (Multi-master, sync or async + conflict resolution)
* Data warehousing (read replicas for insane read queries)
  (Async master/slave)
* Disaster recovery (replication to remote WAN-based servers)
  (Async master/slave or multi-master)
* Mobile servers (laptops!)
  (Async multi-master + conflict resolution)

Most of the current postgresql replication options (including the
commandprompt one) seem to handle async master-slave stuff reasonably
well, but multi-master and/or synchronous versions are non-existent
or experimental.

If that's what you need, then you probably want to go the shared
storage route instead of the application-level replication route, 
whether hardware or software based.

Cheers,
Gavin

--
Open Fusion P/L - Open Source Business Solutions [ Linux - Perl - Apache ]
ph:  02 9875 5032fax: 02 9875 4317
web: http://www.openfusion.com.aumob: 0403 171712
- Fashion is a variable, but style is a constant - Programming Perl

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html