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.kocaman@digame.de



> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> majx@lzb.ac.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@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
>
>