I used rsync to create a base backup. Though I have 10 huge tables (min 1GB each) that are modified several times a second, thus creating a base backup hourly means I have to sync arround 10G each time (which is pretty time consuming). I do not want to use the standby server. This is why I am pretty happy with stop - start + recover. I cannot base backup anymore :( Is there any other possibility? I cannot use slony or buccardo as I don't control the number of databases or tables. I think the best approach is pgpool2 but there seems to be issues with sequences and those tables depend upon these sequences. Thank you On Wed, Aug 25, 2010 at 5:14 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > Dragos Valentin Moinescu <dragos.moinescu@xxxxxxxxx> wrote: > >> Where can I find information about how to modify the postgresql >> server in order to allow this in 8.2.17? > > You haven't exactly said what "this" is, but I am inferring that you > want to bring your standby up to run read-only queries once per > hour, and then resume replication? If so, you could either consider > one of the many replication solutions: > > http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling > > or you could follow your current practice, but get a fresh base > backup each time, and start the warm standby over again. If you use > rsync with a daemon you will probably be surprised how quickly you > can acquire the new base backup. > > -Kevin > -- Best regards, Dragos Moinescu -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
