Createdb does not create a db in postgres: no error message

Question

When I try to create a db in postgres 9.3, it does not create the database. I do not get any error messages.

abramhandler-# createdb orleansgis
abramhandler-# \list
                                         List of databases
     Name     |    Owner     | Encoding |   Collate   |    Ctype    |       Access privileges       
--------------+--------------+----------+-------------+-------------+-------------------------------
 abramhandler | abramhandler | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres     | abramhandler | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0    | abramhandler | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/abramhandler              +
              |              |          |             |             | abramhandler=CTc/abramhandler
 template1    | abramhandler | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/abramhandler              +
              |              |          |             |             | abramhandler=CTc/abramhandler
(4 rows)

abramhandler-#

I tried entering #commit and it still does not show the database.

The docs show how to debug error messages -- but I'm not sure what to do when I get no error message at all. It simply does not create the database.

SQL statements in psql need to be terminated with a ; - but createdb is not a SQL command it's a commandline program. From within psql you would need to run create database orleansgis; (don't forget the ;) — user330315
– user330315, Commented Mar 26, 2014 at 13:26

Clodoaldo Neto · Accepted Answer · 2014-03-26 13:14:30Z

12

createdb is a shell command line command. At the psql client prompt use the create database command

When the prompt is -# it is still waiting for the command termination, a semicolon. Enter Ctrl C to escape that.

answered Mar 26, 2014 at 13:14

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Createdb does not create a db in postgres: no error message

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related