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
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 |