Shared Servers in pgAdmin 4

January 04, 2022


Shared servers allow the admin user to share servers with other users so that they can use them directly without adding them themselves.

Shared servers only apply when pgAdmin is running in server mode. Server mode is a multi-user mode whereas Desktop mode is single user mode. In server mode users must login before they can use pgAdmin. An initial superuser account is created when server mode is initialised, and this user can add additional superusers and non-superusers as required.

How to share a server in pgAdmin 4

To share a server, you need to have admin privileges in pgAdmin. Once you are logged in as an admin, then you can share a server while creating a new one or you can also share an existing server. Admin users can share the server by enabling the "Shared?" option.

Create a server window

Please note that once the server is shared, the server icon will change in the browser tree.

This option is only visible to admin users; non-admin users won't be able to share the server with others. It is only available in server mode.

pgadmin shared server menu

Once the server is shared, users who are not the owner of the server will see the shared server in the respective server group. The entire server group will be shared if it has one shared server in it but only shared servers in that server group will be visible to other users.

pg admin browser looking at a shared server group

Connect to a shared server

To connect to the shared server, a user who is not the owner of the server needs to enter a username. The "Properties" dialog will open if the user clicks on a shared server for the very first time and then the user needs to enter the username and password to connect to the server.

connecting to a shared server with pg admin

Who shared the server?

Users can see the shared server owner in the properties panel. This field is only visible to users other than the owner of the server.

properties view of a shared server

Restrictions for non-admin users

Non-admin users can access the shared servers with some restrictions - the following operations on shared servers are not permitted:

  • Delete the server
  • Rename the server
  • Rename the server group
  • Change of host, port, and maintenance database

Hiding a shared server

If the user doesn't want to see shared servers then at any time they can hide them all by changing the preferences setting:

Preferences view under display choosing the hide shared servers option


Shared servers are useful to avoid the repetitive process of adding the same server for each user. Once the server is shared by an admin user then it will be visible to all users unless they have chosen to hide them.

Share this

Relevant Blogs

pgAdmin User Management in Server Mode

pgAdmin can be deployed as a web application by configuring the app to run in server mode. One can check out server deployment on how to run pgAdmin in...
August 24, 2023

pgAdmin CI/CD

Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back...
August 24, 2023

More Blogs

EDB Postgres Advanced Server 15 TPS Benchmark

Overview There is often a need to increase the count of user-base connected to an application mainly due to business requirements due to factors such as business growth and addition...
August 22, 2023

Guide to ANY_VALUE() Functionality in PostgreSQL 16

Introduction The demand for effective and robust database management solutions has never been higher as businesses continue to produce and analyze enormous amounts of data. One of the top relational...
August 08, 2023