[GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Keith D. Evans
We have a private machine that runs postgresql and have created a database. We want to access that database from the web for plotting using php. The web server and pages are on a public (different) machine that does not have postgresql. Nor will they install it for is. The postgresql database

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Joshua D. Drake
So, the question is, can someone go through these (public) web pages and access the postgresql database if the postgresql server is running on the private machine? We have other data in the postgresql and would like to only have to use one database types, i.e., postgresql. If you are

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Keith D. Evans
Joshua, Let me rephrase what I wrote. The database is on a public machine (Linux), but the postgresql postmaster runs on a private machine (Solaris 10). Can we access the postgresql database through the public machine, even though the postmaster is running from a (different) private

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Joshua D. Drake
On Thu, 2009-05-21 at 13:49 -0400, Keith D. Evans wrote: Joshua, Let me rephrase what I wrote. The database is on a public machine (Linux), but the postgresql postmaster runs on a private machine (Solaris 10). Can we access the postgresql database through the public machine, even though

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Raymond O'Donnell
On 21/05/2009 18:49, Keith D. Evans wrote: The database is on a public machine (Linux), but the postgresql postmaster runs on a private machine (Solaris 10). That doesn't make a lot of sense, unless you've got *two* postmasters running, one on each machine, or maybe you've created a tablespace

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Keith D. Evans
We usually run postgresql on a private machine (gravity) but due to space, we have moved the database to a different machine through afs (a local network at the university). We do not want the private machine to be accessible to outside users, so our web pages are on the university's public

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Scott Mead
In your application, the connection string should have the ip address of the postgres server. The postgres server (solaris box) should allow port 5432 through the firewall. If you cannot access port 5432 on your solaris box from the linux box, then make sure that you don't have a firewall in

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 12:23 PM, Keith D. Evans ev...@umbc.edu wrote: We usually run postgresql on a private machine (gravity) but due to space, we have moved the database to a different machine through afs (a local Wait, the whole database, including a postmaster running on the other machine?

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Scott Marlowe
On Thu, May 21, 2009 at 1:04 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Thu, May 21, 2009 at 12:23 PM, Keith D. Evans ev...@umbc.edu wrote: We usually run postgresql on a private machine (gravity) but due to space, we have moved the database to a different machine through afs (a local

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

2009-05-21 Thread Reid Thompson
Keith D. Evans wrote: We usually run postgresql on a private machine (gravity) but due to space, we have moved the database to a different machine through afs (a local network at the university). We do not want the private machine to be accessible to outside users, so our web pages are on the