Re: access is denied completely from postgresql!!

<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
reallyworry 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
nowreturns the following kind of error..for example, retrieving a list of users of the system: <h3>SQL <tt>select *
frompg_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>I dont mind deleting the databases
andstarting again!!<p>thanks!<br /><br /></div><div></div><div></div>>From: Jean-Michel POURE
<div></div>>Reply-To:jm.poure@freesurf.fr <div></div>>To: "David" ,  <div></div>>Subject: Re: [ADMIN] access
isdenied completely from postgresql!! <div></div>>Date: Sat, 23 Mar 2002 13:11:19 +0100 <div></div>>
<div></div>>LeSamedi 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
accessback?  Can I somehow just create a new environment with <div></div>> > a new database? i dont mind that!  I
amjust 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>> >
automaticallywork with Apache still if i was to do that and reinstall.. <div></div>> > Help!! <div></div>>
<div></div>>Don'tdo anything unless we understand what is going on. <div></div>>1) What is the version of you
PostgreSQLinstalled (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
tryto 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
ofbroadcast)--------------------------- <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
world�slargest e-mail service with MSN Hotmail. <a href="http://g.msn.com/1HM301201/13">Click Here</a><br />