database postgres not found

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: database postgres not found
Date: 2023-02-01 10:33:19
Message-ID: 20230201103319.GA9@sh4-5.1blu.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I've a problem with a PostgreSQL 12.x server not setup or managed by me. that
the database 'postgres' is not found:

$ psql -Upostgres postgres
psql: error: ERROR: no such database: postgres

but the database is there as a SELECT shows:

$ psql -Upostgres lbs_lbsoclc01_dev_r1
psql (12.11)
Type "help" for help.

lbs_lbsoclc01_dev_r1=# select * from pg_database where datname = 'postgres' ;
oid | datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid | dattablespace | datacl
-------+----------+--------+----------+-------------+-------------+---------------+--------------+--------------+---------------+--------------+------------+---------------+--------
14344 | postgres | 10 | 6 | en_US.UTF-8 | en_US.UTF-8 | f | t | -1 | 14343 | 479 | 1 | 1663 |
(1 row)

What does this mean?

Thanks

matthias

--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jian he 2023-02-01 10:36:59 38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric.
Previous Message qihua wu 2023-02-01 09:25:35 Re: invisible commit question for sync replication