pgsql + psql + su

[rajesh k]

hi ,

i'm workin with rh9 (just a beginner).
I'v installed postgreSQL 7.3.6 on location 
          /usr/local/pgsql
but there is also a default pgsql (i think of rh9)
at location
          /var/lib/pgsql   (this is 7.3.2) 

what i did
--------------
address@hidden root]# cd /usr/local/pgsql/bin
address@hidden bin]# su postgres
bash-2.05b$ pg_ctl -D /usr/local/pgsql/data start
postmaster successfully started

bash-2.05b$ createdb testdb4
CREATE DATABASE
bash-2.05b$ psql testdb4

problem :
------------
1>
psql: relocation error: psql: undefined symbol:
PQgetssl
LOG:  pq_recvbuf: unexpected EOF on client connection

2>
how to solve PQgetssl ??

3>
FATAL:  Database "postgres" does not exist in the
system catalog.
psql: FATAL:  Database "postgres" does not exist in
the system catalog.

4>
bash-2.05b$ su postgres
Password:
su: incorrect password

---- what is the su password ???????????????
---- how can i change it ?????

plz let me al my problems
thanx
bii,   



 

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html