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
