[ADMIN] Gap in sequence after fail-over

2011-04-12 Thread Simon Luijk
I have two test systems with Postgresql in Hot-standby configuration. The intention is to fail-over to the slave every so often. When ever we switch servers (fail-over) and start inserting data, the primary ids have a gap of ~30. From the following thread form 2001 it seems this maybe expected? ht

Re: [ADMIN] Wal archives building up in slave pg_xlog dir

2011-03-26 Thread Simon Luijk
So I have turned archive_mode off on the slave. At first I thought this solved it but the logs are still building up. Could anyone shed some light on why the logs are building up in pg_xlog? Thank you Simon On Wednesday, 23 March 2011 at 22:16, Simon Luijk wrote: > I have a master slave se

[ADMIN] Wal archives building up in slave pg_xlog dir

2011-03-23 Thread Simon Luijk
I have a master slave setup that is on the most part working smoothly. The logs are getting shipped to the slave, the slave is requesting them and then applying them. The problem is that the logs are building up in the pg_xlog dir and not overwriting. I do have archive_mode on in postgresql.conf