You can use pg_dumpall -g to get user information for the cluster.
Regards,
Priyanka
On Thu, 12 Oct 2023 at 3:46 PM, Jana Mihalidesová
wrote:
> Hi,
>
> I try to find out some view, select or something what show me the
> privileges for the user across the whole postgresql cluster. The
> username
You have to run vacuumlo to remove orphaned large objects.
https://www.postgresql.org/docs/current/vacuumlo.html
Regards,
Priyanka
On Sun, 21 Jul 2024 at 12:46 AM, wrote:
> Hello All,
>
> I've got a cluster that's having issues with pg_catalog.pg_largeobject
> getting massively bloated. Vacuum
Vacuum Full will not help here if you have large objects present in the
pg_largeobjects table but not being referred to by any table. Vacuumlo
doesn't require downtime but based on the data it needs to remove can run
long and use resources and hence schedule it in off peak hours. You can do
a dry r
Hi Adrian,
There is patroni and pgqd running on the server. So possibly these are
using psycopg2.
Regards,
Priyanka
On Sun, 13 Oct 2024 at 6:01 PM, Adrian Klaver
wrote:
> On 10/10/24 11:36, Priancka Chatz wrote:
> > Hi admins,
> >
> > I am observing a new/unknown b
