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
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