Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can' t Connecting over tcp ip socket linux

Status
Not open for further replies.

encore4

IS-IT--Management
Nov 16, 2006
4
SE
Hi
I am a newbie, but I am on my way becoming sysadmin Linux.
I have really done my job searching the internet ,but getting nowhere in over a week
I hope this is the apropriate place to write this question.
I have an issue that I don't understand concerning the manual

My job is to install Openbravo on a little company.

Computer 1 holds openbravo,jakarta-tomcat and jdk,apache-ant

computer 2 holds postgresql

my main question here :
How shall my commandline look exactly if i want to connect from computer 1 over tcp/ip socket., and how should pg_hba.conf look amd which option is important in postgresql.conf
I have tried this on computer 2 with no success

[postgres@dbs2 postgres]$ /usr/local/pgsql/bin/postmaster -i -p 5432 -U tad -d openbravo -D /data/postgres/PostGreSQL/pgsql/data/ >logfile 2>&1 &
[1] 3880
[postgres@dbs2 postgres]$

[postgres@dbs2 postgres]$ /usr/local/pgsql/bin/psql -h - mars.capvert.ins -U tad -d openbravo
psql: warning: extra command-line argument "mars.capvert.ins" ignored
psql: could not translate host name "-" to address: Name or service not known
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -p 5432 -U tad -d openbravo -D /data/postgres/PostGreSQL/pgsql/data/ >logfile 2>&1
[postgres@dbs2 postgres]$


and sometimes when started with other commandline i get
[postgres@dbs2 postgres]$ /usr/local/pgsql/bin/psql openbravo
psql: FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.
[postgres@dbs2 postgres]$

server log in this case.Which file?

Very greatful for help or forwarding me to right thread

ps.I have installed postgresql from source postgresql-8.1.4
on Redhat
ds.
/Johan
 
/usr/local/pgsql/bin/psql -h - mars.capvert.ins -U tad -d openbravo
this is wrong

should be /usr/local/pgsql/bin/psql -h mars.capvert.ins -U tad -d openbravo

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top