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
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
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