Bruce Momjian <[EMAIL PROTECTED]> writes: > Andrew Dunstan wrote: >> Bruce and others have suggested that PID is not sufficiently unique. > The nice things about using xid for session id is that is is unique for > a long time, rather than pid.
Hmm. Now that I think about it, InitPostgres() always runs a transaction during backend startup. If we simply saved aside the XID assigned to that transaction, it would cost next to nothing to do and would provide a reasonably unique ID. However, this happens much later than the postmaster currently prints the log_connection message ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org