<html><div style='background-color:'><DIV>
<P>The Postgresql version is 7.0.3-8 and i am running it on Redhat 7.1. I dont really worry about the database backup because i had only basically created a few databases with test data at this stage. So im kind of new to the PostgreSQL. If i try to service it with Webmin, which worked before the crash, Webmin now returns the following kind of error..for example, retrieving a list of users of the system: </P>
<H3>SQL <TT>select * from pg_shadow</TT> failed : <TT>pg_shadow: Permission denied.</TT></H3>
<P>I can see the current data in the current database, just cant do anything with that, add users, or give users permission etc.</P>
<P>I dont mind deleting the databases and starting again!!</P>
<P>thanks!<BR><BR></P></DIV>
<DIV></DIV>
<DIV></DIV>>From: Jean-Michel POURE <JM(dot)POURE(at)FREESURF(dot)FR>
<DIV></DIV>>Reply-To: jm(dot)poure(at)freesurf(dot)fr
<DIV></DIV>>To: "David" <IAREDAVEY(at)HOTMAIL(dot)COM>, <PGSQL-ADMIN(at)POSTGRESQL(dot)ORG>
<DIV></DIV>>Subject: Re: [ADMIN] access is denied completely from postgresql!!
<DIV></DIV>>Date: Sat, 23 Mar 2002 13:11:19 +0100
<DIV></DIV>>
<DIV></DIV>>Le Samedi 23 Mars 2002 12:23, David a crit :
<DIV></DIV>> > I have done nothing, my LInux server crashed, when i went back in, no user
<DIV></DIV>> > had access to PostgreSQL.
<DIV></DIV>> > How do i get access back? Can I somehow just create a new environment with
<DIV></DIV>> > a new database? i dont mind that! I am just not sure how to do it!
<DIV></DIV>> > Do i have to remove PostgreSQL? Cuz it says i haev to remove about 15
<DIV></DIV>> > different dependancies!! which is a pain..and i dont know if it will
<DIV></DIV>> > automatically work with Apache still if i was to do that and reinstall..
<DIV></DIV>> > Help!!
<DIV></DIV>>
<DIV></DIV>>Don't do anything unless we understand what is going on.
<DIV></DIV>>1) What is the version of you PostgreSQL installed (rpm -q postgresql)?
<DIV></DIV>>Alternatively, what is your linux distribution?
<DIV></DIV>>2) Do you have a backup of your database (schema + data)?
<DIV></DIV>>3) What do the logs say when you try to start the database (probably with
<DIV></DIV>>'service postgresql start')?
<DIV></DIV>>
<DIV></DIV>>Regards,
<DIV></DIV>>Jean-Michel POURE
<DIV></DIV>>
<DIV></DIV>>---------------------------(end of broadcast)---------------------------
<DIV></DIV>>TIP 5: Have you checked our extensive FAQ?
<DIV></DIV>>
<DIV></DIV>>http://www.postgresql.org/users-lounge/docs/faq.html
<DIV></DIV></div><br clear=all><hr>Join the worlds largest e-mail service with MSN Hotmail. <a href='http://g.msn.com/1HM301201/13'>Click Here</a><br></html>