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
Last activity: Oct 8, 2023, 05:08 AM