Language: Deutsch · English
PostgreSQL database
Prepare PostgreSQL for Nuclos: create a login role, tablespace, database and schema. The Nuclos installer can handle most of this.
HOW-TO OPERATIONS UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X
On this page
Recommended
Easiest: let the Nuclos installer install and configure PostgreSQL – then the steps below are unnecessary. The PostgreSQL JDBC driver is already included.
Overview
| Vendor | postgresql.org |
|---|---|
| Supported | version 9.3+ (recommended: current version) |
| Management | pgAdmin or console (psql) |
Manual preparation
After installing PostgreSQL, create a login role, (optional) tablespace, database and schema – via pgAdmin or console:
1. Login role
CREATE ROLE nuclos LOGIN PASSWORD '<password>' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
2. Tablespace (optional)
CREATE TABLESPACE <tablespace> OWNER nuclos LOCATION '<directory>';
3. Database
CREATE DATABASE <database> WITH OWNER = nuclos TEMPLATE = template1 ENCODING = 'UTF8' TABLESPACE = <tablespace>;
4. Schema
CREATE SCHEMA <schema> AUTHORIZATION nuclos;
5. PL/pgSQL
Nuclos requires PL/pgSQL. On current PostgreSQL versions it's already present in template1; otherwise:
CREATE LANGUAGE plpgsql;
Screenshot-Platzhalter
Steps in pgAdmin (placeholder – screenshot to follow).
Adjust nuclos.xml
| <adapter> | postgresql |
|---|---|
| <connection-url> | jdbc:postgresql://<host>:5432/<database> |
| <user>, <password> | database user and password |
| <schema> | schema name |
| <tablespace> | tablespace name |
First start
Database objects (tables etc.) are created automatically on the first start of the Nuclos server.
Related pages
Überblick
Inhalte