create the database if it doesn't exist

[its-dibo]

when executing connect() it fails if the database doesn't exist.
there are two solutions:

• either to add an option to create the missing database
• or, just establish the connection without selecting a database

connect({createDb: true, host: 'localhost', ...config})

or

connect(config)
 .catch(err=>{
   if(/* error caused by a missing database */) 
     pg.query(`CREATE DATABASE ${db}`)
     .then(()=>connect())
}

[charmander]

or, just establish the connection without selecting a database

That’s not possible with PostgreSQL.

[its-dibo]

or, just establish the connection without selecting a database

That’s not possible with PostgreSQL.

so there is another approach to create the database if not exists

[boromisp]

https://www.postgresql.org/docs/current/creating-cluster.html
https://www.postgresql.org/docs/current/managing-databases.html

To create new databases remotely, you must be able to connect to an existing database in the same database cluster.