John Sidney-Woollett <johnsw@xxxxxxxxxxxxx> writes:
> I can restore the file system backup of pgsql/data to another database
> server and then get the info from pg_database. Or I can import a dump
> file from 15 minutes before I re-inited the database...
Importing a dump will tell you nothing at all, as all the data will be
freshly loaded.
> What exactly am I looking for though?
SELECT datname, age(datfrozenxid) FROM pg_database;
where the second column approaches 2 billion.
Alternatively, wait a few weeks and note which entries in your live
database are increasing rather than staying near 1 billion.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
