Date: Sat, 16 Feb 2013 13:26:21 +0100 From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: Ports FreeBSD <freebsd-ports@freebsd.org>, freebsd-questions@freebsd.org Subject: PostgreSQL 9.2: database replication on demand - easy way (Bucardo in ports not available) Message-ID: <511F7AED.6070106@zedat.fu-berlin.de>
next in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig8ACE6BDCCFBDFDAC64A89AF9 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable Dear Sirs. I send my question to this list in the hope someone has the same problems and already found a solution. I will start explaining the background and my difficulties with recent solutions. We/I have a FreeBSD 10 box running a PostgreSQL 9.2 server containing literature references via RefDB, some sort of bugtracking via Bugzilla, several astronomical databases of the IAU (minor planet objects) and others. Those databases are kept and maintained on one single box at the department. Since a lot of the data is needed in my home office or at a lab with non-permanent internet connection, I desperately need to synchronize the databases kept on the "master" with some backup database systems acting as "master/slave" when they are online. The latter definition is fuzzy, since what I need is an automated synchronization of the "real" master with a sporadically upcoming "slave" at home or at field sites for my science where, as said, the internet connectivity isn't provided 24/7. I feel realy uncomfortable with the built-in streaming replication of PostgreSQL 9.2 since I never managed it to make a successful replication. As far as I understand, the streaming mechanism of PostgreSQL 9.X expects the "slaves" to be always online, to which the replication. I was said that Bucardo (http://bucardo.org/) would be the tool of choice, but FreeBSD ports seem not not have this tool. SLONY also is a way to complicated for my for just this task - or I'm to dumb to perform a solution that fits easily. Is someone out here who might have the same problems and already figured out how to solve this? I do not want to go into this crap "pg_dump", since I tried this many times and it failed due to some issues I never figured out why in PostgreSQL 9.2. Sorry being unspecific here, it is a long time since I tried this frustrating task and it boiled always down to some confusing "postgres/template1" issues when dumping the master and trying to update the "slave". Even following the textbook's suggestions ended up in a mess. Well, I appreaciate some hints and concepts (working, not hypothetical "could be's", those are floating enough around the FreeBSD related net). Thanks in advance and thanks for the patience, Oliver --------------enig8ACE6BDCCFBDFDAC64A89AF9 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iQEcBAEBAgAGBQJRH3rzAAoJEOgBcD7A/5N8+LEH/3JHqRDs/BpbI+k/BMr7Rla5 BCkf0PPo7iurVSIx3XwPxUzimCI3AGToIlZmuB5+EDat62BzcW2IZc5ajHWErZ7W qInE4wzO39TRNNqzotIQqTmunbYaOgJIr/srGMPaXG5h0kqLIE0mgr3Iyd/ejtU5 JpCr9fTpU8dlFPhBYkmMp5Tmg5D10cy8Ww35YJjRDseKg3mqyuu1b6szGdpCsE5k L6Ww9BMzDn1kkqvYWdnOmvhKPBGn1JLxsvpmRVcH/M8y9zCtbhVpo5/nyTnEGYVz oPFIr6UikxMXXiKylW/QXshgIPpQ80TNNP8UJJ4tKlRFIkiszsjroMZphvAgOh4= =LSbt -----END PGP SIGNATURE----- --------------enig8ACE6BDCCFBDFDAC64A89AF9--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?511F7AED.6070106>