Postgres Pro
Downloads
Home   >   mailing lists

Re: running postgresql on a private machine accessing it from public web pages - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: running postgresql on a private machine accessing it from public web pages
Date
Msg-id 1242928368.16418.17.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: running postgresql on a private machine accessing it from public web pages  ("Keith D. Evans" <evans@umbc.edu>)
List pgsql-general
Tree view 
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 the postmaster is running from a (different)
> private machine?

A postmaster must be running on whatever database you are trying to
access. You could use replication such as Slony to mirror the linux
database to the solaris one.

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997

pgsql-general by date:

Previous
From: "Keith D. Evans"
Date:
Subject: Re: running postgresql on a private machine accessing it from public web pages
Next
From: Kenneth Tilton
Date:
Subject: Re: Postgres, DB design, and object IDs (of any ilk)