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

Changes Made In postgresql.conf File Are Not Being Reflected

I made some changes in postgresql.conf file like modifying search_path and changing port. But these changes were not being reflected. They were written in the file but were not being implemented. I used vim for editing the file.

I did those changes separately using terminal commands and they worked but can anyone tell me the reason why modifying postgres.conf was not working?

Tags:

2

Answers


  1. 0

    This happens sometimes because that changes was not stored/saved properly. So once you are done with the changes, save them and then run to make sure you are working on the correct file.

    select name, context, setting, source, sourcefile from pg_settings where name in (‘search_path’, ‘port’);

    Login or Signup to reply.
  2. 0

    Just don’t forget to restart the server after changes in pg conf.

    bin/pg_ctl -D {data-dir} restart
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search