Re: IDENTIFY_SYSTEM

____________________________

> From: Cezariusz Marek <cezariusz(dot)marek(at)comarch(dot)pl>
>To: pgsql-sql(at)postgresql(dot)org
>Sent: Monday, 3 February 2014, 8:35
>Subject: [SQL] IDENTIFY_SYSTEM
>
>
>
>Hello,
> 
>Is there a way to call IDENTIFY_SYSTEM command from SQL? Or otherwise get the unique system identifier from a function? I need some unique database indentifier for the licensing purposes.
> 

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

http://www.postgresql.org/message-id/AANLkTimFVHvhG73rPykX1z57MvPgskxJY1JuRYrD9Cf_@mail.gmail.com

glyn(at)test:~$ psql "replication=1" -c "IDENTIFY_SYSTEM"
      systemid       | timeline |  xlogpos
---------------------+----------+-----------
 5972513070019772415 |        1 | 0/2EE0368

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

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