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:
SQL select * from pg_shadow failed : pg_shadow: Permission denied.
I can see the current data in the current database, just cant do anything with that, add users, or give users permission etc.
I dont mind deleting the databases and starting again!!
thanks!
>From: Jean-Michel POURE
>Reply-To: jm.poure@freesurf.fr
>To: "David" ,
>Subject: Re: [ADMIN] access is denied completely from postgresql!!
>Date: Sat, 23 Mar 2002 13:11:19 +0100
>
>Le Samedi 23 Mars 2002 12:23, David a écrit :
> > I have done nothing, my LInux server crashed, when i went back in, no user
> > had access to PostgreSQL.
> > How do i get access back? Can I somehow just create a new environment with
> > a new database? i dont mind that! I am just not sure how to do it!
> > Do i have to remove PostgreSQL? Cuz it says i haev to remove about 15
> > different dependancies!! which is a pain..and i dont know if it will
> > automatically work with Apache still if i was to do that and reinstall..
> > Help!!
>
>Don't do anything unless we understand what is going on.
>1) What is the version of you PostgreSQL installed (rpm -q postgresql)?
>Alternatively, what is your linux distribution?
>2) Do you have a backup of your database (schema + data)?
>3) What do the logs say when you try to start the database (probably with
>'service postgresql start')?
>
>Regards,
>Jean-Michel POURE
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
