Re: Unable to connect to a server - Mailing list pgsql-novice

From Obe, Regina
Subject Re: Unable to connect to a server
Date
Msg-id 53F9CF533E1AA14EA1F8C5C08ABC08D205002652@ZDND.DND.boston.cob
Whole thread Raw
In response to Re: Unable to connect to a server  (Bob McConnell <rmcconne@lightlink.com>)
List pgsql-novice
> pgAdmin will not edit the correct files for you. You need to open them

> on that server with a text editor to modify those settings.

Slight correction to Bob's note - not that it helps in this case but I
thought I would set the record straight.

You CAN edit the files from PgAdmin even for a remote server as long as
the adminpack.sql (located in contrib folder) (I think that is the one)
is installed on the postgresql server you are connecting to.  It is
located under Tools->Server Configuration of PgAdmin III.

I do it all the time for quick edits.  Though in general especially for
more involved edits I find it easier to edit the pg_hba.conf and
postgresql.conf files directly.

Hope that helps,
Regina
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to connect to a server
Next
From: "gcj"
Date:
Subject: Re: Automating Postgres Backup