| Auszug |
|---|
|
Set up PostgreSQL for Nuclos: create login role, tablespace, database and schema, enable PL/pgSQL and configure nuclos.xml. |
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.
| Status |
|---|
| colour | Blue |
|---|
| title | Operations |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
| Tipp |
|---|
|
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
| Codeblock |
|---|
|
CREATE ROLE nuclos LOGIN PASSWORD '<password>'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE; |
2. Tablespace (optional)
| Codeblock |
|---|
|
CREATE TABLESPACE <tablespace> OWNER nuclos LOCATION '<directory>'; |
3. Database
| Codeblock |
|---|
|
CREATE DATABASE <database>
WITH OWNER = nuclos TEMPLATE = template1
ENCODING = 'UTF8' TABLESPACE = <tablespace>; |
4. Schema
| Codeblock |
|---|
|
CREATE SCHEMA <schema> AUTHORIZATION nuclos; |
5. PL/pgSQL
Nuclos requires PL/pgSQL. On current PostgreSQL versions it's already present in template1; otherwise:
| Codeblock |
|---|
|
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 |
|---|
| Info |
|---|
|
Database objects (tables etc.) are created automatically on the first start of the Nuclos server. |
Related pages
Installation (DE)
Install Nuclos.
Open →
Oracle database (DE)
Alternative: Oracle.
Open →
