agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedincorrect error message
2+ messages / 2 participants
[nested] [flat]
* incorrect error message
@ 2025-02-12 18:28 PG Doc comments form <noreply@postgresql.org>
2025-02-12 21:51 ` Re: incorrect error message David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2025-02-12 18:28 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: write2uche@gmail.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: incorrect error message
2025-02-12 18:28 incorrect error message PG Doc comments form <noreply@postgresql.org>
@ 2025-02-12 21:51 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2025-02-12 21:51 UTC (permalink / raw)
To: write2uche@gmail.com <write2uche@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On Wednesday, February 12, 2025, PG Doc comments form <
noreply@postgresql.org> wrote:
> 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?
>
>
Yes, this is working as documented. If you don’t like which database name
is inferred specify one yourself.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-12 21:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-12 18:28 incorrect error message PG Doc comments form <noreply@postgresql.org>
2025-02-12 21:51 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox