Fixing 'ServerManager' object has no attribute 'user_info' Error in pgAdmin

Problem Overview

The 'ServerManager' object has no attribute 'user_info' error occurs in pgAdmin when there's a compatibility mismatch between your PostgreSQL server version and the pgAdmin GUI client. This error typically appears when attempting to connect to a database server through the pgAdmin interface.

Root Cause Analysis

The error stems from fundamental changes in PostgreSQL's system catalog structure across different versions:

PostgreSQL Version Compatibility

Starting with PostgreSQL 15, the datlastsysoid column was removed from the pg_database system table. Older pgAdmin versions expect this column to exist, causing the attribute error when connecting to newer PostgreSQL servers.

Additionally, version mismatches between separately installed components can create this compatibility issue.

Solutions

1. Update pgAdmin to Latest Version

The most reliable fix is updating to pgAdmin4 version 6.15 or newer:

Windows

# Download the latest installer from:
# https://www.pgadmin.org/download/

macOS

# Using Homebrew:
brew update
brew upgrade pgadmin4

Newer pgAdmin versions include the necessary adaptations for PostgreSQL 15+ compatibility.

2. Complete Reinstallation (Windows)

If updating doesn't resolve the issue, perform a clean reinstallation:

1. Uninstall both PostgreSQL and pgAdmin4 from "Add or remove programs"
2. Delete the pgAdmin configuration folder:

   C:\Users\[username]\AppData\Roaming\pgAdmin

3. Download and install the latest PostgreSQL bundle from the official website
4. The installer includes a compatible version of pgAdmin4

3. Version Alignment Strategy

Ensure your components are properly matched:

PostgreSQL Version	Recommended pgAdmin Version
9.5-14.x	pgAdmin4 4.x-6.x
15.x+	pgAdmin4 6.15+

WARNING

pgAdmin III only supports PostgreSQL 8.4 to 9.4. For newer PostgreSQL versions, you must use pgAdmin4.

4. Resolve Dependency Issues

The error can sometimes occur due to missing Microsoft Visual C++ redistributables:

Visual C++ Redist

# Download and install the latest VC++ redistributable:
# https://aka.ms/vs/17/release/vc_redist.x64.exe

5. Remove Duplicate Installations

If you have multiple pgAdmin installations:

1. Uninstall all pgAdmin versions
2. Remove any remaining pgAdmin directories
3. Install a single, clean version from the official PostgreSQL bundle

Prevention Best Practices

To avoid similar compatibility issues in the future:

• Always install pgAdmin as part of the PostgreSQL bundle installer
• Regularly update both PostgreSQL and pgAdmin to maintain compatibility
• Check PostgreSQL release notes for breaking changes
• Verify version compatibility before upgrading either component

When to Seek Additional Help

If these solutions don't resolve your issue:

1. Check the pgAdmin GitHub issues for similar reports
2. Review PostgreSQL mailing lists for known compatibility problems
3. Consider using alternative PostgreSQL clients like DBeaver or psql for temporary access

TIP

For enterprise environments, consider using version-locked deployments where PostgreSQL and pgAdmin versions are tested together before deployment.

The 'ServerManager' object has no attribute 'user_info' error is almost always resolvable through proper version management and ensuring compatibility between your PostgreSQL server and pgAdmin client.