Set up PostgreSQL for Nuclos: create login role, tablespace, database and schema, enable PL/pgSQL and configure nuclos.xml. |
Language: Deutsch · English
Prepare PostgreSQL for Nuclos: create a login role, tablespace, database and schema. The Nuclos installer can handle most of this.
On this page |
Easiest: let the Nuclos installer install and configure PostgreSQL – then the steps below are unnecessary. The PostgreSQL JDBC driver is already included. |
| Vendor | postgresql.org |
|---|---|
| Supported | version 9.3+ (recommended: current version) |
| Management | pgAdmin or console (psql) |
After installing PostgreSQL, create a login role, (optional) tablespace, database and schema – via pgAdmin or console:
CREATE ROLE nuclos LOGIN PASSWORD '<password>' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE; |
CREATE TABLESPACE <tablespace> OWNER nuclos LOCATION '<directory>'; |
CREATE DATABASE <database> WITH OWNER = nuclos TEMPLATE = template1 ENCODING = 'UTF8' TABLESPACE = <tablespace>; |
CREATE SCHEMA <schema> AUTHORIZATION nuclos; |
Nuclos requires PL/pgSQL. On current PostgreSQL versions it's already present in template1; otherwise:
CREATE LANGUAGE plpgsql; |
Steps in pgAdmin (placeholder – screenshot to follow).
| <adapter> | postgresql |
|---|---|
| <connection-url> | jdbc:postgresql://<host>:5432/<database> |
| <user>, <password> | database user and password |
| <schema> | schema name |
| <tablespace> | tablespace name |
Database objects (tables etc.) are created automatically on the first start of the Nuclos server. |