Re: access is denied completely from postgresql!! - Mailing list pgsql-admin

From Jean-Michel POURE
Subject Re: access is denied completely from postgresql!!
Date
Msg-id 200203231318.g2NDIP92028098@www1.translationforge
Whole thread Raw
In response to Re: access is denied completely from postgresql!!  ("David Dunstone" <iaredavey@hotmail.com>)
List 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.  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:

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

pgsql-admin by date:

Previous
From: "David"
Date:
Subject: Re: access is denied completely from postgresql!!
Next
From: Tom Lane
Date:
Subject: Re: access is denied completely from postgresql!!