...
An internet connection is not required.
Database Requirements
...
The Application requires a PostgreSQL 9.6 database or later (Encoding UTF-8)
Details:
The Application requires a separate PostgreSQL database server.
The application server needs read/write access to the database server, so any firewall between these needs to allow traffic .(Default Port 5432)
3YOURMIND will and can not manage the database server for you. We will neither install a database server nor configure updates/replication of existing database servers.
Sizing requirements for the database heavily depend on usage. We recommend at least 20 GB for a production system. The database will grow slowly over time, so keep the disk space under monitoring.
If the database is installed manually:
It should be done on a separate server with at least 4GB RAM
The Application Server must be able to connect to the Database Server (Default Port 5432)
For installing PostgreSQL, please refer to the official Installation instructions or to an unofficial installation guide (recommended)
After Installation
On your database server, you will need to create one database and one user, which has read/write/drop/create rights on the said database.
Supported Databases
PostgreSQL 9.6 or later
Encoding: UTF-8
Also, set
Set these variables for the application user on the database (exchange <dbuser> with your database username):
| Code Block | ||
|---|---|---|
| ||
ALTER ROLE <dbuser> SET client_encoding TO 'utf8';
ALTER ROLE <dbuser> SET default_transaction_isolation TO 'read committed';
ALTER ROLE <dbuser> SET timezone TO 'UTC'; |
Other Setup Requirements
DNS
HTTPS / Certificates
SMTP Server
Transfer of existing cloud application data (Organization Styling, Printing Services, and Materials) not including User and Order data.
(Optional) AWS S3 Object Storage for 3D-Files
...