[ADMIN] process 22254 acquired ShareLock on transaction

2011-11-02 Thread Erdinc Akkaya
Hi, I've googled but couldn't find solution. on postgresql logs. I see those messages. < db:modna time=2011-11-02 10:35:44.184 EET>LOG: process 22254 acquired ShareLock on transaction 45479426 after 308021.895 ms < db:modna time=2011-11-02 10:35:44.184 EET>ERROR: duplicate key value violates un

Re: [ADMIN] streaming replication

2011-11-02 Thread Karuna Karpe
But I want huge amount of data in database. so it is take so much to take dump from slave db and load in master db. for example :- I have one master db server with 20GB of data and two slave db server are replicated from master server. when my master db server is fail, then one of slave s