Re: Mac client - reconnecting to existing server (RESOLUTION) - Mailing list pgadmin-support

From Dave Page
Subject Re: Mac client - reconnecting to existing server (RESOLUTION)
Date
Msg-id CA+OCxowSCj81GWbJucDJR_-e2iKnj2wUevtwQACBCPcRJGJ6WA@mail.gmail.com
Whole thread Raw
In response to Re: Mac client - reconnecting to existing server (RESOLUTION)  ("Diggs, Asoka" <asoka.diggs@intel.com>)
Responses Re: Mac client - reconnecting to existing server (RESOLUTION)
List pgadmin-support


On Mon, Apr 6, 2020 at 5:19 PM Diggs, Asoka <asoka.diggs@intel.com> wrote:

Success!  I’ve moved pgAdmin to a static port.  For other Mac users, here is what I did.

 

Open Terminal window and:

cd ~/Library/Preferences

plutil -convert xml1 org.pgadmin.pgadmin4.plist 

vi org.pgadmin.pgadmin4.plist 

 

In the text file, add (I think the area to add this is obvious):

       <key>FixedPort</key>

       <string>TRUE</string>

       <key>PortNumber</key>

       <integer>60000</integer>

 

Save and exit file.  Back at command line:

plutil -convert binary1 org.pgadmin.pgadmin4.plist 

 

Close the pgAdmin tab and kill the server using Activity Monitor.

 

Restart (I found that the updated .plist file wasn’t being seen without the Restart).

 

 

You can use any text editor where I used vi.  The problem I ran into is that the GUI editors wouldn’t let me edit something in the ~/Library folder, and I’m enough of a Mac noob to not know how to get around that.  So I used vi to get the job done.

 

These details might be valuable in the pgAdmin documentation.


Seems like a very long winded way of doing it. Why not just use the Configuration Dialogue (yes, I know the styling looks a little different to current releases - I'm hacking on that at the minute)?

Screenshot 2020-04-06 at 17.23.03.png
 
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment

pgadmin-support by date:

Previous
From: "Diggs, Asoka"
Date:
Subject: Re: Mac client - reconnecting to existing server (RESOLUTION)
Next
From: "Diggs, Asoka"
Date:
Subject: Re: Mac client - reconnecting to existing server (RESOLUTION)