Обсуждение: BUG #18078: createdb not working
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.
I have also tried the initdb command to initialize database clusters but had no success.
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}
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?
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 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
Exalted Soft
CEO
Orhan Punar
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 Punarsudo 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