Skip site navigation (1) Skip section navigation (2)

Re: Authentication trick

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: <antongiulio05(at)gmail(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Authentication trick
Date: 2006-12-01 09:31:47
Message-ID: 456FF683.7030705@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
antongiulio05(at)gmail(dot)com wrote:
> Hi,
> 
> some commercial softwares use a trick to avoid copy of a db, license-crack, etc. They use generate a key -> "ID of db-instance". For example, if you dump a db on other machine with postgres installed, this key will be different and so application will not start.

PostgreSQL is not commercial, so there's no need for such artificial 
restrictions. There is, however, a unique system_identifier in 
pg_control file that's generated when initdb is run. It's used on WAL 
replay to check that the WAL logs were generated by the same installation.

> It was good for Oracle, DB2 and MS-SQL. Is there a "similar key" for Postgres? Is it possible retrieve it via-jdbc? How?

There's no way to retrieve system_identifier from the client.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-jdbc by date

Next:From: Csaba NagyDate: 2006-12-01 09:35:37
Subject: Re: Backup with Java
Previous:From: Kris JurkaDate: 2006-12-01 09:28:24
Subject: Re: XA end then join fix for WebLogic

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group