Thread: pgsql + psql + su

pgsql + psql + su

From
rajesh k
Date:
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
--------------
root@saigun-linux root]# cd /usr/local/pgsql/bin
[root@saigun-linux 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