Re: postgres "on in the internet" - Mailing list pgsql-general

From Jeff Amiel
Subject Re: postgres "on in the internet"
Date
Msg-id 4138667A.10809@istreamimaging.com
Whole thread Raw
In response to postgres "on in the internet"  (Paul Tillotson <pntil@shentel.net>)
List pgsql-general
Well...if it's truly a client/server app, why not have the client app
talk to the server who actually executes the SQL.  That way no remote
access to the database is required.
IMHO, it's a 'bad thing' to have your database exposed to the internet....

Jeff Amiel


Paul Tillotson wrote:

> At my company we are looking at deploying clients for our
> client/server app outside our firewall, which will then require our
> postgres box to be internet-accessible.
> Does anyone out there have experience with this or recommended best
> practices?  We have been looking at either (a) tunnelling everything
> over ssh, or (b) just making sure that users have "strong" passwords
> and requiring "md5" authentication in pg_hba.conf.
>


pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: test message -- wondering if the list is down -- please delete
Next
From: Richard Huxton
Date:
Subject: Re: How to determine a database is intact?