Re: access is denied completely from postgresql!!

I just worked out how to initialize a new database location and did that so all working now! I just have to recreate my databases. Thanks!! :)
----- Original Message -----
From: David Dunstone
To: jm(dot)poure(at)freesurf(dot)fr ; pgsql-admin(at)postgresql(dot)org
Sent: Saturday, March 23, 2002 11:28 PM
Subject: Re: [ADMIN] access is denied completely from postgresql!!

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(dot)poure(at)freesurf(dot)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

------------------------------------------------------------------------------
Join the world's largest e-mail service with MSN Hotmail. Click Here