[pgadmin-support] strange select issue

2010-05-27 Thread Kevin Kempter
Hi All; We have a local postgres database (8.3.x) with an application / web front end pulling data from it. THe database server is on the east coast, we also have a remote application server in the UK. We can run a select from one of our configuration/meta-data databases (via the app) locally

[pgadmin-support] view the remining # of TX ID's available per db (before TX ID wraparound failure)

2009-06-23 Thread Kevin Kempter
Hi all; I want to be sure we know exactly how close we are to a tx id wraparound failure. I ran this: select datname, age(datfrozenxid) from pg_database; I assume the resulting value is the number of available tx id's left per db, is this correct? Also is there a way in 8.3 to determine whi

[pgadmin-support] view the remining # of TX ID's available per db (before TX ID wraparound failure)

2009-06-23 Thread Kevin Kempter
Hi all; I want to be sure we know exactly how close we are to a tx id wraparound failure. I ran this: select datname, age(datfrozenxid) from pg_database; I assume the resulting value is the number of available tx id's left per db, is this correct? Also is there a way in 8.3 to