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, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
