pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddbmirror
5+ messages / 4 participants
[nested] [flat]
* dbmirror
@ 2005-03-22 22:34 Edward Konetzko <konetzed@linuxworkz.com>
0 siblings, 0 replies; 5+ messages in thread
From: Edward Konetzko @ 2005-03-22 22:34 UTC (permalink / raw)
To: pgsql-admin
Hi
I was wondering if anyone is using the dbmirror stuff that come with
postgres versions >7.3.1. If so what kind of experiences have you had.
I am looking a small number < 10 tables that will contain a lot of very
important data and I would like a way to replicate it.
Thanks
Edward
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: dbmirror
@ 2005-03-22 22:49 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 0 replies; 5+ messages in thread
From: Gregory S. Williamson @ 2005-03-22 22:49 UTC (permalink / raw)
To: Edward Konetzko <konetzed@linuxworkz.com>; pgsql-admin
Edward,
We have used it for a simple mirroring of transaction data. It has worked like a champ so far, but the number of tables is low (less than 10) and the transactions tend to be inserts (common), updates (less so) and deletes rarely, none of them very frequent. The two servers are quite close physically (different racks but the same cage), and the speed of updates is reliable. We've only had to roll over from the primary to the mirror a couple of times, and both times the process was painless (going back the other way when the primary is back up is more of a pain, of course, other replicators are far better at that sort of thing; with dbmirror you have to do it manually.
Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: Edward Konetzko [mailto:konetzed@linuxworkz.com]
Sent: Tue 3/22/2005 2:34 PM
To: pgsql-admin@postgresql.org
Cc:
Subject: [ADMIN] dbmirror
Hi
I was wondering if anyone is using the dbmirror stuff that come with
postgres versions >7.3.1. If so what kind of experiences have you had.
I am looking a small number < 10 tables that will contain a lot of very
important data and I would like a way to replicate it.
Thanks
Edward
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
!DSPAM:42409b5594949384715446!
^ permalink raw reply [nested|flat] 5+ messages in thread
* DBmirror
@ 2006-12-18 09:55 amrit@health2.moph.go.th
0 siblings, 1 reply; 5+ messages in thread
From: amrit@health2.moph.go.th @ 2006-12-18 09:55 UTC (permalink / raw)
To: pgsql-admin
I would like to know whether I can set DBmirror replication from the fedora core
5_64 which postgresql8.1 was installed by rpm process not by compiling the
source. All of the component include server, contrib, perl, test, doc, devel
and lib were also rpm and what is the way to set it?
Do I need to install Pg-perl source after standard rpm process?
Anybody use postgresql with rpm and DBmirror?
Amrit
Thailand
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: DBmirror
@ 2006-12-20 07:56 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: amrit@health2.moph.go.th
0 siblings, 0 replies; 5+ messages in thread
From: Achilleas Mantzios @ 2006-12-20 07:56 UTC (permalink / raw)
To: pgsql-admin
Στις Δευτέρα 18 Δεκέμβριος 2006 11:55, ο/η amrit@health2.moph.go.th έγραψε:
> I would like to know whether I can set DBmirror replication from the fedora
> core 5_64 which postgresql8.1 was installed by rpm process not by compiling
> the source. All of the component include server, contrib, perl, test, doc,
> devel and lib were also rpm and what is the way to set it?
> Do I need to install Pg-perl source after standard rpm process?
> Anybody use postgresql with rpm and DBmirror?
>
AFAIK pgsql8.1 is the last version supporting DBMirror as a contrib package.
(So from 8.2 and on, you are left to help yourself).
And yes pgperl is needed, if you are about to use DBMirror.pl
(most likely you will use it or a variation of it).
> Amrit
> Thailand
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 5+ messages in thread
* DBmirror
@ 2006-12-22 04:34 amrit@health2.moph.go.th
0 siblings, 0 replies; 5+ messages in thread
From: amrit@health2.moph.go.th @ 2006-12-22 04:34 UTC (permalink / raw)
To: pgsql-admin
I would like to know whether I can set DBmirror replication from the fedora core
5_64 which postgresql8.1 was installed by rpm process not by compiling the
source. All of the component include server, contrib, perl, test, doc, devel
and lib were also rpm and what is the way to set it?
Do I need to install Pg-perl source after standard rpm process?
Anybody use postgresql with rpm and DBmirror?
Amrit
Thailand
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-12-22 04:34 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-22 22:34 dbmirror Edward Konetzko <konetzed@linuxworkz.com>
2005-03-22 22:49 Re: dbmirror Gregory S. Williamson <gsw@globexplorer.com>
2006-12-18 09:55 DBmirror amrit@health2.moph.go.th
2006-12-20 07:56 ` Re: DBmirror Achilleas Mantzios <achill@matrix.gatewaynet.com>
2006-12-22 04:34 DBmirror amrit@health2.moph.go.th
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