From what I currently understand, there is a pg_log file in the postgres
data directory which indicates the state of transactions (committed or
uncommitted).
So from this I infer that transaction IDs are unique across a whole database
installation?
The reason I ask is that I rename the directories within the data directory
to rename a database. (I need to switch two databases reasonably quickly).
If transaction IDs (and hence entries within pg_log) are not shared then the
results would be catastrophic probably.
Any ideas?
--
Martijn van Oosterhout
