Postgresql doesn't working with Citus and pg_stat_statements at the same time
1
vote
2
answers
681
views
So, I built the PostgreSQL with citus extension in docker.
I use the official documentation in citus, then I run this command in the terminal.
docker run -d -v /root/volumes/citus-data:/data --network citus-network --name citus_coordinator -p 5500:5432 -e POSTGRES_PASSWORD=mypassword citusdata/citus:11.1
Then Database successfully building.
But I want to create the
extension.
I configuration the postgresql.conf
file.
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
pg_stat_statements.max = 10000
track_activity_query_size = 2048
Then I restarted the PostgreSQL container. Wrote the this query
SELECT * FROM pg_stat_statements;
in terminal.
I saw this error
ERROR: pg_stat_statements must be loaded via shared_preload_libraries
I didn't understand, why the config file didn't see this extension, What was my mistake?
**Solved**
I am running the PostgreSQL container with postgres:latest image.
Then I entered the container.
So, I installed the citus from here into the container.
Then installed apt-get install postgresql-contrib
into the container.Next step, run create extension pg_stat_statements;
And everything worked for me.
Asked by Gismat Gusein
(61 rep)
Oct 13, 2022, 07:32 AM
Last activity: Oct 18, 2022, 08:33 AM
Last activity: Oct 18, 2022, 08:33 AM