Citus Maintenance Worker & template1 database

From: Joshua Kramer <joskra42(dot)list(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Citus Maintenance Worker & template1 database
Date: 2019-07-14 02:54:38
Message-ID: CAMPA5gc2KXQXTR3bDEsHU0KCgsHy96a+yoY4aB42zzcpEK-QSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Karen Goh 2019-07-15 05:27:00 How do I import a sql file into pgAdmin4 ?
Previous Message Stephen Frost 2019-07-12 12:18:48 Re: PostgreSQL LDAP \ Kerberos