postgresql
postgresql copied to clipboard
ANXS
Fairly full featured Ansible role for Postgresql.
Using multiple clusters in RedHat doesn't work, apparently due to SELinux. My testing shows that we can, so long as we use: `/var/lib/pgsql/{{ postgresql_version }}/{{ postgresql_cluster_name }}/data` By default this...
Hi sometimes I use a postgresdatabase and want to give it a easy name to control it, e.g. "holiday-db". Then I can "systemctl start|status|stop holiday-db". I dont care about the...
hi, nothing more to add to the title. thank you for your awesome postgresql role :)
Hello, It seems that we cannot connect with the `postgres` default user without password since few days/weeks. Each time we get: `SQLSTATE[08006] [7] fe_sendauth: no password supplied` I tried: -...
This change will break the current repo URL generator: ``` Hi, I made 3 major changes in the PGDG RPM (RHEL/Fedora/CentOS/SL) repo files: 1. Instead of having separate repo RPMs...
There is a way to enable pg_stat_statements? This extension required an extra config `pg_stat_statements.track = all` but I can't find a way to do this in the yml
Only restart the cluster when absolutely necessary, otherwise do a reload. Default to mega safety, and even if a restart is needed, then only do so if the "postgresql_restart_on_config_change" variable...
Fixed #302 The default for RedHat (and PostgreSQL in general) is to put the key files into $PGDATA, so this patch follows that behaviour on RedHat, leaving Debian with the...