<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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 have full 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(dot)Prat(dot)Duran(at)everis(dot)com">Pedro(dot)Prat(dot)Duran(at)everis(dot)com</a> wrote:
<blockquote
cite="mid:OFEB149BD8(dot)7D062D96-ONC12576BD(dot)0049D9F0-C12576BD(dot)004C7CE1(at)everis(dot)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 do it with the root user. Is there any
way
to rollback it?</font>
<br>
<br>
<font face="sans-serif" size="2">Thanks you in advance</font>
<br>
<font face="sans-serif" size="2"><br>
</font>
<br>
<font face="Arial" size="1" color="#5f5f5f"><b><br>
AVISO DE CONFIDENCIALIDAD.</b><br>
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.<br>
<b><br>
CONFIDENTIALITY WARNING.</b>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.</font>
<br>
</blockquote>
<br>
</body>
</html>