public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: 毛毛 <[email protected]>
Cc: [email protected]
Subject: Re: How to use createdb command with newly created user?
Date: Sun, 23 Jun 2024 11:47:44 -0700
Message-ID: <CAKFQuwb-Kp4dnE+EM2WCeJ8tuai-Lx_Ja2Gb8mEOkNRe9h8Vww@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Sun, Jun 23, 2024, 11:43 毛毛 <[email protected]> wrote:
> Hi,
>
> I tried to create a user with CREATEDB permission.
> Then I wanted to run command line tool `createdb` with this newly created
> user.
>
> So I ran SQL first to create a user:
>
> ```
> CREATE USER Baba WITH PASSWORD 'xxx' CREATEDB;
> ```
>
> Then I run the following command on PowerShell on Windows 10:
>
> ```
> createdb -U Baba -W test_db
> ```
>
> But no mater how I tried, the password always failed.
>
> If I specify the user as postgres, the defaut user, everything works fine.
>
> ```
> createdb -U postgres -W test_db_1
> ```
>
> Do you have any suggestions?
>
You named the user "baba" all lower-case but your createdb command uses
Baba and in the OS the case-folding of identifiers does not happen. Baba
!= baba is your issue.
David J.
view thread (5+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How to use createdb command with newly created user?
In-Reply-To: <CAKFQuwb-Kp4dnE+EM2WCeJ8tuai-Lx_Ja2Gb8mEOkNRe9h8Vww@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox