Re: IDENTIFY_SYSTEM

> That's part of the streaming replication protocol
>
> http://www.postgresql.org/docs/9.3/static/protocol-replication.html
> As long as you're using wal_level >= archive and the replication connection is enabled you can retrieve it via psql

Yes, I know, but there is no way to get the systemid value from a function using just SQL or plpgsql?

> If it's just for licencing perhaps inet_server_addr() or a plperl function to grab the mac address of the machine
mightsuffice? 

I have to license each database, not just the whole machine. And the systemid is the only unique database identifier
I'vefound. 

--
Cezariusz Marek
Mobile +48 608 646 494, Phone +48 33 484 6900, http://www.comarch.com/
Comarch SA, ul. Michałowicza 12, 43-300 Bielsko-Biała, POLAND