-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.html
More file actions
146 lines (145 loc) · 14.7 KB
/
index.html
File metadata and controls
146 lines (145 loc) · 14.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
<title>PostgreSQL for Windows — Download, Install and Configure</title>
<meta name="description" content="Complete guide to download, install and configure PostgreSQL on Windows 10 and 11. Covers psql PATH fix, pgAdmin 4, Windows service, backups and more.">
<link rel="canonical" href="https://postgre-sql.github.io/">
<meta name="last-modified" content="2026-06-08">
<meta property="og:title" content="PostgreSQL for Windows — Download, Install and Configure">
<meta property="og:description" content="Complete guide to download, install and configure PostgreSQL on Windows 10 and 11. Covers psql PATH fix, pgAdmin 4, Windows service, backups and more.">
<meta property="og:type" content="article">
<meta property="og:url" content="https://postgre-sql.github.io/">
<meta property="og:image" content="https://postgre-sql.github.io/og-image.svg">
<meta name="twitter:card" content="summary_large_image">
<link rel="icon" href="/favicon.svg">
<link rel="stylesheet" href="/style.css">
</head>
<body>
<nav class="site-nav"><div class="wrap"><div class="nav-inner">
<a href="/index.html" class="nav-logo"><div class="nav-logo-mark">Pg</div><span class="nav-logo-name">PostgreSQL</span><span class="nav-logo-sub">for Windows</span></a>
<div class="nav-links">
<a href="/index.html" id="nl-home">Home</a>
<a href="/download-windows.html" id="nl-dl">Download</a>
<a href="/offline-installer.html" id="nl-off">Offline</a>
<a href="/configure-windows-service.html" id="nl-svc">Service</a>
<a href="/fix-path-issues.html" id="nl-path">PATH fix</a>
<a href="/pgadmin-windows.html" id="nl-pgadmin">pgAdmin</a>
<a href="/postgresql-windows-faq.html" id="nl-faq">FAQ</a>
</div>
<a href="/download-windows.html" class="nav-cta"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5" stroke-linecap="round" stroke-linejoin="round"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg> Download</a>
</div></div></nav>
<div class="page-hero"><div class="wrap">
<nav class="breadcrumb"><a href="/index.html">home</a> <span>/</span> <span>home</span></nav>
<span class="page-tag">Guide index</span>
<h1>PostgreSQL for Windows — <span>download, install & configure</span></h1>
<p class="page-lead">The complete guide for running PostgreSQL on Windows 10 and 11. Official installer, service setup, PATH fix, pgAdmin 4, backups and troubleshooting.</p>
</div></div>
<div class="wrap"><div class="content-layout">
<main><div class="section"><div class="callout callout-info"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.8" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="12" r="9"/><line x1="12" y1="8" x2="12" y2="12"/><line x1="12" y1="16" x2="12.01" y2="16"/></svg><span>This is an unofficial community guide for PostgreSQL on Windows. The official PostgreSQL website is <a href="https://www.postgresql.org" rel="noopener">postgresql.org</a>.</span></div></div>
<div class="section" aria-labelledby="what-h2"><span class="section-label">What is PostgreSQL?</span><h2 id="what-h2">PostgreSQL for Windows — the world's most advanced open source database</h2>
<p>PostgreSQL (also called Postgres) is a powerful, free and open-source relational database management system. It has been in active development for over 35 years and is used by companies of all sizes for web applications, analytics, data warehousing and more. On Windows it runs as a background service and includes pgAdmin 4, a full-featured GUI administration tool.</p>
<p>The official Windows installer from EDB (EnterpriseDB) bundles PostgreSQL Server, pgAdmin 4, the Stack Builder extension manager and command-line tools including <code>psql</code>, <code>pg_dump</code> and <code>pg_restore</code>.</p>
</div>
<div class="section" aria-labelledby="guides-h2"><span class="section-label">All guides</span><h2 id="guides-h2">PostgreSQL on Windows — complete guide index</h2>
<div class="tbl-wrap"><table><thead><tr><th>Guide</th><th>What it covers</th></tr></thead><tbody>
<tr><td><a href="/download-windows.html"><strong>Download & install</strong></a></td><td>Installer, setup wizard, post-install verification</td></tr>
<tr><td><a href="/offline-installer.html"><strong>Offline installer</strong></a></td><td>Install without internet, USB transfer</td></tr>
<tr><td><a href="/configure-windows-service.html"><strong>Windows service</strong></a></td><td>Auto-start, service account, recovery</td></tr>
<tr><td><a href="/fix-path-issues.html"><strong>Fix PATH / psql</strong></a></td><td>‘psql is not recognized’ fix</td></tr>
<tr><td><a href="/pgadmin-windows.html"><strong>pgAdmin 4</strong></a></td><td>GUI setup, first connection, tips</td></tr>
<tr><td><a href="/postgresql-config-windows.html"><strong>postgresql.conf</strong></a></td><td>Port, memory, logging configuration</td></tr>
<tr><td><a href="/postgresql-port-5432.html"><strong>Port 5432</strong></a></td><td>Change port, fix conflicts</td></tr>
<tr><td><a href="/postgresql-allow-remote-connections.html"><strong>Remote connections</strong></a></td><td>pg_hba.conf + firewall</td></tr>
<tr><td><a href="/postgresql-password-windows.html"><strong>Reset password</strong></a></td><td>Recover lost postgres password</td></tr>
<tr><td><a href="/psql-commands-windows.html"><strong>psql commands</strong></a></td><td>Essential commands cheat sheet</td></tr>
<tr><td><a href="/pg-dump-restore-windows.html"><strong>Backup & restore</strong></a></td><td>pg_dump, pg_restore on Windows</td></tr>
<tr><td><a href="/postgresql-not-starting-windows.html"><strong>Service not starting</strong></a></td><td>Fix startup failures</td></tr>
<tr><td><a href="/postgresql-python-windows.html"><strong>Python & psycopg2</strong></a></td><td>Connect Python to PostgreSQL</td></tr>
<tr><td><a href="/odbc-driver-x64-x86.html"><strong>ODBC driver</strong></a></td><td>psqlODBC x64 and x86 setup</td></tr>
<tr><td><a href="/migrate-from-older-versions.html"><strong>Migrate & upgrade</strong></a></td><td>pg_upgrade, dump/restore</td></tr>
<tr><td><a href="/install-postgresql-windows-server.html"><strong>Windows Server</strong></a></td><td>Server 2019 / 2022 setup</td></tr>
<tr><td><a href="/postgresql-uninstall-windows.html"><strong>Uninstall</strong></a></td><td>Complete removal guide</td></tr>
<tr><td><a href="/postgresql-windows-faq.html"><strong>FAQ</strong></a></td><td>Common questions answered</td></tr>
</tbody></table></div>
</div>
<div class="section" aria-labelledby="req-h2"><span class="section-label">System requirements</span><h2 id="req-h2">Minimum requirements for PostgreSQL on Windows</h2>
<div class="tbl-wrap"><table><thead><tr><th>Component</th><th>Minimum</th><th>Recommended</th></tr></thead><tbody>
<tr><td><strong>OS</strong></td><td>Windows 10 64-bit</td><td>Windows 11 or Server 2022</td></tr>
<tr><td><strong>RAM</strong></td><td>1 GB</td><td>4 GB or more</td></tr>
<tr><td><strong>Disk</strong></td><td>512 MB (binaries)</td><td>10+ GB for data</td></tr>
<tr><td><strong>Architecture</strong></td><td>x64 only</td><td>x64</td></tr>
</tbody></table></div>
</div>
<div class="section" aria-labelledby="faq-h2"><span class="section-label">Quick answers</span><h2 id="faq-h2">Common questions</h2><div class="faq">
<div class="faq-item"><details><summary>Is PostgreSQL free on Windows?</summary><div class="faq-ans">Yes. PostgreSQL is released under the PostgreSQL License, which is a permissive open-source license similar to BSD/MIT. It is free for personal and commercial use with no restrictions.</div></details></div>
<div class="faq-item"><details><summary>What is the latest version of PostgreSQL?</summary><div class="faq-ans">PostgreSQL 18.3 is the latest stable release (May 2026). For production use on Windows, always use the latest minor release of a supported major version. See the full <a href="/download-windows.html">download guide</a>.</div></details></div>
<div class="faq-item"><details><summary>Does PostgreSQL run as a Windows service?</summary><div class="faq-ans">Yes. The EDB installer registers PostgreSQL as a Windows service that starts automatically on boot. You can manage it via Services (services.msc) or the <code>pg_ctl</code> command. See the <a href="/configure-windows-service.html">Windows service guide</a>.</div></details></div>
</div></div>
<div class="cta-banner"><div><h2>Ready to install?</h2><p>Download the official PostgreSQL installer for Windows 10 and 11.</p></div><a href="/download-windows.html" class="btn-white"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2.5" stroke-linecap="round" stroke-linejoin="round"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg>Download guide</a></div>
<div style="margin-bottom:32px"><span class="section-label">Related guides</span><div class="rel-grid"><a href="/download-windows.html" class="rel-card"><div class="rel-title">Download & install →</div><div class="rel-sub">official installer</div></a><a href="/fix-path-issues.html" class="rel-card"><div class="rel-title">Fix PATH →</div><div class="rel-sub">psql not recognized</div></a><a href="/pgadmin-windows.html" class="rel-card"><div class="rel-title">pgAdmin 4 →</div><div class="rel-sub">GUI setup</div></a></div></div></main>
<aside class="content-sidebar"><div class="sb-card"><div class="version-badge-label">Latest stable</div><div class="version-badge-val">18.3</div><div class="version-badge-sub">Released May 2026</div></div><div class="sb-card"><div class="sb-card-title">Install & setup</div><ul class="sb-links"><li><a href="/download-windows.html">Download PostgreSQL</a></li><li><a href="/offline-installer.html">Offline installer</a></li><li><a href="/configure-windows-service.html">Windows service</a></li><li><a href="/fix-path-issues.html">Fix PATH / psql</a></li><li><a href="/pgadmin-windows.html">pgAdmin 4</a></li><li><a href="/install-postgresql-windows-server.html">Windows Server</a></li></ul></div><div class="sb-card"><div class="sb-card-title">Configuration</div><ul class="sb-links"><li><a href="/postgresql-config-windows.html">postgresql.conf</a></li><li><a href="/postgresql-port-5432.html">Port 5432</a></li><li><a href="/postgresql-allow-remote-connections.html">Remote connections</a></li><li><a href="/postgresql-password-windows.html">Reset password</a></li></ul></div><div class="sb-card"><div class="sb-card-title">Tools & help</div><ul class="sb-links"><li><a href="/psql-commands-windows.html">psql commands</a></li><li><a href="/pg-dump-restore-windows.html">Backup & restore</a></li><li><a href="/postgresql-python-windows.html">Python / psycopg2</a></li><li><a href="/odbc-driver-x64-x86.html">ODBC driver</a></li><li><a href="/postgresql-not-starting-windows.html">Service not starting</a></li><li><a href="/postgresql-uninstall-windows.html">Uninstall</a></li><li><a href="/postgresql-windows-faq.html">FAQ</a></li></ul></div></aside>
</div></div>
<footer class="site-footer"><div class="wrap">
<div class="footer-inner">
<div>
<div class="footer-logo"><div class="footer-logo-mark">Pg</div><span class="footer-logo-name">PostgreSQL for Windows</span></div>
<p class="footer-tagline">Unofficial Windows guide for PostgreSQL — download, install, configure, troubleshoot.</p>
</div>
<div>
<div class="footer-col-title">Install & setup</div>
<ul class="footer-links">
<li><a href="/download-windows.html">Download PostgreSQL</a></li>
<li><a href="/offline-installer.html">Offline installer</a></li>
<li><a href="/configure-windows-service.html">Windows service</a></li>
<li><a href="/fix-path-issues.html">Fix PATH / psql</a></li>
<li><a href="/pgadmin-windows.html">pgAdmin 4</a></li>
</ul>
</div>
<div>
<div class="footer-col-title">Configuration</div>
<ul class="footer-links">
<li><a href="/postgresql-config-windows.html">postgresql.conf</a></li>
<li><a href="/postgresql-port-5432.html">Port 5432</a></li>
<li><a href="/postgresql-allow-remote-connections.html">Remote connections</a></li>
<li><a href="/postgresql-password-windows.html">Reset password</a></li>
<li><a href="/install-postgresql-windows-server.html">Windows Server</a></li>
</ul>
</div>
<div>
<div class="footer-col-title">Tools & help</div>
<ul class="footer-links">
<li><a href="/psql-commands-windows.html">psql commands</a></li>
<li><a href="/pg-dump-restore-windows.html">Backup & restore</a></li>
<li><a href="/postgresql-not-starting-windows.html">Service not starting</a></li>
<li><a href="/postgresql-uninstall-windows.html">Uninstall</a></li>
<li><a href="/postgresql-windows-faq.html">FAQ</a></li>
</ul>
</div>
</div>
<div class="footer-bottom">
<p>Not affiliated with the PostgreSQL Global Development Group. Unofficial community guide.</p>
<p><strong>Affiliate disclosure:</strong> Download links may be partner links.</p>
</div>
</div></footer>
<div class="cookie-bar" id="cookieBar" style="display:none">
<p>We use Google Analytics for anonymous traffic data. <a href="/privacy.html">Privacy policy</a></p>
<div class="cookie-btns"><button class="cookie-accept" id="cookieAccept">Accept</button><button class="cookie-decline" id="cookieDecline">Decline</button></div>
</div>
<script async src="https://www.googletagmanager.com/gtag/js?id=G-MHLW57MR8Q"></script>
<script>
window.dataLayer=window.dataLayer||[];function gtag(){dataLayer.push(arguments)}
gtag('consent','default',{analytics_storage:'denied',ad_storage:'denied'});
gtag('js',new Date());gtag('config','G-MHLW57MR8Q',{anonymize_ip:true,send_page_view:false});
function grantGA(){gtag('consent','update',{analytics_storage:'granted'});gtag('event','page_view',{page_location:location.href,page_title:document.title})}
document.addEventListener('DOMContentLoaded',function(){
var bar=document.getElementById('cookieBar');
var c=localStorage.getItem('pg_consent');
if(!c){bar.style.display='flex'}else if(c==='1'){grantGA()}
document.getElementById('cookieAccept').addEventListener('click',function(){localStorage.setItem('pg_consent','1');grantGA();bar.style.display='none'});
document.getElementById('cookieDecline').addEventListener('click',function(){localStorage.setItem('pg_consent','0');bar.style.display='none'});
});
</script>
<script type="application/ld+json">{"@context":"https://schema.org","@type":"WebSite","name":"PostgreSQL for Windows","url":"https://postgre-sql.github.io/"}</script>
<script>var el=document.getElementById("nl-home");if(el)el.classList.add("active");</script>
</body></html>