Re: access is denied completely from postgresql!!

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: "David Dunstone" <iaredavey(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: access is denied completely from postgresql!!
Date: 2002-03-23 13:18:25
Message-ID: 200203231318.g2NDIP92028098@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le Samedi 23 Mars 2002 13:28, vous avez écrit :
> <html><div style='background-color:'><DIV>
> <P>The Postgresql version is 7.0.3-8 and i am running it on Redhat
> 7.1.&nbsp; I dont really worry about the database backup because i had only
> basically created a few databases with test data at this stage.&nbsp; So im
> kind of new to the PostgreSQL.&nbsp; 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:

Hi David,

1) Upgrade to 7.2

If you are starting with a fresh install, consider using PostgreSQL 7.2.
PostgreSQL 7.2 has many improvements, including WAL support (logging in case
of crash) and much more...

RedHat binary packages can be downloaded from
http://www.rpmfind.net/linux/RPM/rawhide/1.0/i386/RedHat/RPMS/PByName.html.

Download :
postgresql-server-7.2-5
postgresql-contrib-7.2-5
postgresql-devel-7.2-5
postgresql-docs-7.2-5
postgresql-jdbc-7.2-5
postgresql-libs-7.2-5
postgresql-odbc-7.2-5

Also, you may be interested in these server-side languages (which are highly
recommanded):
postgresql-perl-7.2-5
postgresql-python-7.2-5
postgresql-tcl-7.2-5
postgresql-tk-7.2-5

Upgrade all packages at once running : rpm -Uvh postgresql*

rpm might answer dependencies are needed. Go to
http://www.rpmfind.net/linux/RPM/rawhide/1.0/i386/RedHat/RPMS/ and download
the required packages.

2) Install a fresh database
delete /var/lib/pgsql/data directory content (not the directory itself).
Then enter "service postgresql start"
This should create a fresh database in /var/lib/pgsql/data/.

3) More information
Detailed information can be found on :
http://www.postgresql.org/idocs (interactive documentation)
http://techdocs.postgresql.org (techdocs)

To administer your database, you can also have a look at pgAdmin2
(http://pgadmin.postgresql.org) pgAdmin2 takes advantage of the lastest 7.2
improvements.

Regards,
Jean-Michel POURE

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-03-23 17:06:48 Re: access is denied completely from postgresql!!
Previous Message David 2002-03-23 13:11:13 Re: access is denied completely from postgresql!!