edit pg_hba.conf
make sure you have the following line:
local all postgres ident sameuser
su to the postgres user
run psql
you should now have full access to the database to add your superuser
back again
On 02/01/2010 08:55 AM, Pedro.Prat.Duran@everis.com wrote:
First of all, good evenings.
I am in big problems. Recently I
have
take charge of the management of a POSTGRESQL database.
I was investigating how it was
working.
In a mistake I remove the superuser role to postgres user
Of course, there is not another user
thar had this role,
It is installed in a linux, so I was
thinking if there is a way to do it with the root user. Is there any
way
to rollback it?
Thanks you in advance
AVISO DE CONFIDENCIALIDAD.
Este correo y la información contenida o adjunta al mismo es privada y
confidencial y va dirigida exclusivamente a su destinatario. everis
informa
a quien pueda haber recibido este correo por error que contiene
información
confidencial cuyo uso, copia, reproducción o distribución está
expresamente
prohibida. Si no es Vd. el destinatario del mismo y recibe este correo
por error, le rogamos lo ponga en conocimiento del emisor y proceda a
su
eliminación sin copiarlo, imprimirlo o utilizarlo de ningún modo.
CONFIDENTIALITY WARNING.This message and the information contained
in or attached to it are private and confidential and intended
exclusively
for the addressee. everis informs to whom it may receive it in error
that
it contains privileged information and its use, copy, reproduction or
distribution
is prohibited. If you are not an intended recipient of this E-mail,
please
notify the sender, delete it and do not read, act upon, print,
disclose,
copy, retain or redistribute any portion of this E-mail.