Horton

Re: BUG #18078: createdb not working

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Orhan Punar <exaltedsoft@gmail.com>, Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-08-31T19:59:23Z
Lists: pgsql-bugs 
On 2023-08-31 Th 13:21, Orhan Punar wrote:
> Have you tried the command in ubuntu 22.04.3 LTS version?


Yes:


postgres@da3e702c6a02:~$ pg_ctlcluster 15 main start
postgres@da3e702c6a02:~$ psql -l
                                              List of databases
    Name    |  Owner   | Encoding | Collate |  Ctype  | ICU Locale | 
Locale Provider |   Access privileges
-----------+----------+----------+---------+---------+------------+-----------------+-----------------------
  postgres  | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | libc            |
  template0 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | 
libc            | =c/postgres          +
            |          |          |         |         | 
|                 | postgres=CTc/postgres
  template1 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | 
libc            | =c/postgres          +
            |          |          |         |         | 
|                 | postgres=CTc/postgres
(3 rows)

postgres@da3e702c6a02:~$ createdb blurfl
postgres@da3e702c6a02:~$ psql -l
                                              List of databases
    Name    |  Owner   | Encoding | Collate |  Ctype  | ICU Locale | 
Locale Provider |   Access privileges
-----------+----------+----------+---------+---------+------------+-----------------+-----------------------
  blurfl    | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | libc            |
  postgres  | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | libc            |
  template0 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | 
libc            | =c/postgres          +
            |          |          |         |         | 
|                 | postgres=CTc/postgres
  template1 | postgres | UTF8     | C.UTF-8 | C.UTF-8 | | 
libc            | =c/postgres          +
            |          |          |         |         | 
|                 | postgres=CTc/postgres
(4 rows)

postgres@da3e702c6a02:~$ cat /etc/os-release
PRETTY_NAME="Ubuntu 22.04.3 LTS"
NAME="Ubuntu"
VERSION_ID="22.04"
VERSION="22.04.3 LTS (Jammy Jellyfish)"
VERSION_CODENAME=jammy
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=jammy


It's not clear what you're doing wrong, but there does not appear to be 
any bug.


cheers


andrew


--
Andrew Dunstan
EDB:https://www.enterprisedb.com