[GENERAL] Serial key mismatch in master and slave, while using slony

Hi, I am using Slony-I slony-I-2.0.2 in windows .I have a master and a slave machine. The replication is working fine. When the master switches to slave , there exists a serial key mismatch in master and slave machines. So insertion fails in the slave machines. I am using the failover comman

Re: [GENERAL] DB files, sizes and cleanup

On Fri, Dec 17, 2010 at 5:22 PM, Gauthier, Dave wrote: > max_fsm_pages = 20 > max_fsm_relations = 12000 > > There are 12 DBs with roughly 30 tables+indexes each. > > There are apparently 2 "bad" DBs.  Both identical in terms of data models > (clones with different data).  I've pg_dummped one

Re: [GENERAL] Copy From suggestion

On Friday 17 December 2010 7:46:12 am Mark Watson wrote: > Hello all, > Firstly, I apologise if this is not the correct list for this subject. > Lately, I've been working on a data conversion, importing into Postgres > using Copy From. The text file I'm copying from is produced from an ancient > pr

[GENERAL] Have any tricks not to recreate a standby server to switch to the former primary?

Hello, guys ;-) Env: PostgreSQL 8.4.5 + CentOS 4.8 I have two servers, one primary and one standby, which doing warm standby. Every thing works fine at the beginning. The primary generates the archive WAL log files and the standby fetchs them to merge. Then, I want to let the standby become prim