...

Migrate from Derby to PostgreSQL

Anchor
MigrateDerbyToPostgreSQL MigrateDerbyToPostgreSQL

Rough The following are rough notes on migrating from Derby to PostgreSQL for most databases in the reference code. Assuming The guide assumes that everything runs on Linux.

Migrating ReferencePillar or ChecksumPillar databases

Assuming In the following, assume that the Derby versions of both ChecksumDatabase and AuditTrailContributorDatabase should needs to be migrated to a local PostgreSQL database.

Shutdown Firstly, shutdown the pillar , if it is running , before performing a migrationcontinuing.

Setup

Install the PostgreSQL database

• Install PostgreSQL.
  • Ubuntu
  • RHEL, Fedora, Centos

Install databases in PostgreSQL, with Create a super-user named 'bitmag' (and with 'bitmag' as password - (used in settings)

...

• (write password (bitmag) twice)

...

by running the following in the terminal

createuser -P -s -e bitmag
	- When prompted, write password bitmag twice
createdb checksumdb
createdb auditdb
psql -d checksumdb -f /path/to/checksumDBCreation.sql

...

psql -d auditdb -f /path/to/auditContributorDBCreation.sql

Fix ReferenceSettings for the pillar

...