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.