Sample Header Ad - 728x90

Setup Citus extension in a ssh environment

0 votes
1 answer
152 views
I tried to do CREATE EXTENSION citus;. However, I was given the following error:
ERROR:  Citus can only be loaded via shared_preload_libraries
HINT:  Add citus to shared_preload_libraries configuration variable in postgresql.conf in master and workers. Note that citus should be at the beginning of shared_preload_libraries.
However, I do not have root access. How can I create the extension in this case? I am using PSQL's source code for setting up the database. Is there a specific file in here that I can modify to allow for the extension? Here are the list of files in my postgresql-15.3 source code folder:
COPYRIGHT    GNUmakefile.in  INSTALL   README	   config      config.status  configure.ac  doc
GNUmakefile  HISTORY	     Makefile  aclocal.m4  config.log  configure      contrib	    src
Asked by Disdainty (3 rep)
Oct 7, 2023, 06:06 PM
Last activity: Oct 8, 2023, 05:08 AM