Re: [GENERAL] "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,
viaan 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@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@raspi ~ $ sudo -u postgres psql testdb
> psql: FATAL:  database "testdb" does not exist
> pi@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.klaver@aklaver.com