repository on Postgresql 8.0 (freebsd)

Classic Servoy
1

Hi folks,

I’ve to put my repository on a freebsd server with Postgresql 8.0 (the new stable port).

I’ve logged on pgsql (psql -U pgsql template1), I’ve created a database (servoy) and I’ve added an user (create user servoy passwor xxx creadb).

Now I’m trying to connect with Servoy, but I receive always the same answer: or usr/pass wrong, or postmaster without -i option (to accept TCP connections).

Well, what I’ve to do? I don’t know where could I put the -i option, the sh script in /usr/local/etc/rc.d hasn’t that option.

Any suggestion will be appreciated
Regards
Andrea

2

uhmm …

sockstat -4
pgsql postgres 229 9 tcp4 127.0.0.1:5432 :

I waited:
pgsql postgres 229 9 tcp4 127.0.0.1:5432 :
pgsql postgres 229 9 tcp4 192.168.1.11:5432 :

because in my postgresql.conf I’ve:
listen_addresses = ‘*’
port = 5432

Where is my mistake?

Thanks for your support
Regards
Andrea

3

uops … it works :)
Only a kill -HUP …

Thanks for all
regards
Andrea

4

Hi Andrea,

Maybe you already know this but…for future reference:
If you want to connect to PostgreSQL from a remote machine you have to add your IP (mask) to pg_hba.conf.
Localhost is already added by default :)

Also you can control PostgreSQL with pg_ctl.
Like pg_ctl reload to reload the properties.
pg_ctl is in the same place as psql is.

Btw you also made sure Servoy uses the latest jdbc driver ?
You can get it from http://jdbc.portgresql.org

5

thank you very much :)
I’ve solved,

regards
Andrea