CODEWITHSUNDEEP
postgresqldatabase-replication
Bach-Nga
Bach-Nga

Reputation: 45

Postgres replication not starting after configuration

I am trying to install and create a PostgreSQL master-slave replication.

I have a problem after configured postgresql.conf and pg_hba.conf; I can't restart Postgres with systemctl restart postgresql-11.service. It complained

AUTHENTICATING for org.freedesktop.systemd1.manage-units --Authentication is required to manage system services or units

I also cannot start Postgres with pg_ctl, it complains about

unrecognized configuration parameter checkpoint_segments in file postgresql.conf line 215

Is it wrong to set checkpoint_segments=8 in postgresql.conf?

How can I restart Postgres?

My postgresql.conf:

wal_level = hot_standby
max_wal_senders = 3
checkpoint_segments = 8
wal_keep_segments = 8
hot_standby = on

Upvotes: 0

Views: 2206

Answers (2)

Amjad Shahzad
Amjad Shahzad

Reputation: 822

Will you please check if you have max_wal_size = 1G or max_wal_size = 1GB in conf file. in-case it is 1G, you will not be able to start the service. it should be GB

Upvotes: 1

C0nverter
C0nverter

Reputation: 139

I'd like to post it as an at least partial answer, since this is the cause of the unrecognized configuration parameter error.

According to Laurenz's answer, parameter checkpoint_segments doesn't exist anymore. The replacement is max_wal_size.

Also, confirming what Laurenz said up there, "AUTHENTICATING" line is not related to Postgres. With all credits to them, you should search for problems in Linux services.

Upvotes: 1

Related Questions