Luckily the recent update to pg_dumpall works (without any extra effort) to dump Globals off the recently launched Google Cloud PostgreSQL service well.
This is because this Postgres service seems to be using the same limitation (as AWS RDS Postgres does) in that none of the user accounts are SuperUser in the Postgres sense. Therefore, this platform too disallows accessing pg_authid.
The fallback here too, is to use pg_roles to read (as much as is possible) to dump Role related Globals. Read here for more info on the recent changes to pg_dumpall that makes this work.
Subscribe to:
Post Comments (Atom)
3x Faster TID Range Scans - Postgres 19
If you've ever had to scrub significantly large tables—whether updating older records or deleting expired ones—you know the pain of tryi...
-
(Please scroll down to the read the entire-post to know more) Documents required for Christian Marriage Registration (a.k.a. Documents... -
A recent commit to the PostgreSQL master branch brings a nice quality-of-life optimization for a very common SQL pattern - improving perform...
-
I am just starting my AI journey, and trying to get Ollama to work on my linux box, was an interesting non-AI experience. I noticed, that ev...
2 comments:
I am grateful to this blog site providing special as well as useful understanding concerning this subject. NEC Brisbane
Post a Comment