Обсуждение: BUG #18078: createdb not working
The following bug has been logged on the website: Bug reference: 18078 Logged by: Orhan Punar Email address: exaltedsoft@gmail.com PostgreSQL version: 15.4 Operating system: ubuntu 22.04.03 Description: Hi, Since i updated postgresql i receive errors when i try to createdb as postgres user. The new package has bugs, it has affected my server instances as well. Is this a known bug? Best regards, Orhan Punar
> On 31 Aug 2023, at 17:04, PG Bug reporting form <noreply@postgresql.org> wrote: > Since i updated postgresql i receive errors when i try to createdb as > postgres user. The new package has bugs, it has affected my server instances > as well. Is this a known bug? Since you haven't provided a single piece of information about what you percieve as wrong there is no way for anyone to help you. -- Daniel Gustafsson
I installed postgresql on ubuntu version 22.04.3, i am using postgres 15.4. Prior to this I was using the latest LTS versions. This was done on my home laptop.
createdb -p 5432 -U postgres {clustername}
Is the server running locally and accepting connections on that socket?
I have also tried the initdb command to initialize database clusters but had no success.
> On 31 Aug 2023, at 17:04, PG Bug reporting form <noreply@postgresql.org> wrote:
> Since i updated postgresql i receive errors when i try to createdb as
> postgres user. The new package has bugs, it has affected my server instances
> as well. Is this a known bug?
Since you haven't provided a single piece of information about what you
percieve as wrong there is no way for anyone to help you.
--
Daniel Gustafsson
The following bug has been logged on the website:
Bug reference: 18078
Logged by: Orhan Punar
Email address: exaltedsoft@gmail.com
PostgreSQL version: 15.4
Operating system: ubuntu 22.04.03
Description:
Hi,
Since i updated postgresql i receive errors when i try to createdb as
postgres user. The new package has bugs, it has affected my server instances
as well. Is this a known bug?
On Thu, Aug 31, 2023 at 12:12 PM PG Bug reporting form <noreply@postgresql.org> wrote:The following bug has been logged on the website:
Bug reference: 18078
Logged by: Orhan Punar
Email address: exaltedsoft@gmail.com
PostgreSQL version: 15.4
Operating system: ubuntu 22.04.03
Description:
Hi,
Since i updated postgresql i receive errors when i try to createdb as
postgres user. The new package has bugs, it has affected my server instances
as well. Is this a known bug?createdb in 15.4 works for me. And presumably lots of other people, this is not the kind of thing that would go unnoticed.You will need to provide some actual information. Like, what your complete command was, and quote what error you got. Also how you installed and upgraded (and upgraded from what) might be useful.Cheers,Jeff
> On 31 Aug 2023, at 18:54, Orhan Punar <exaltedsoft@gmail.com> wrote: > createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: No such file or directory > Is the server running locally and accepting connections on that socket? As the error states, there is no server running on that socket and port. Have you actually started the server? This is almost guaranteed to not be a postgres bug, I recommend posting on the pgsql-general mailinglist for assistance. -- Daniel Gustafsson
> On 31 Aug 2023, at 18:54, Orhan Punar <exaltedsoft@gmail.com> wrote:
> createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5433" failed: No such file or directory
> Is the server running locally and accepting connections on that socket?
As the error states, there is no server running on that socket and port. Have
you actually started the server?
This is almost guaranteed to not be a postgres bug, I recommend posting on the
pgsql-general mailinglist for assistance.
--
Daniel Gustafsson
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