BUG #16564: Can't start the service postgresql@11-main.service

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16564: Can't start the service postgresql@11-main.service

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16564
Logged by:          Stemy
Email address:      [hidden email]
PostgreSQL version: 11.2
Operating system:   Debian
Description:        

Hello,

I can't use any server app that requires a postgresql database.

I can't even start the service. It is marked as "inactive (dead)", and if i
execute "systemctl start [hidden email]", it returns me this:
"Assertion failed on job for [hidden email].".

Here's what a "systemctl status" give:

‚óŹ [hidden email] - PostgreSQL Cluster 11-main
   Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled; vendor
preset: enabled)
   Active: inactive (dead)
   Assert: start assertion failed at Thu 2020-07-30 19:13:54 CEST; 1h 21min
ago
           AssertPathExists=/etc/postgresql/11/main/postgresql.conf was not
met

So what have i to do to "resurrect" it ?

Thanks.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16564: Can't start the service postgresql@11-main.service

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> I can't use any server app that requires a postgresql database.
> I can't even start the service. It is marked as "inactive (dead)", and if i
> execute "systemctl start [hidden email]", it returns me this:
> "Assertion failed on job for [hidden email].".

Well, the error message says that the cluster configuration file
isn't there:

>            AssertPathExists=/etc/postgresql/11/main/postgresql.conf was not
> met

So I wonder whether you initialized the database at all; normally
that action would set up a postgresql.conf file as a byproduct.

With a bare Postgres installation you'd run initdb for that purpose.
But since you're apparently using Debian's packaging of Postgres,
I'd recommend using whatever script they provide for the purpose.
Reading the package's documentation would tell you that.

                        regards, tom lane