Re: How to use createdb command with newly created user?

On Sun, Jun 23, 2024, 11:43 毛毛 <krave(at)163(dot)com> 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.