Dan Armbrust wrote:
How do I make a connection to a Postgresql database that (potentially)
has 0 databases from jdbc, so that I can issue a create database command?
In that _other_ database, I can make a jdbc connection to an address
like this:
jdbc:mysql://servername/
And then issue a "Create database foo" command.
Then I can reconnect to
jdbc:mysql://servername/foo
And everything is good.
If I try to connect to a postgresql database like this:
jdbc:postgresql://servername/
Postgres attempts to connect to a database that is named the same as
the username I provided.
Certainly not what I want, since that database doesn't exist. Is
there a system database I could always count on being available that I
could connect to?
template1 but only if you allow it from pg_hba.conf.
Thanks,
Dan
