To configure the PostgreSQL database, perform the following tasks:
Step 1: Create a database user
PaperCut NG/MF requires a user to connect to the database. Ensure that you have a database user set up in the PostgreSQL database that has full permissions to create/drop tables and has full access to any created tables.
This user will often be created by the PostgreSQL administrator when the PostgreSQL database is created.
What’s next?
If you’re in the process of migrating to the external database for the first time, head over to continue with the steps (Step 5: Change the PaperCut NG/MF connection details) from our Upsize to an external database (RDBMS) article.
If you’ve already migrated (and changed the connection details as documented in Upsize to an external DB ) and are looking to confirm that the PaperCut Application Server is pointing to the external database successfully, you can check this using the system information in the PaperCut admin interface.
Navigate to the About tab > System info > Database, and you’ll see the type of database server listed. Database: Internal
indicates that the App Server is still using the Internal ‘derby’ database, whereas Database: PostgreSQL
indicates it’s using an PostgreSQL Server.
Comments