[ADMIN] PostgreSQL Replication Using slony [Rejoining a node after failover]

2010-10-22 Thread Vishnu S.
Hi, I am using Slony-I 2.0.4 with PostgreSQL 8.4 in windows XP. I have replicated the data from a master (say A ) to a slave machine(say B). And when the Master machine A fails, the slave machine B, acts as Master machine and the node corresponding to master is dropped using DRO

[ADMIN] Can't remove filter when no rows returned

2010-10-22 Thread maiesky
pgAdmim 1.12 on WinXP SP3 but this issue was observed in previous releases also When in table view window applied filter and no rows returned (no row matches the filter rull) then it is not possible to fire context menu of the grid and pick up "Remove filter". In order to reload all rows one needs

[ADMIN] Unable to backup table when quotation marks used in the name

2010-10-22 Thread maiesky
I am running pgAdmim 1.12 on WinXP SP3 but this issue was observed in previous releases also. When trying to do a backup of a table which has quotation marks in its name or in schema name then getting error: (example1 quotation marks in schema name) C:\Program Files\pgAdmin III\1.12\pg_dump.exe --

Re: [ADMIN] autovacuum launcher process eating up 17G+ of ram?

2010-10-22 Thread Kevin Grittner
Nick wrote: > Here is a vmstat 1 right after postgres has been started: > > procs ---memory-- > r b swpd free buff cache > 0 0 55480 760172 1709424 3758492 > Here is another chunk after it's been running for about 18 hours: > > procs ---memory-- >

Re: [ADMIN] autovacuum launcher process eating up 17G+ of ram?

2010-10-22 Thread Nick
Yes I was using top, but I am not adding up anything. I'm only ever looking at the one process called "postgres: autovacuum launcher process", not any of the other postgres processes. Here is a vmstat 1 right after postgres has been started: procs ---memory-- ---swap-- -io---