pgsql + psql + su

From: rajesh k <softinitiatives(at)yahoo(dot)com>
To: bug-coreutils(at)gnu(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: pgsql + psql + su
Date: 2004-03-29 05:41:19
Message-ID: 20040329054119.49918.qmail@web41311.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)saigun-linux root]# cd /usr/local/pgsql/bin
[root(at)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

Browse pgsql-bugs by date

  From Date Subject
Next Message rahul 2004-03-29 07:51:43 Problem starting postgresql !!
Previous Message Kris Jurka 2004-03-28 19:14:44 Re: BUG #1119: DatabaseMetaData.getTables() returns not a