From: BeeRich Lists <bee.lists@gmail.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 15.0 \(3693.40.0.1.81\))
Subject: FATAL:  no such database
Message-Id: <AB678941-ED2D-49BF-9EF5-919A2D8538F3@gmail.com>
Date: Mon, 21 Feb 2022 15:24:46 -0500
To: Submit Postgresql Novice <pgsql-novice@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/AB678941-ED2D-49BF-9EF5-919A2D8538F3%40gmail.com>
Precedence: bulk

For some reason I cannot create a database.  I use Sequel, Postico, and =
psql, and all three won=E2=80=99t create a database.  The first two =
write the syntax for me, and they too return errors.  Here is an example =
in psql:

rich=3D# CREATE DATABASE alpha;
CREATE DATABASE
rich=3D# \c alpha;
FATAL:  no such database: alpha
Previous connection kept
rich=3D# \l
                                List of databases
     Name     | Owner | Encoding |   Collate   |    Ctype    | Access =
privileges
=
--------------+-------+----------+-------------+-------------+------------=
-------
 alpha        | rich  | UTF8     | C           | C           |
 postgres     | rich  | UTF8     | C           | C           |
 rich         | rich  | UTF8     | C           | C           |
 template0    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
 template1    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
(5 rows)

rich=3D# DROP DATABASE alpha;
DROP DATABASE
rich=3D# \l
                                List of databases
     Name     | Owner | Encoding |   Collate   |    Ctype    | Access =
privileges
=
--------------+-------+----------+-------------+-------------+------------=
-------
 postgres     | rich  | UTF8     | C           | C           |
 rich         | rich  | UTF8     | C           | C           |
 template0    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
 template1    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
(4 rows)

rich=3D# CREATE DATABASE alpha;
CREATE DATABASE
rich=3D# \l
                                List of databases
     Name     | Owner | Encoding |   Collate   |    Ctype    | Access =
privileges
=
--------------+-------+----------+-------------+-------------+------------=
-------
 alpha        | rich  | UTF8     | C           | C           |
 postgres     | rich  | UTF8     | C           | C           |
 rich         | rich  | UTF8     | C           | C           |
 template0    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
 template1    | rich  | UTF8     | C           | C           | =3Dc/rich =
         +
              |       |          |             |             | =
rich=3DCTc/rich
(5 rows)

rich=3D# \c alpha;
FATAL:  no such database: alpha
Previous connection kept
rich=3D#

I have reinstalled PostgreSQL 12 both through homebrew as well as using =
the Postgres.app on MacOS.  Both have the same issue. =20

Anybody have any insight into what I should try?  Thanks for your time. =20=


Cheers, Bee