Support for Deferred Constraints in PG15 Logical Replication

Hello hiveminds, I'm interested in finding out whether logical replication in PostgreSQL 15 includes support for deferrable unique constraints. Regards, Jitesh Srivastava

Re: LDAP Authentication

On Thu, Aug 24, 2023 at 10:07 PM Stephen Frost wrote: > Greetings, > > * Emile Amewoto (emil...@yahoo.com) wrote: > > Here is the high level process: > > 1- Create the user x without password in Postgres. > > 2- Assign role or roles to the user x > > 3- Update pg_hba.conf with the ldap connecti

Role for just read the data + avoid CREATE / ALTER / DROP

Dear Members! Normally we use the "db owner" role for the connection, but this can do everything (DDL-DML). Somewhere they want to access a DB through a Read Only connection. In MS-SQL Server it is simple, but in PG it seems to be some kind of "hell". Formerly we tried to use multiple roles with

Re: LDAP Authentication

Greetings, * Dominique Devienne (ddevie...@gmail.com) wrote: > On Thu, Aug 24, 2023 at 10:07 PM Stephen Frost wrote: > > * Emile Amewoto (emil...@yahoo.com) wrote: > > > Here is the high level process: > > > 1- Create the user x without password in Postgres. > > > 2- Assign role or roles to the

Aw: Role for just read the data + avoid CREATE / ALTER / DROP

set default_transaction_read_only can help   Karsten     Gesendet: Freitag, 25. August 2023 um 14:38 Uhr Von: "Durumdara" An: "Postgres General" Betreff: Role for just read the data + avoid CREATE / ALTER / DROP Dear Members!   Normally we use the "db owner" role for the connection, but th

Re: Role for just read the data + avoid CREATE / ALTER / DROP

Durumdara schrieb am 25.08.2023 um 14:38: > Normally we use the "db owner" role for the connection, but this can do > everything (DDL-DML). > Somewhere they want to access a DB through a Read Only connection. > > In MS-SQL Server it is simple, but in PG it seems to be some kind of "hell". > Former

Re: Role for just read the data + avoid CREATE / ALTER / DROP

On Friday, August 25, 2023, Durumdara wrote: > > I don't understand why these commands don't work?! > > *REVOKE CREATE ON SCHEMA public FROM u_tdb_ro;* > > *REVOKE CREATE ON DATABASE tdb FROM u_tdb_ro;REVOKE CREATE ON TABLESPACE > pg_default FROM u_tdb_ro;* > > Because at no point has the system

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

On Thu, Aug 24, 2023 at 6:19 PM duc hiep ha wrote: > [2023-08-24 18:07:14] Collecting 0 tables information in DBA_TABLES took: 0 > wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) I suspect there is a permission problem here. Are you really sure this same configuration works in offline mode?

Re: LDAP Authentication

On Fri, Aug 25, 2023 at 3:09 PM Stephen Frost wrote: Hi Stephen. Thanks for taking the time to make such a detailed response. * Dominique Devienne (ddevie...@gmail.com) wrote: > > could you please provide more info on [...] > > > https://www.crunchydata.com/blog/windows-active-directory-postgres

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

Hi, I've just found the root cause! In this command: ora2pg -c ora2pg.conf -t COPY -a tablename I have created and changed the name of table in postgres. It will not work like that if i don't put replace_table option in config file. Thanks all, my case can be closed now Best Hans Vào Th 6, 25 t

Re: Will PostgreSQL 16 supports native transparent data encryption ?

On 8/24/23 14:08, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: On 8/21/23 18:49, Bruce Momjian wrote: On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote: It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text= Q%3A%20What%20features%20wil