Re: ask for help about postgresql

hi,

try this in pg_hba.conf ,
if the db is on the same machine:
local all all trust
if db is on another machine in the local network
host all all "ip_of_the_machine_to_connect_from" 255.255.255.0 trust

Afterwards you need to reload the server (SIGHUP or pg_ctl reload)

More documnetation you fin in the file pg_hba.conf.
You can find this file in the data_directory of your PostgreSQL-Installation,
default is /us/local/pgsql/data/

Best regards

Hakan Kocaman

Software-Developer
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln

Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98

Email: hakan(dot)kocaman(at)digame(dot)de

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
> majx(at)lzb(dot)ac(dot)cn
> Sent: Wednesday, August 11, 2004 8:42 AM
> To: pgsql-general
> Subject: [GENERAL] ask for help about postgresql
>
>
> hi,
> I'm trying to instal postgresql to support an open-source
> software named dspace. I have already installed sdk, tomcat5,
> postgresql8.0.3, but when I install dspace, I met error says
> [java] Exception:java.net.SocketException: Invalid argument
> or cannot assign requested address. I think perhaps there
> some porblem in the install and configure of postgresql.
> Would you please help me to solve this problem? Thank you.
>
> majx
>
>
>
> [root(at)localhost dspace-1.3.1-source]# ant fresh_install
> Buildfile: build.xml
>
> compile:
>
> install_code:
>
> build_wars:
>
> init_configs:
>
> setup_database:
> [java] 2005-08-11 11:27:31,152 INFO
> org.dspace.storage.rdbms.InitializeDat abase @ Initializing Database
> [java] 2005-08-11 11:27:31,637 FATAL
> org.dspace.storage.rdbms.InitializeDat abase @ Caught exception:
> [java] org.postgresql.util.PSQLException: try to connect
> unsuccessed
> [java] Exception:java.net.SocketException: Invalid
> argument or cannot assi gn requested address
> [java] Stack Trace:
> [java] java.net.SocketException: Invalid argument or
> cannot assign requeste d address
> [java] at
> java.net.PlainSocketImpl.socketConnect(Native Method)
> [java] at
> java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
> [java] at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.jav a:171)
> [java] at
> java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
> [java] at java.net.Socket.connect(Socket.java:452)
> [java] at java.net.Socket.connect(Socket.java:402)
> [java] at java.net.Socket.<init>(Socket.java:309)
> [java] at java.net.Socket.<init>(Socket.java:124)
> [java] at
> org.postgresql.core.PGStream.<init>(PGStream.java:58)
> [java] at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm
> pl(ConnectionFactoryImpl.java:77)
> [java] at
> org.postgresql.core.ConnectionFactory.openConnection(Connecti
> onFactory.java:65)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJ
> dbc2Connection.java:117)
> [java] at
> org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.j ava:24)
> [java] at org.postgresql.Driver.connect(Driver.java:235)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:512)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:171)
> [java] at
> org.apache.commons.dbcp.DriverManagerConnectionFactory.create
> Connection(DriverManagerConnectionFactory.java:48)
> [java] at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
> PoolableConnectionFactory.java:290)
> [java] at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G
> enericObjectPool.java:771)
> [java] at
> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j ava:175)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:512)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:193)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa
> seManager.java:446)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:777)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:71)
> [java] End of Stack Trace
>
> [java] at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionIm
> pl(ConnectionFactoryImpl.java:136)
> [java] at
> org.postgresql.core.ConnectionFactory.openConnection(Connecti
> onFactory.java:65)
> [java] at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJ
> dbc2Connection.java:117)
> [java] at
> org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.j ava:24)
> [java] at org.postgresql.Driver.connect(Driver.java:235)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:512)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:171)
> [java] at
> org.apache.commons.dbcp.DriverManagerConnectionFactory.create
> Connection(DriverManagerConnectionFactory.java:48)
> [java] at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(
> PoolableConnectionFactory.java:290)
> [java] at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(G
> enericObjectPool.java:771)
> [java] at
> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.j ava:175)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:512)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:193)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.getConnection(Databa
> seManager.java:446)
> [java] at
> org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseMana
> ger.java:777)
> [java] at
> org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDa
> tabase.java:71)
>
> BUILD FAILED
> /usr/local/dspace-1.3.1-source/build.xml:266: Java returned: 1
>
> Total time: 7 seconds
>
>