Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNAQo-0005u4-JE for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 10:33:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNAQn-0006xS-7h for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 10:33:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNAQm-0006xJ-Sz for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 10:33:32 +0000 Received: from ms-10.1blu.de ([178.254.4.101]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNAQi-0002L2-GL for pgsql-general@postgresql.org; Wed, 01 Feb 2023 10:33:32 +0000 Received: from [178.254.11.41] (helo=sh4-5.1blu.de) by ms-10.1blu.de with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pNAQh-0006dR-6K for pgsql-general@postgresql.org; Wed, 01 Feb 2023 11:33:27 +0100 Date: Wed, 1 Feb 2023 11:33:19 +0100 From: Matthias Apitz To: Postgres General Subject: database postgres not found Message-ID: <20230201103319.GA9@sh4-5.1blu.de> Reply-To: Matthias Apitz MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Operating-System: FreeBSD 12.0-CURRENT r314251 (amd64) X-message-flag: Mails containing HTML will not be read! Please send only plain text. User-Agent: Mutt/1.9.4 (2018-02-28) X-Con-Id: 51246 X-Con-U: 0-guru X-Originating-IP: 178.254.11.41 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub