Dear Sir,
I am a total novice to PostgreSQL, which I came by when following the instructions for the installation of OpenProject :
https://www.openproject.org/projects/openproject/wiki/Installation_MacOS
I think I am supposed to open a PostgreSQL console, and paste this :
CREATE ROLE openproject LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity'; CREATE DATABASE openproject WITH ENCODING='UTF8' OWNER=openproject;
but I have no clue about how to open that console.I’ve tried “psql”, but it request a password that I do not remember to have set.
Do any of you know what are the commands I should be using ?
Many thanks,
Diego