Thread: FATAL MISTAKE WITH POSTGRE MANAGER

<br /><font face="sans-serif" size="2">First of all, good evenings.</font><br /><br /><font face="sans-serif"
size="2">Iam in big problems. Recently I have take charge of the management of a POSTGRESQL database.</font><br /><br
/><fontface="sans-serif" size="2">I was investigating how it was working. In a mistake I remove the superuser role to
postgresuser</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
wayto do it with the root user. Is there any way to rollback it?</font><br /><br /><font face="sans-serif"
size="2">Thanksyou in advance</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
mismoes privada y confidencial y va dirigida exclusivamente a su destinatario. everis informa a quien pueda haber
recibidoeste correo por error que contiene información confidencial cuyo uso, copia, reproducción o distribución está
expresamenteprohibida. Si no es Vd. el destinatario del mismo y recibe este correo por error, le rogamos lo ponga en
conocimientodel emisor 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 /> 

On 01/02/2010 13:55, Pedro.Prat.Duran@everis.com wrote:

> 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?

Backups?

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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 />