RH 6.0 and PostgreSQL

Did you perhaps previously build postgres yourself, and now maybe Redhat
has overwritten the configuration?

Ricardo Peres wrote:

Hello,

After upgrading to RedHat 6.0, PostgreSQL no longer works...
Whenever I try to start the postmaster daemon, using
/erc/rc.d/init.d/postmaster script, I receive a message about postgresql
not finding the data directory. I checked /var/lib/pgsql, and in fact it
does not contain anything!
Am I missing something?

Thanks in advance!

PS-BTW, please e-mail-me directly, as I am not subscribed to this list!

-----------------------------------------------------------------------------
Ricardo Peres
E-mail: rjperes@student.dei.uc.pt
ICQ UIN: 708926
TM: 0931 9459192
Departamento de Engenharia Inform�tica
Universidade de Coimbra
PORTUGAL
-----------------------------------------------------------------------------

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com

Ricardo Peres wrote:

Hello,

After upgrading to RedHat 6.0, PostgreSQL no longer works...
Whenever I try to start the postmaster daemon, using
/erc/rc.d/init.d/postmaster script, I receive a message about postgresql
not finding the data directory. I checked /var/lib/pgsql, and in fact it
does not contain anything!
Am I missing something?

Redhat didn't configure it correct. (I'm getting tired of Redhat but what's the
alternative ... *hmmm*)

What I did to solve the problem was (cut-and-paste from my rh60hist.txt file):

1. Add environment variables to /etc/profile:

# To enable postgresql:
export PGLIB=/usr/lib/pqsql
export PGDATA=/var/lib/pqsql

2. from root; "su postgres"

3. "initdb" initializes database.

4. Edit /var/lib/pgsql/pg_hba.conf to allow only local access:

local all trust

(you may want to allow remote access as well)

5. Now postmaster is able to start (as root).

/etc/rc.d/init.d/postgresql start

6. Test postgresql with:

su postgres, createdb, psql, SELECT datetime 'now';, \q to quit.

\? or \h gives help. Commands with \ are NOT SQL and must not end with ;,
while SQL commands ALWAYS ends with ;

7. Add users

[postgres@thor pgsql]$ createuser mj
Enter user's postgres ID or RETURN to use unix user ID: 1000 ->
Is user "mj" allowed to create databases (y/n) y
Is user "mj" allowed to add users? (y/n) n
createuser: mj was successfully added

Hope it is usefull!

By the way, what GUI is recommendable for postgresql ?

pgaccess is also not running on Redhat 6.0. It reports:

Error in startup script: couldn't load file "libpgtcl.so": /usr/lib/libpgtcl.so:
undefined symbol: crypt
while executing
"load libpgtcl.so"
(procedure "main" line 6)
invoked from within
"main $argc $argv"
(file "/usr/bin/pgaccess" line 4954)

Regards,

Michael

On Sun, 16 May 1999, Ricardo Peres wrote:

After upgrading to RedHat 6.0, PostgreSQL no longer works...
Whenever I try to start the postmaster daemon, using
/erc/rc.d/init.d/postmaster script, I receive a message about postgresql
not finding the data directory. I checked /var/lib/pgsql, and in fact it
does not contain anything!
Am I missing something?

The extra postgres stuff in the distribution - did you install all the
postgres rpms?

cr