title: how to add database in a new cluster in postgreSQL?
body: <p>I am using </p>
  
  <pre><code>sudo pg_createcluster -u=$USER --datadir=candisDatabase -l=candisDatabase/candis.psql.log 9.6 candisCluster
  </code></pre>
  
  <p>to create a new database cluster with the specified directory as <code>candisDatabase</code> under the account $USER (which is 'rupav').</p>
  
  <pre><code>pg_lsclusters
  Ver Cluster        Port Status Owner    Data directory               Log file
  9.6 candisCluster2 5433 online   rupav    candisDatabase               candisDatabase/candis.psql.log
  9.6 main           5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log
  </code></pre>
  
  <p>cluster is created successfully, and am able to run/start the new cluster and server candisCluster2 with <code>pg_ctlcluster 9.6 candisCluster2 start</code> successfully</p>
  
  <p>following is the status of the new cluster (using <code>pg_ctlcluster 9.6 candisCluster2 status</code>) :</p>
  
  <pre><code>/usr/lib/postgresql/9.6/bin/postgres "-D" "candisDatabase" "-c" "config_file=/etc/postgresql/9.6/candisCluster2/postgresql.conf"
  </code></pre>
  
  <p>Now that server is listening on 5433 port, how can I add create role, database and password in the given cluster. By default (after postgresql installation) I can do <code>sudo -u postgres psql</code> to enter into the psql shell.</p>
  
  <p>In short, I would like to have all my tables in the data directory specified, as <code>candisDatabase</code> which is owned by user different from <code>postgres</code>.</p>
  
  <p><strong>System details</strong>:
  I am on 'Ubuntu 17.10 (Oracle VM, host being windows)' and postgresql version is 9.6</p>