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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Keith D(dot) Evans" <evans(at)umbc(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: running postgresql on a private machine accessing it from public web pages
Date: 2009-05-21 17:52:48
Message-ID: 1242928368.16418.17.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Tilton 2009-05-21 18:01:13 Re: Postgres, DB design, and object IDs (of any ilk)
Previous Message Keith D. Evans 2009-05-21 17:49:15 Re: running postgresql on a private machine accessing it from public web pages