Citus Maintenance Worker & template1 database - Mailing list pgsql-admin

From Joshua Kramer
Subject Citus Maintenance Worker & template1 database
Date
Msg-id CAMPA5gc2KXQXTR3bDEsHU0KCgsHy96a+yoY4aB42zzcpEK-QSQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello All-

This question relates to a specific implementation of Dockerized
CitusDB that was created by Josh Berkus
(https://github.com/jberkus/atomicdb).  In this implementation, the
Citus extension is attached to the template1 database, presumably so
that newly created databases also pick up Citus.

Seeing that this was last worked on a couple of years ago, I'm
wondering if this is still the best practice?  The reason I ask is,
whenever you add the Citus extension to a database, a Citus
Maintenance Daemon starts and connects to that database.  If the
daemon connects to template1, then it's impossible to create new
databases since Postgres complains about there being a connection to
that database.

Of course, maybe I need to step back and ask if there is another set
of scripts that have been written to set up Citus on a Kubernetes
cluster??  My goal after finding Josh's project was to modify it to
work with CentOS 7.

Thanks!
-JK



pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: PostgreSQL LDAP \ Kerberos
Next
From: Karen Goh
Date:
Subject: How do I import a sql file into pgAdmin4 ?