Development Environment Setup - Schema
Development schema is different from schema created from an official release as it is not finalized yet. So, please make sure development schema is only used for testing/development purpose.
There are two ways to create a development schema:
1) Create from kwok-schemasetup project.
From kwok-schemasetup project, run build.bat or "C:\Kwok\Server\apache_ant_1.7.0\bin\ant clean dist". This creates a kwok-schema-<version>-dev.jar in dist\database folder.
Then, use the jar file to create a brand new schema, e.g.
<path to java>\bin\java -jar kwok-schemasetup-<version>.jar install database=<database name> username=<database user> password=<database password>
See User Guide for details.
- First, backup a current schema using pgAdmin's backup option (or use pg_dump command, not covered here)
- Then, create a new database and restore the backup using pgAdmin's restore option
- Upgrade the database using the jar file (WARNING: Do not upgrade any production database using schemasetup jar intended for development purpose)
<path to java>\bin\java -jar kwok-schemasetup-<version>.jar upgrade database=<database name> username=<database user> password=<database password>