community.postgresql

community.postgresql copied to clipboard

Publication creation doesn't support specifying columns for published table

1

##### SUMMARY Publication creation doesn't support specifying columns for which publication should be created - example SQL - `CREATE PUBLICATION users_filtered FOR TABLE users (user_id, firstname)` Right now if I...

kacperk

##### SUMMARY If no response on https://github.com/ansible-collections/community.postgresql/pull/583#issuecomment-1776695391, revert the PR. Moreover, the PR wasn't backported as we asked for.

Andersson007

String value pulled from postgres and present in settings dictionary compared incorrectly

1

##### SUMMARY String value pulled from postgres and present in settings dictionary compared incorrectly ##### ISSUE TYPE - Bug Report ##### COMPONENT NAME plugins/modules/postgresql_set.py ##### ANSIBLE VERSION ```any ``` #####...

badfiles

Set role or database parameters

3

### Discussed in https://github.com/ansible-collections/community.postgresql/discussions/576 Originally posted by **ivanov17** September 5, 2023 Hello! What is the best way to set role or database parameters? There is the `community.postgresql.postgresql_set` module that uses...

Andersson007

##### SUMMARY Puzzling behaviour when revoking default_privs: using state: absent disregards both objs and privs, and just revokes all on TABLES, SEQUENCES and TYPES ##### ISSUE TYPE - Bug Report...

dmorel

[4.0.0 future major release] postgresql_user: Remove deprecated privs argument in 4.0.0

1

##### SUMMARY postgresql_user: Remove privs argument in 4.0.0 Relates to https://github.com/ansible-collections/community.postgresql/pull/227 Fixes https://github.com/ansible-collections/community.postgresql/issues/117

Andersson007

##### SUMMARY In 4.0.0 major release to remove aliases deprecated in https://github.com/ansible-collections/community.postgresql/pull/407

Andersson007

##### SUMMARY Remove [deprecated](https://github.com/ansible-collections/community.postgresql/pull/559) `postgresql_lang` in 4.0.0

Andersson007

postgresql_user: Cannot change user password with session_role in Azure Database.

1

##### SUMMARY Administrative privileges in Azure Database for PostgreSQL are to belong to the [azure_pg_admin](https://learn.microsoft.com/en-US/azure/postgresql/flexible-server/concepts-security#access-management) role. The login user should not have administrative privileges, Specify the role with azure_pg_admin as...

t-ymwk

postgresql_db module zcat error restoring `sql.gz` files

4

##### SUMMARY When I use the `dump` option of the `postgresql_db` module to create a `.sql.gz` file, the `restore` mechanism generates an error claiming the file does not exist. It...

alanbchristie