agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Cezariusz Marek <cezariusz.marek@comarch.pl>
To: pgsql-sql@postgresql.org
Subject: Re: IDENTIFY_SYSTEM
Date: Wed, 5 Feb 2014 13:01:59 +0100
Message-ID: <0aa401cf226a$12eb9320$38c2b960$@comarch.pl> (raw)
In-Reply-To: <1391600088.5800.YahooMailNeo@web133204.mail.ir2.yahoo.com>
References: <08af01cf20ba$d5f0aec0$81d20c40$@comarch.pl>
	<1391600088.5800.YahooMailNeo@web133204.mail.ir2.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

> 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 might suffice?

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

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




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

view thread (6+ messages)  latest in thread

Message-ID: <0aa401cf226a$12eb9320$38c2b960$@comarch.pl>
Permalink:  ../0aa401cf226a$12eb9320$38c2b960$@comarch.pl/
Also on:    postgresql.org/message-id/0aa401cf226a$12eb9320$38c2b960$@comarch.pl

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: cezariusz.marek@comarch.pl
  Subject: Re: IDENTIFY_SYSTEM
  In-Reply-To: <0aa401cf226a$12eb9320$38c2b960$@comarch.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox