Re: Authentication trick

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