From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Re: How to use createdb command with newly created user? |
Date: | 2024-06-23 19:38:21 |
Message-ID: | CANzqJaCkH5BqXKi8zB8QCSbxBrv8W=GNf-HfADg4thm2V9zqTw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Better to run now, and save yourself hassle in the future:
ALTER ROLE "Baba" RENAME TO baba;
Also, use a .pgpass file:
https://www.postgresql.org/docs/14/libpq-pgpass.html
On Sun, Jun 23, 2024 at 3:22 PM 毛毛 <krave(at)163(dot)com> wrote:
>
>
> Thank you! You are right!
>
> After putting quotes around the username, it works!
>
>
>
> 在 2024-06-24 02:47:44,"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> 写道:
>
>
>
> 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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | 毛毛 | 2024-06-24 03:36:33 | Re:Re: Re: How to use createdb command with newly created user? |
Previous Message | 毛毛 | 2024-06-23 19:22:19 | Re:Re: How to use createdb command with newly created user? |