Adding a database in a new cluster created on postgresql?

184 Views Asked by At

I have created a database cluster in PostgreSQL-9.6 using pg_createcluster command with user (-u) specified different from default postgres. I would like to know how to add a new/existing database into this cluster instead of the default 'main' cluster?

1

There are 1 best solutions below

1
Jasen On

Conect to the template1 or postgres database in the new cluster and execute sql CREATE DATABASE etc