edit pg_hba.conf<br /> make sure you have the following line:<br /> local all
postgres ident sameuser<br /><br /> su to the postgres user<br /> run psql<br /> you should now
havefull access to the database to add your superuser back again<br /><br /><br /><br /> On 02/01/2010 08:55 AM, <a
class="moz-txt-link-abbreviated"href="mailto:Pedro.Prat.Duran@everis.com">Pedro.Prat.Duran@everis.com</a> wrote:
<blockquotecite="mid:OFEB149BD8.7D062D96-ONC12576BD.0049D9F0-C12576BD.004C7CE1@everis.com" type="cite"><br /><font
face="sans-serif"size="2">First of all, good evenings.</font><br /><br /><font face="sans-serif" size="2">I am in big
problems.Recently I have take charge of the management of a POSTGRESQL database.</font><br /><br /><font
face="sans-serif"size="2">I was investigating how it was working. In a mistake I remove the superuser role to postgres
user</font><br/><br /><font face="sans-serif" size="2">Of course, there is not another user thar had this role,
</font><br/><br /><font face="sans-serif" size="2">It is installed in a linux, so I was thinking if there is a way to
doit with the root user. Is there any way to rollback it?</font><br /><br /><font face="sans-serif" size="2">Thanks you
inadvance</font><br /><font face="sans-serif" size="2"><br /></font><br /><font color="#5f5f5f" face="Arial"
size="1"><b><br/> AVISO DE CONFIDENCIALIDAD.</b><br /> Este correo y la información contenida o adjunta al mismo es
privaday confidencial y va dirigida exclusivamente a su destinatario. everis informa a quien pueda haber recibido este
correopor 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
delemisor y proceda a su eliminación sin copiarlo, imprimirlo o utilizarlo de ningún modo.<br /><b><br />
CONFIDENTIALITYWARNING.</b>This message and the information contained in or attached to it are private and confidential
andintended exclusively for the addressee. everis informs to whom it may receive it in error that it contains
privilegedinformation and its use, copy, reproduction or distribution is prohibited. If you are not an intended
recipientof this E-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain
orredistribute any portion of this E-mail.</font><br /></blockquote><br />
