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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "David" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
>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
