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.kla...@aklaver.com


Reply via email to