[EMAIL PROTECTED] writes:
>>By default, PostgreSQL allows connection over Unix domain socket and
>>localhost.
>
>I have 3 scripts running on my server, Java, PHP and Perl, Perl and PHP
>works but Java doesn't.
Sorry, I can't be more helpful on Java. Maka-PERL lang ako eh.
>
>>If this is not case, I guess its the pg_hba.conf parser of PostgreSQL.
>>What does /var/log/postgresql say? Do you see the ip address of every
>connection?
>i don't seem to have a /var/log/postgresql file
But this, I think I can :-)
This is what I have on my MDK and PostgreSQL 7.0.3...
in /etc/syslog.conf
local0.* /var/log/postgresql
in pg_options (usually located in /var/lib/pgsql/data/)
verbose=2
query=1
syslog=1
hostlookup
showportnumber
in /etc/logrotate.d/postgres
# you may add 'copytruncate'
/var/log/postgresql {
compress
rotate 2
weekly
}
>>How did you start your PostgreSQL server?
>my server is started automatically. or sometimes i restart it thru
>/etc/rc.d/init.d/httpd restart
Actually it is /etc/rc.d/init.d/postgresql. The output of "cat
/var/lib/pgsql/data/postmaster.opts"
can tell how you started your PostgreSQL 7.0.3.
If you're using Mandrake and you installed PostgreSQL by RPM, make sure
that PostgreSQL is
not compiled with -ffast-math option.
sherwin
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
