Re: "Database does not exist" weirdness

On 02/16/2017 11:18 PM, Michael Tyson wrote:
> 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?

In addition to what has already been asked, I am assuming from the
system prompts this is happening on a Raspberry Pi, correct?

If so what is being used for storage and have there been any issues with
said storage, eg someone pulling a SD card out at the wrong time?

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com