Re: [GENERAL] "Database does not exist" weirdness

2017-02-17 Thread Adrian Klaver
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

Re: [GENERAL] "Database does not exist" weirdness

2017-02-17 Thread Tom Lane
Michael Tyson writes: > Anything I should be looking at, here? What am I missing? > postgres=# \l > List of databases > Name | Owner | Encoding | Collate |Ctype| Access > privileges > --+--+--+-

Re: [GENERAL] "Database does not exist" weirdness

2017-02-17 Thread Alan Hodgson
On Friday 17 February 2017 18:18:20 Michael Tyson wrote: > 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 c

[GENERAL] "Database does not exist" weirdness

2017-02-17 Thread Michael Tyson
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 follow