From: "Cezariusz Marek" <cezariusz.marek@comarch.pl>
To: <pgsql-sql@postgresql.org>
References: <08af01cf20ba$d5f0aec0$81d20c40$@comarch.pl>
 <1391600088.5800.YahooMailNeo@web133204.mail.ir2.yahoo.com>
In-Reply-To: <1391600088.5800.YahooMailNeo@web133204.mail.ir2.yahoo.com>
Subject: Re: IDENTIFY_SYSTEM
Date: Wed, 5 Feb 2014 13:01:59 +0100
Organization: Comarch SA
Message-ID: <0aa401cf226a$12eb9320$38c2b960$@comarch.pl>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQICKcZhNzNUtvhJd/mIeVvo2v+gagIb82pBmi+fwLA=
Content-Language: pl
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

> That's part of the streaming replication protocol
>=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 connec=
tion 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 functio=
n to grab the mac address of the machine might suffice?

I have to license each database, not just the whole machine. And the system=
id is the only unique database identifier I've found.

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


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