DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=bzpUoWHsh5oQqcQnwG1lf8n7k3x7vwQeT4S8lMGG8bzoD9M3b/aamPYfHdGivPnos1oz+QjXT592l5PcC+B9FTu9+fSBSj/rnqvSHC3MADKM7B/SE4B42UaqMvy0phE9UpqmNRSSlYHLfnmE4XBUn8TY7kRf+5fqnq+peZsz8Ro=;
References: <08af01cf20ba$d5f0aec0$81d20c40$@comarch.pl> 
Message-ID: <1391600088.5800.YahooMailNeo@web133204.mail.ir2.yahoo.com>
Date: Wed, 5 Feb 2014 11:34:48 +0000 (GMT)
From: Glyn Astill <glynastill@yahoo.co.uk>
Reply-To: Glyn Astill <glynastill@yahoo.co.uk>
Subject: Re: IDENTIFY_SYSTEM
To: Cezariusz Marek <cezariusz.marek@comarch.pl>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
In-Reply-To: <08af01cf20ba$d5f0aec0$81d20c40$@comarch.pl>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

____________________________

> From: Cezariusz Marek <cezariusz.marek@comarch.pl>
>To: pgsql-sql@postgresql.org
>Sent: Monday, 3 February 2014, 8:35
>Subject: [SQL] IDENTIFY_SYSTEM
>=20
>
>
>Hello,
>=C2=A0
>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 i=
ndentifier for the licensing purposes.
>=C2=A0

That's part of the streaming replication protocol=C2=A0=20

http://www.postgresql.org/docs/9.3/static/protocol-replication.html
As long as you're using wal_level >=3D archive and the replication connecti=
on is enabled you can retrieve it via psql

http://www.postgresql.org/message-id/AANLkTimFVHvhG73rPykX1z57MvPgskxJY1JuR=
YrD9Cf_@mail.gmail.com

glyn@test:~$ psql "replication=3D1" -c "IDENTIFY_SYSTEM"
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 systemid=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
 | timeline |=C2=A0 xlogpos
---------------------+----------+-----------
=C2=A05972513070019772415 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 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?


>--=20
>Cezariusz Marek
>Mobile +48=C2=A0608=C2=A0646=C2=A0494, Phone +48 33=C2=A0484 6900, http://=
www.comarch.com/
>Comarch SA, ul. Micha=C5=82owicza 12, 43-300 Bielsko-Bia=C5=82a, POLAND
>=C2=A0
>
>


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql