Re: Authentication trick

antongiulio05@gmail.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
applicationwill 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