Re: access is denied completely from postgresql!!

----- Original Message -----

From: David Dunstone

To: jm.poure@freesurf.fr ; pgsql-admin@postgresql.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.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

---

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