The xTuple installer installs PostgreSQL for you, but what if you already have a PostgreSQL server? This post describes how to handle that situation.
Follow the instructions at
. However, the init.sql script may not run to completion if the admin user already exists. To resolve that situation, in pgAdmin:
- Go to the server, Login Roles.
- Right-click on admin, go to Properties, Role membership, and make admin a member in xtrole.
- Under Properties / Role Privileges, tick these:
- Can create database objects
- Can create roles