"Database does not exist" weirdness

From: Michael Tyson <michael(at)tyson(dot)id(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: "Database does not exist" weirdness
Date: 2017-02-17 07:18:20
Message-ID: 4F321FDE-7B60-4288-9523-8291155A739A@tyson.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi folks,

Please excuse the question if I'm missing something stupid, but I seem to be stuck. I've created a postgres database, via an Elixir project setup, and it's showing up via psql's \l command, but I'm seeing "database does not exist" messages.

Transcript of a session showing this follows below.

Anything I should be looking at, here? What am I missing?

Many thanks in advance,
Michael

pi(at)raspi ~ $ sudo -u postgres psql
psql (9.4.10)
Type "help" for help.

postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------+----------+----------+-------------+-------------+---------------------------
testdb | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres +
| | | | | testdb=CTc/postgres
postgres | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |
template0 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)

postgres=# \q
pi(at)raspi ~ $ sudo -u postgres psql testdb
psql: FATAL: database "testdb" does not exist
pi(at)raspi ~ $ sudo -u postgres createdb testdb
createdb: database creation failed: ERROR: duplicate key value violates unique constraint "pg_database_datname_index"
DETAIL: Key (datname)=(testdb) already exists.

Sent from my iPhone

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Shchapov 2017-02-17 09:36:19 Re: Load multiple CSV file in Postgres using COPY
Previous Message Magnus Hagander 2017-02-17 06:00:31 Re: Load multiple CSV file in Postgres using COPY