PostgreSQL DBA
@postgres_tech
2.15K
subscribers
91
photos
1
video
20
files
216
links
Sharing knowledge about postgresql database
Download Telegram
Join
PostgreSQL DBA
2.15K subscribers
PostgreSQL DBA
Channel created
PostgreSQL DBA
https://paquier.xyz/postgresql-2/postgres-12-jsonpath/
PostgreSQL DBA
https://stackoverflow.com/questions/59951713/make-column-editiable-in-pgadmin4
Stack Overflow
Make column editiable in pgadmin4
How to unlock the fields in pgadmin4 so I can insert/update column directly threw pgadmin4 Data Output result.
Please refer below image displaying lock icon in each field
I want result like below...
PostgreSQL DBA
https://blog.dbi-services.com/postgresql-13-trusted-extensions/
Blog dbi services
PostgreSQL 13: Trusted extensions - Blog dbi services
PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or you need to implement something like…
PostgreSQL DBA
https://www.percona.com/blog/2020/09/30/postgresql_fdw-authentication-changes-in-postgresql-13/
Percona Database Performance Blog
Postgresql_fdw Authentication Changes in PostgreSQL 13 - Percona Database Performance Blog
Ibrar Ahmed explains the postgresq_fdw security and authentication changes in PostgreSQL 13.
PostgreSQL DBA
https://www.citusdata.com/blog/2020/07/28/securely-authenticate-with-scram-in-postgres-13/
Citusdata
How to securely authenticate with SCRAM in Postgres 13
Step-by-step tutorial on how to set up password authentication using SCRAM with channel binding in Postgres, by the developer who implemented the client connection parameter in Postgres 13. Includes background on SCRAM with channel binding, and how to tell…
PostgreSQL DBA
https://blog.hagander.net/repartitioning-with-logical-replication-in-postgresql-13-246/