caseyandgina

Add support for alter default privileges grant usage on schemas to postgresql_privs

8

##### SUMMARY I have encountered the same problem described on this closed issue: https://github.com/ansible/ansible/issues/63273 There was a patch made for it, but for whatever reason that merge request and the...

Cannot grant select on tables in all schemas with postgresql_privs

2

##### SUMMARY I want to alter default permissions to grant select on all tables in all schemas, using community.postgresql.postgresql_privs, but this does not seem to be possible as it defaults...

postgresql_privs is not always idempotent

2

It doesn't seem that postgresql_privs is always idempotent as it should be. The following always makes a change even on repetitive runs: ``` - name: Revoke default public privileges on...

Composite primary key support

2

Can you please add compatibility with https://github.com/composite-primary-keys/composite_primary_keys ? Currently, this is an example of SQL that ends up being generated when attempting to use the acts_as_list gem with a table...

backup-fetch has issues with specific parts of backups

1

### Database name PostgreSQL # Issue description ### Describe your problem When using backup-fetch to restore a backup, I consistently encounter errors on a few of the part files. These...

Generated pg_basebackup command should be logged

6

### What happened? When Patroni initializes a node, the pg_basebackup command it generates is not logged, and it's challenging to try to reproduce from the configuration. I ran into an...

Add function to run cron job manually

2

Sometimes it would be nice to be able to run a cron job manually, for example when deploying a new job that is scheduled to run every day in the...

Support using custom schema when creating extension

3

pg_cron always uses a schema named "cron" to house it's tables and functions. If you run `create extension pg_cron schema extension_pg_cron`, it still uses it's default cron schema, ignoring the...

Tab default ordering / reordering bugs

5

### Steps to reproduce 1. In a terminal, without MacVim running, open two files with MacVim. For example, `open up.sql down.sql`. 2. MacVim opens, with the tabs in the opposite...

I'm trying a very simple config: ``` global: scrape_timeout: 5s max_connections: 1 max_idle_connections: 1 target: data_source_name: 'postgres://app_sql_exporter:testpw@localhost:5432/postgres' collectors: [simple_test] collectors: - collector_name: simple_test metrics: - metric_name: simple_value type: gauge help:...