On 1/10/2010 9:24 PM, Andrus wrote:
> How to configure remote servers where only port 5432 is open ?
You can't. You need to be able to modify postgresql.conf .
> Why pgAdmin postgresql.conf editor does not contain automatic
> configurator ?
Because nobody has written one for PgAdmin. The EnterpriseDB
configuration assistant is a commercial product that EnterpriseDB are
letting people use for free. Nobody's stepped up to do the incredible
amount of testing and benchmarking required to create a configuraton
assistant for inclusion in PgAdmin.
Such tools are a guide at best; they won't just magically configure your
system perfectly. All databases need a degree of tuning to achieve
optimal performance, and PostgreSQL is no exception.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/