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
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 |