Skip go content

PostgreSQL

ApplicationPostgreSQL Global Development Group

Dem still dey call am postgres, pgsql

PostgreSQL Global Development GroupProductivity

The PostgreSQL database server. On top Windows the service process na postgres.exe. The installer fit also add pgAdmin. E no be MySQL.

Wetin you need know

PostgreSQL na postgres.exe. MySQL na mysqld.exe.

postgres.exe na the PostgreSQL server. The Windows installer fit add pgAdmin. MySQL na different server. DBeaver and pgAdmin na clients, no be the engine.

Wetin e be?
PostgreSQL database server
Same as MySQL?
No. Different engine and exe
Dem must need pgAdmin?
No. The installer fit add am
Feex tok say
If postgres.exe dey run, I dey treat am as the database server. I no go stop mysqld.exe to free Postgres, and I no go uninstall pgAdmin to remove the server.

Wetin be PostgreSQL?

PostgreSQL na the database server. postgres.exe na the Windows process. E no be MySQL, no be pgAdmin, and no be DBeaver.

If you never use am before

If class say make you install PostgreSQL, use the Windows installer from postgresql.org/download/windows. postgres.exe na the server. To check pgAdmin inside the installer dey add pgAdmin4.exe. Dat GUI na optional. MySQL na different engine with mysqld.exe. DBeaver fit connect to any of dem.

Wetin dem dey use am for?

Store relational data

Schemas, SQL, and roles. mysqld.exe na different engine on top different port by default.

Windows service

The installer fit register postgresql-x64-##. Dat service no be MySQL80.

Optional pgAdmin

Checkbox for the EDB installer. If you uncheck am, e go still install the server.

Na who e dey for?

  • Developers wey their stack na Postgres
  • Students wey their README assume port 5432
  • Anybody wey install MySQL come dey wonder why psql no dey

Current status

PostgreSQL (1996) na current database server from PostgreSQL Global Development Group. The vendor still dey point Windows users go https://www.postgresql.org/download/windows/.

How old e be?

PostgreSQL root trace go back to the 1990s. Current Windows installers dey ship recent 16/17-line servers. E be the same generation as MySQL and older pass MongoDB Compass. 7.x Cygwin-era note na ancient history.

Versions

Major channels first. Exact build numbers no dey all verified here.

Current Windows installer

System requirements

Values dey follow wetin di publisher release publicly. Workload still dey change di real need.

Minimum

Minimum system requirements
Operating system Current 64-bit Windows 10 or Windows 11 release, according to current PostgreSQL Windows notes
RAM 1 GB class dey tight. Official docs treat RAM as server tuning matter

Resource profile

CPU demand
Dey follow wetin you open inside di app
RAM demand
Dey follow documents, tabs, or libraries

Installed processes

Dese executables belong to dis product when e dey installed.

Installed processes
postgres.exe PostgreSQL server process

Startup components

The installer fit start the service for boot. Dat one na postgres.exe, no be pgAdmin.

File locations

Common PostgreSQL locations
Typical install C:\Program Files\PostgreSQL\<version>\

File formats

SQLdumpcustom format

Common wahala dem

Port 5432 already dey use

Postgres service wey remain or Docker container fit don thief am. MySQL default 3306 na different port.

People dey uninstall pgAdmin think say the server don go

pgAdmin4.exe na the GUI. The service and postgres.exe fit stay.

How to get unstuck

Install from postgresql.org/download/windows

The project point hand go the EDB installer. Any random Postgres zip na rubbish.

Services.msc: postgresql-x64-##

Na this engine be dat. MySQL80 na the other vendor.

psql -U postgres or pgAdmin to test login

Workbench no go speak Postgres as e first protocol.

Alternatives

MySQL if the stack na MySQL. SQLite for file-based DB. DBeaver or pgAdmin for GUI.

Official help and downloads

Start with di vendor. Random exe sites no be support channel.

Official contacts
Download www.postgresql.org/download/windows/ Official installer or vendor page
Help www.postgresql.org/docs/ Vendor support
Official site www.postgresql.org/ Start here, no be random exe host
Windows installers www.enterprisedb.com/downloads/postgres-postgresql-downloads EDB installer wey the project point to

Related hardware

The server want RAM for shared_buffers and disk for the data directory. GPU no consign am.

Technical details

Technical details

Vendor version numbers dey change. Dis article no pin down any build.

Sources and verification

Recorded source label: August 2026. Dis label no establish independent verification. How we dey do research.

Dis article make sense to you?

Yes or no dey enough. Choose reason if you want, or add short note.

Dis article make sense to you?