Thread: Mac client - reconnecting to existing server

Mac client - reconnecting to existing server

From

"Diggs, Asoka"

Date:

04 April 2020, 00:57:56

I think I’m missing something obvious and easy. With the newer pgAdmins that make use of a service + web page for the application, is there a way to close the web page tab, and then reconnect to that existing server easily? Such as a generic URL that doesn’t include the port #.

I’ve found that if I save the URL as a bookmark, then invariably the port saved in the URL is incorrect for the current server and I can’t reconnect. So anytime I close the tab, next time I want pgAdmin, I go find the service and kill it, and then relaunch.

Or alternatively, is there an actual Mac App as there used to be, before the web page app?

Re: Mac client - reconnecting to existing server

From

Murtuza Zabuawala

Date:

04 April 2020, 15:09:09

Hi,

By default pgAdmin4 opens port randomly, but there is an option to choose static port, once you set the port, you can bookmark the link.

Click on the pgAdmin 4 tray-icon
Click "Configure..."
Check the box labeled "Fixed Port Number?"
Enter the desired port number in the field next to it
Restart pgadmin and try again.

On Sat, 4 Apr 2020, 03:28 Diggs, Asoka, <asoka.diggs@intel.com> wrote:

I think I’m missing something obvious and easy. With the newer pgAdmins that make use of a service + web page for the application, is there a way to close the web page tab, and then reconnect to that existing server easily? Such as a generic URL that doesn’t include the port #.

I’ve found that if I save the URL as a bookmark, then invariably the port saved in the URL is incorrect for the current server and I can’t reconnect. So anytime I close the tab, next time I want pgAdmin, I go find the service and kill it, and then relaunch.

Or alternatively, is there an actual Mac App as there used to be, before the web page app?

Re: Mac client - reconnecting to existing server

From

"Diggs, Asoka"

Date:

05 April 2020, 08:56:12

Additional info.

I found the documentation on desktop deployment

https://www.pgadmin.org/docs/pgadmin4/development/desktop_deployment.html

For Mac, it indicates that configuration settings are saved in a .plist file.

I’ll pursue editing that file next week. In theory XCode is the easy way to do the edits. I’ll have to upgrade my OS though to get it installed.

Thanks for the help Murtuza.

From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Date: Saturday, April 4, 2020 at 5:09 AM
To: "Diggs, Asoka" <asoka.diggs@intel.com>
Cc: "pgadmin-support lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: Re: Mac client - reconnecting to existing server

Hi,

By default pgAdmin4 opens port randomly, but there is an option to choose static port, once you set the port, you can bookmark the link.

1. Click on the pgAdmin 4 tray-icon

2. Click "Configure..."

3. Check the box labeled "Fixed Port Number?"

4. Enter the desired port number in the field next to it

5. Restart pgadmin and try again.

On Sat, 4 Apr 2020, 03:28 Diggs, Asoka, <asoka.diggs@intel.com> wrote:

I think I’m missing something obvious and easy. With the newer pgAdmins that make use of a service + web page for the application, is there a way to close the web page tab, and then reconnect to that existing server easily? Such as a generic URL that doesn’t include the port #.

I’ve found that if I save the URL as a bookmark, then invariably the port saved in the URL is incorrect for the current server and I can’t reconnect. So anytime I close the tab, next time I want pgAdmin, I go find the service and kill it, and then relaunch.

Or alternatively, is there an actual Mac App as there used to be, before the web page app?

Re: Mac client - reconnecting to existing server

From

"Diggs, Asoka"

Date:

05 April 2020, 08:56:15

I right click on the Dock icon for pgAdmin 4 – there isn’t a Configure option there (Options, Show Recents, Open).

I’m on Mac rather than Windows. I looked in File, Preferences, and didn’t find a Fixed Port configuration there. I also looked through the Object, Tools, and Help menus and didn’t see anything promising. Searching the online help didn’t match “fixed port”.

Any other ideas?

Hi,

By default pgAdmin4 opens port randomly, but there is an option to choose static port, once you set the port, you can bookmark the link.

1. Click on the pgAdmin 4 tray-icon

2. Click "Configure..."

3. Check the box labeled "Fixed Port Number?"

4. Enter the desired port number in the field next to it

5. Restart pgadmin and try again.

On Sat, 4 Apr 2020, 03:28 Diggs, Asoka, <asoka.diggs@intel.com> wrote:

I think I’m missing something obvious and easy. With the newer pgAdmins that make use of a service + web page for the application, is there a way to close the web page tab, and then reconnect to that existing server easily? Such as a generic URL that doesn’t include the port #.

I’ve found that if I save the URL as a bookmark, then invariably the port saved in the URL is incorrect for the current server and I can’t reconnect. So anytime I close the tab, next time I want pgAdmin, I go find the service and kill it, and then relaunch.

Or alternatively, is there an actual Mac App as there used to be, before the web page app?

Re: Mac client - reconnecting to existing server

From

Jack Royal-Gordon

Date:

05 April 2020, 20:56:29

FWIW, you can edit the .plitst file with any text editor. All you get with Xcode is syntax coloring and it’s a very heavy application for a Mac just for that. I stopped using Xcode for .plist editing several years ago.

On Apr 4, 2020, at 10:56 PM, Diggs, Asoka <asoka.diggs@intel.com> wrote:

Additional info.

I found the documentation on desktop deployment
https://www.pgadmin.org/docs/pgadmin4/development/desktop_deployment.html

For Mac, it indicates that configuration settings are saved in a .plist file.

I’ll pursue editing that file next week. In theory XCode is the easy way to do the edits. I’ll have to upgrade my OS though to get it installed.

Thanks for the help Murtuza.

From: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Date: Saturday, April 4, 2020 at 5:09 AM
To: "Diggs, Asoka" <asoka.diggs@intel.com>
Cc: "pgadmin-support lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: Re: Mac client - reconnecting to existing server

Hi,

By default pgAdmin4 opens port randomly, but there is an option to choose static port, once you set the port, you can bookmark the link.

1.    Click on the pgAdmin 4 tray-icon
2.    Click "Configure..."
3.    Check the box labeled "Fixed Port Number?"
4.    Enter the desired port number in the field next to it
5.    Restart pgadmin and try again.

On Sat, 4 Apr 2020, 03:28 Diggs, Asoka, <asoka.diggs@intel.com> wrote:
I think I’m missing something obvious and easy. With the newer pgAdmins that make use of a service + web page for the application, is there a way to close the web page tab, and then reconnect to that existing server easily? Such as a generic URL that doesn’t include the port #.

I’ve found that if I save the URL as a bookmark, then invariably the port saved in the URL is incorrect for the current server and I can’t reconnect. So anytime I close the tab, next time I want pgAdmin, I go find the service and kill it, and then relaunch.

Or alternatively, is there an actual Mac App as there used to be, before the web page app?