tag:blogs.amd.co.at,2024:/mt//feed/pgrep 2024-04-19T06:34:15Z Movable Type 4.23-en 4 1 4 tag:blogs.amd.co.at,2009:/robe//1.16 2009-05-16T00:00:23Z 2009-11-17T13:57:20Z Michael Renner http://amd.co.at/ Slony-I is a trigger-based replication solution which allows you to replicate database tables and sequences asynchronously from one master to several read-only slaves (which can also be cascaded). Trigger-based means, that each table and sequence which gets replicated has triggers... tag:blogs.amd.co.at,2009:/robe//1.15 2009-05-12T17:19:14Z 2009-05-13T08:32:07Z Michael Renner http://amd.co.at/ As we've seen in our previous example, doing log shipping with pg_standby can be quite a hassle if you take your slave servers regularly online to use them for queries and then want to resume replication again. The guys from... tag:blogs.amd.co.at,2009:/robe//1.14 2009-05-02T19:52:00Z 2009-05-07T09:07:17Z Michael Renner http://amd.co.at/ Log shipping?! PostgreSQL offers support for "shipping" it's WAL, the Write Ahead Log, where the changes of every transaction are recorded, to other database systems. The other database system then reads the changes from the WAL file and applies the... tag:blogs.amd.co.at,2009:/robe//1.13 2009-05-02T16:43:00Z 2009-05-02T18:19:34Z Michael Renner http://amd.co.at/ I want to provide an introduction, annotated examples and an easy to setup test environment for a few common and "simple" PostgreSQL replication solutions. I planned on providing images, but after what I've seen so far it seems to be...