Question 296390 in PostgreSQL Question posted in
The official documentation can be found here.

What prevents the PostgreSQL server from starting when there's an error in primary_conninfo?

I’m using PostgreSQL 14, and during the replication setup, I forgot to include single quotes around the value of primary_conninfo. I’m puzzled as to why the server isn’t starting, and I’m not finding any logs indicating an error in the postgresql.conf file.

The original string format is "primary_conninfo = ‘host=XX port=5432 user=XX password=XX’" without single quotes. I attempted to use "primary_conninfo = host=XX port=5432 user=XX password=XX" without enclosing it in single quotes. I’m not receiving any logs or indications of the server starting. Can someone help me understand why this is happening?

Tags:

2

Answers


  1. 0

    If there is a syntax error or a bad setting in postgresql.conf, PostgreSQL will refuse to start, because it does not have a valid configuration. Look into the PostgreSQL log file to determine the error.

    Login or Signup to reply.
  2. 0

    Run pg_ctl -D <your-data-directory> restart and see if its working.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search