Re: explicit-locking.html "key values" reference

On Fri, May 26, 2023 at 8:02 PM jian he wrote: > > I still feel confused about "the key values". > The "key" here is the Foreign Key relationship. In short, FOR NO KEY UPDATE, promises that PK/FK values on the table will not be changed. Only non-FK/PK columns can be changed. In neither case m

explicit-locking.html "key values" reference

hi. https://www.postgresql.org/docs/current/explicit-locking.html FOR KEY SHARE > Behaves similarly to FOR SHARE, except that the lock is weaker: SELECT > FOR UPDATE is blocked, but not SELECT FOR NO KEY UPDATE. A key-shared > lock blocks other transactions from performing DELETE or any UPDATE tha

Query to find RDS endpoint

Hi, Could someone help me in sharing a postgresql query to fetch the RDS endpoint ? Postgres version 14.6. I tried to search but couldn't find it. Regards.

Re: PostgreSQL GSSAPI Windows AD

Have you tried your tickets on the client machine ? From my (little) understanding, the postgresql server complain that the client initiated the communication with an ticket signed with a different key (kvno 3 vs. 4). Hope it help. For information here the differences from your setup with mine (de

Suggestions on pg_statviz Extension

Hi Everyone, I am working on a PostgreSQL extension pg_statviz [1] as a part of GSoC'23 with the motivation of developing a tool that helps dba's monitor their running database effortlessly. The extension would accumulate statistics about the database over a

Re: PostgreSQL GSSAPI Windows AD

Dear Tumasgiu Rossini, When I do the ktpass command on Windows AD, I can see that there is no other AD account mapped, otherwise it will raise an exception (Failed to set property 'servicePrincipalName'). Here is the klist command: root@SFADAPGDDF02:/# klist -k /etc/postgresql/postgres.keytab K

Re: DB migration : Sybase to Postgres

On 5/26/23 08:38, Peter J. Holzer wrote: On 2023-05-25 08:10:42 -0500, Ron wrote: (You can create the FKs ahead of time, but use the NOT VALID clause; then, after data is loaded do ALTER TABLE ... VALIDATE CONSTRAINT.) I don't think this will work: | Normally, [ADD CONSTRAINT] will cause a sca

Re: DB migration : Sybase to Postgres

On 2023-05-25 08:10:42 -0500, Ron wrote: > (You can create the FKs ahead of time, but use the NOT VALID clause; then, > after data is loaded do ALTER TABLE ... VALIDATE CONSTRAINT.) I don't think this will work: | Normally, [ADD CONSTRAINT] will cause a scan of the table to verify | that all exis

Re: DB migration : Sybase to Postgres

Em qui., 25 de mai. de 2023 às 08:30, Sengottaiyan T escreveu: > Is there an option to set novalidate constraints in postgres? In my source > Sybase DB, table structures are not defined properly (only primary keys > exist and no foreign key) - I'm making necessary changes on target Postgres > DB

Re: Having issue with SSL.

On 2023-05-24 21:02:04 +, Randy Needham wrote: > The problem I am running into is my remote client can't connect via SSL to > postgrsql. I am able to from the server itself. This is using pgAdmin 4 and > making ssl mode as required. Also ran psql.exe on the server to show that SSL > was in f