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