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
That's not fair.
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.
After installation i switch to the postgres user. And I type createdb
command with the following options.
createdb -p 5432 -U postgres {clustername}
This worked perfectly fine and I could create this without issue. Whenever
I do this now nothing happens, there is no message or anything. I think
this is an ubuntu issue since postgres hasn't been updated for a long time.
So i tried with another port number like 5433 then i get this error:
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?
I have also tried the initdb command to initialize database clusters but
had no success.
Is there another way to achieve this? i've checked most of the
documentations.
Orhan Punar
On Thu, Aug 31, 2023 at 6:20 PM Daniel Gustafsson <daniel@yesql.se> wrote:
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 serverinstances
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
--
*Exalted Soft*
CEO
Orhan Punar
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
Have you tried the command in ubuntu 22.04.3 LTS version?
,,
Orhan
On Thu, Aug 31, 2023 at 7:12 PM Jeff Janes <jeff.janes@gmail.com> wrote:
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
--
*Exalted Soft*
CEO
Orhan Punar
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
sudo pg_createcluster 15 {clustername} -p 5432 -u postgres
This worked, thanks for the help ;DDD
On Thu, Aug 31, 2023 at 7:37 PM Daniel Gustafsson <daniel@yesql.se> wrote:
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
--
*Exalted Soft*
CEO
Orhan Punar
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