Server(1)

server_icon Server(1)#

In pgAdmin, Server (1) represents the number of PostgreSQL server instances currently registered and available for connection. Each server entry corresponds to a running PostgreSQL service, whether it is local, remote, or cloud-based.

What does Server (1) mean in pgAdmin?#

In pgAdmin, “Server” does NOT mean a physical machine only. It means a PostgreSQL server instance that pgAdmin knows about.

Servers (1)
└── Local PostgreSQL

This tells us:

  • pgAdmin has 1 server registered

  • That server is named Local PostgreSQL

Why is it called a “Server”?#

A PostgreSQL server is:

  • A running PostgreSQL service (process)

  • Listening on a port (usually 5432)

  • Managing databases, users, and connections

Even on your own laptop, PostgreSQL still runs as a server process.

So:

  • Laptop ✔

  • Cloud ✔

  • Remote machine ✔

All are called servers.

Why “Local PostgreSQL”?#

Local PostgreSQL means:

PostgreSQL is running on the same machine as pgAdmin.

Technically:

  • Host: localhost or 127.0.0.1

  • PostgreSQL service started

  • pgAdmin connects locally

“Local” ≠ simple “Local” just means same computer

What if you had more servers?#

If you add more PostgreSQL connections, pgAdmin would show:

Servers (3)
├── Local PostgreSQL
├── Production PostgreSQL (AWS)
└── Staging PostgreSQL
So the number updates automatically:

  • Servers (1)

  • Servers (2)

  • Servers (5)

Server hierarchy#

Inside each Server, PostgreSQL organizes things like this:

Server
├── Databases
│   ├── Schemas
│   │   ├── Tables
│   │   ├── Views
│   │   ├── Functions
├── Login / Group Roles
└── Tablespaces

This is why Server is the top-level object.

Note

Summary

Server (1) indicates that pgAdmin is connected to one PostgreSQL server instance.

Contents