Skip site navigation (1) Skip section navigation (2)

Re: Unable to connect to a server

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Unable to connect to a server
Date: 2008-11-12 13:39:38
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D205002652@ZDND.DND.boston.cob (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-novice by date

Next:From: gcjDate: 2008-11-12 17:26:12
Subject: Re: Automating Postgres Backup
Previous:From: Tom LaneDate: 2008-11-12 13:27:20
Subject: Re: Unable to connect to a server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group