Re: [ADMIN] pg_hba.conf

2004-05-24 Thread Mike G
Your ip address range is probably different when connecting via a VPN rather than in the office. By default postgres will not allow connections from other locations even if tcpip_socket is true without specifying an ip address range, database etc. Checkout the docs. There is a section on pg_hb

Re: [ADMIN] Reliable database communication - Slightly OT

2004-05-24 Thread Radu-Adrian Popescu
twinsen wrote: Hi all I have an architecture 'problem' which I would like to bounce off you. We have five remote Interactive Voice Response sites interconnected via WAN links. I have two Postgresql databases replicated at one of the sites. I need to capture data (mostly stats) from the IVR's and st

[ADMIN] Reliable database communication - Slightly OT

2004-05-24 Thread twinsen
Hi all I have an architecture 'problem' which I would like to bounce off you. We have five remote Interactive Voice Response sites interconnected via WAN links. I have two Postgresql databases replicated at one of the sites. I need to capture data (mostly stats) from the IVR's and store the data i

Re: [ADMIN] pg_hba.conf

2004-05-24 Thread LSanchez
Yes I can ping the server if not connected via VPN. I'm using EMS PostgreSQL Manager, which works if not via VPN. Yes, postgresql.conf's tcpip_socket = true. The log says: FATAL: No pg_hba.conf entry for host 10.29.15.113, user postgres, database TEST. Thanks for your help! Regards, - Lily A

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Ericson Smith
We'd be very interested in the performance, especially with the disk being used as in interconnect (I assume that that is being used to simulate global shared memory?) We did have a talk with the folks over at http://www.linuxlabs.com/clustgres They were honest enough to say that even with the D

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Greg Spiegelberg
2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera 510 storage cluster with Xyratex SATA on the backend configured with 1+0 LUN's. It w

Re: [ADMIN] Missing or errooneous pg_hba.conf file

2004-05-24 Thread Bill Chandler
Hi all, I had my Solaris 8 machine upgraded with latest patches. No change. Still does not like 255.255.255.255. Using the alternate format of IP-address/32 does fix the problem, though so glad to have a workaround. Still it would be nice to know why this happens on some systems and not on oth

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Ericson Smith
Do you mean that you are actually testing this product now? If so, what's the hardware configuration (nodes, storage server, interconnects) that you are using? Warmest regards, Ericson Smith Tracking Specialist/DBA +---+-+ | http://www

Re: [ADMIN] Clustering Postgres

2004-05-24 Thread Greg Spiegelberg
Robert, I am currently evaluating PolyServe Matrix Server which is a clustering solution including a clustered file system (mounted read-write everywhere). Anything special anyone wants to know? I'm using PostgreSQL 7.4.2 in a Linux cluster. Greg Robert Treat wrote: On Thu, 2004-05-20 at 14:30, Kr