On 9/26/19 1:10 AM, Marco Ippolito wrote:
> Hi Adrian,
> putting in /fabric/fabric-ca/fabric-ca-server-config.yaml :
>
> db:
> type: postgres
> datasource: host=localhost port=5433 user=fabmnet_admin
> password=fabmnet1971 dbname=fabmnetdb sslmode=verify-ca
>
> and the corresponding portion of the log file:
>
> 2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin@fabmnetdb ERROR:
> permission denied to create database
> 2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin@fabmnetdb STATEMENT:
> CREATE DATABASE fabmnetdb
User fabmnet_admin does not have CREATE DATABASE privileges. In a psql
session do:
\du fabmnet_admin
If the results do not include Create DB or Superuser then you need to
ALTER ROLE fabmnet_admin to have CREATEDB:
https://www.postgresql.org/docs/11/sql-alterrole.html
NOTE: You will need to above as ROLE that has privileges. Easiest if you
have a SUPERUSER role you can log in as.
>
> I do not undertand...
>
> Marco
>
--
Adrian Klaver
adrian.klaver@aklaver.com
