From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: write2uche@gmail.com
Subject: incorrect error message
Date: Wed, 12 Feb 2025 18:28:41 +0000
Message-ID: <173938492156.197401.7597633103196533140@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-alterrole.html
Description:
After changing to user postgres, I tried to launch psql shell as a new user
( -U). However the error message I received after I used an incorrect
password was incorrect. It was saying that I had tried to wrong database. Is
this correct?
OS information:
postgres@ubu241:~$ uname -a
Linux ubu241 6.8.0-52-generic #53-Ubuntu SMP PREEMPT_DYNAMIC Sat Jan 11
00:06:25 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux
postgres@ubu241:~$ cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=24.04
DISTRIB_CODENAME=noble
DISTRIB_DESCRIPTION="Ubuntu 24.04.1 LTS"
PRETTY_NAME="Ubuntu 24.04.1 LTS"
NAME="Ubuntu"
VERSION_ID="24.04"
VERSION="24.04.1 LTS (Noble Numbat)"
VERSION_CODENAME=noble
ID=ubuntu
ID_LIKE=debian
HOME_URL="https://www.ubuntu.com/";
SUPPORT_URL="https://help.ubuntu.com/";
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/";
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy";
UBUNTU_CODENAME=noble
LOGO=ubuntu-logo
The issue being reported:
uchenna@ubu241:~$ sudo -i -u postgres
[sudo] password for uchenna:
postgres@ubu241:~$ psql -U tester
Password for user tester:
psql: error: connection to server on socket
"/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "tester" does
not exist
postgres@ubu241:~$ psql
psql (16.6 (Ubuntu 16.6-0ubuntu0.24.04.1))
Type "help" for help.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, write2uche@gmail.com
Subject: Re: incorrect error message
In-Reply-To: <173938492156.197401.7597633103196533140@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox