[ADMIN] load-testing postgresql servers with Tsung

2008-12-05 Thread Michael Nacos
Hi postgresql admins! I have just finished writing a Tsung tutorial on load-testing Postgresql servers (assessing their load-capacity). Please have a look at the following posts: http://freeyourtech.wordpress.com/2008/07/11/load-testing-a-postgresql-server-with-tsung/ http://freeyourtech.wordpre

Re: [ADMIN] Remote access

2008-12-05 Thread Tino Schwarze
On Fri, Dec 05, 2008 at 03:23:26PM +0530, Abubaker wrote: > I restarted my service and the netstat now shows the correct details. > > TCP0.0.0.0:5432 0.0.0.0:0 LISTENING Looks good. > But its still showing the same error. I am trying to connect with the > "Add Serv

Re: [ADMIN] Remote access

2008-12-05 Thread Tino Schwarze
On Fri, Dec 05, 2008 at 02:51:59PM +0530, Abubaker wrote: > Thanks for the information. But how do I change the listening ip > address to 0.0.0.0 Simply restart postgres. Your listen_addresses = '*' in postgresql.conf should do it. I suppose, you forgot to restart postgresql (reload might not be

Re: [ADMIN] Remote access

2008-12-05 Thread Tino Schwarze
Hi, > I am getting this error when I try to access the database in another computer > within the same network. > > could not connect to server: Connection timed out (0x274C/10060). Is the > server running on host "XX.XX.XX.XX" and accepting TCP/IP connections on port > 5432? > [...] > My

[ADMIN] Remote access

2008-12-05 Thread Abubaker
Hi, I am getting this error when I try to access the database in another computer within the same network. could not connect to server: Connection timed out (0x274C/10060). Is the server running on host "XX.XX.XX.XX" and accepting TCP/IP connections on port 5432? pg_hba.conf changes