Обсуждение: Subject: Assistance Required: Adding Multiple Libraries to shared_preload_libraries in postgresql.conf
Dear Postgres Community,
I hope this message finds you well. I am reaching out regarding an issue I've encountered while attempting to configure the shared_preload_libraries variable in the postgresql.conf file to include multiple libraries.
The problem arises when I try to add both the 'citus' and 'pg_stat_statement' libraries to the shared_preload_libraries variable. Here is the configuration snippet I attempted:
shared_preload_libraries = 'citus', 'pg_stat_statement'
Upon restarting the server after making this adjustment, I encountered an error related to socket connection, which indicates that there might be an issue with how I'm specifying multiple libraries.
Could you please provide guidance on the correct syntax or approach for adding multiple libraries to the shared_preload_libraries variable? Additionally, any insights into why this particular configuration might be causing a socket connection error would be greatly appreciated.
Thank you very much for your time and assistance. I look forward to hearing from you soon.
Best regards,
Uzair Rehman
I hope this message finds you well. I am reaching out regarding an issue I've encountered while attempting to configure the shared_preload_libraries variable in the postgresql.conf file to include multiple libraries.
The problem arises when I try to add both the 'citus' and 'pg_stat_statement' libraries to the shared_preload_libraries variable. Here is the configuration snippet I attempted:
shared_preload_libraries = 'citus', 'pg_stat_statement'
Upon restarting the server after making this adjustment, I encountered an error related to socket connection, which indicates that there might be an issue with how I'm specifying multiple libraries.
Could you please provide guidance on the correct syntax or approach for adding multiple libraries to the shared_preload_libraries variable? Additionally, any insights into why this particular configuration might be causing a socket connection error would be greatly appreciated.
Thank you very much for your time and assistance. I look forward to hearing from you soon.
Best regards,
Uzair Rehman
On Mon, Mar 25, 2024 at 5:41 PM Uzair Khan <u595530@gmail.com> wrote:
Dear Postgres Community,
I hope this message finds you well. I am reaching out regarding an issue I've encountered while attempting to configure the shared_preload_libraries variable in the postgresql.conf file to include multiple libraries.
The problem arises when I try to add both the 'citus' and 'pg_stat_statement' libraries to the shared_preload_libraries variable. Here is the configuration snippet I attempted:
shared_preload_libraries = 'citus', 'pg_stat_statement'
One string, not two:
shared_preload_libraries = 'citus, pg_stat_statement'