Postgres Pro
Downloads
Home   >   mailing lists

lost superuser perms - Mailing list pgsql-admin

From Davide Bozzelli
Subject lost superuser perms
Date
Msg-id Pine.LNX.4.30.0206211058320.29157-100000@sultan.newtel.it
Whole thread Raw
Responses Re: lost superuser perms  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hi

I have lost the superuser permissions of postgres user.
The postgres user does not have  the "create user"
and "create database" permission .

Are there a way to recover this permissions without
the recreation of the cluster database ?


Thx for help .

pgsql-admin by date:

Previous
From: Werner Modenbach
Date:
Subject: pg_dumpall in crontab
Next
From: "Robson"
Date:
Subject: Default value after table create