Re: Will PostgreSQL 16 supports native transparent data encryption ?

2023-08-25 Thread Ron
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

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

2023-08-25 Thread duc hiep ha
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: LDAP Authentication

2023-08-25 Thread Dominique Devienne
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

2023-08-25 Thread Luca Ferrari
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: Role for just read the data + avoid CREATE / ALTER / DROP

2023-08-25 Thread David G. Johnston
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: Role for just read the data + avoid CREATE / ALTER / DROP

2023-08-25 Thread Thomas Kellerer
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

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

2023-08-25 Thread Karsten Hilbert
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: LDAP Authentication

2023-08-25 Thread Stephen Frost
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

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

2023-08-25 Thread Durumdara
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

2023-08-25 Thread Dominique Devienne
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

Support for Deferred Constraints in PG15 Logical Replication

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