Forum OpenACS Q&A: PostgreSQL remote access

Collapse
1: PostgreSQL remote access
Posted by Johan Liebert on 12/11/07 12:04 AM
I've got a postgreSQL database that I'm using as part of an ajax web application, and I'm trying to figure out how to enable remote access to my DBs.

I've already read the official Postgre tutorial on enabling remote access, but it only explains how to grant access to a specific/specific range of IPs.

However, for my purposes I need to open access to all IPs (obviously I won't be using 'trust' with it)

There's got to be a way to do this with postgre...can anyone help me?

Collapse
2: Re: PostgreSQL remote access (response to 1)
Posted by Dave Bauer on 12/11/07 12:33 AM
I think you'd be better off, blocking all remote access to PG itself, and actually writing a web front end to it.

Of course, that is just my guess from your post.

You might want to check on the #postgresql IRC channel or PostgreSQL mailing lists.