-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathoffline-installer.html
More file actions
138 lines (137 loc) · 16.4 KB
/
Copy pathoffline-installer.html
File metadata and controls
138 lines (137 loc) · 16.4 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
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">
<title>PostgreSQL Offline Installer for Windows — Full Setup Without Internet</title>
<meta name="description" content="Install PostgreSQL on Windows 10/11 without internet. Download the full 64-bit installer once, transfer via USB, run offline. Step-by-step guide with verification.">
<link rel="canonical" href="https://postgre-sql.github.io/offline-installer.html">
<meta name="last-modified" content="2026-06-08">
<meta property="og:title" content="PostgreSQL Offline Installer for Windows — Full Setup Without Internet">
<meta property="og:description" content="Install PostgreSQL on Windows 10/11 without internet. Download the full 64-bit installer once, transfer via USB, run offline. Step-by-step guide with verification.">
<meta property="og:type" content="article">
<meta property="og:url" content="https://postgre-sql.github.io/offline-installer.html">
<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>offline-installer</span></nav>
<span class="page-tag">Offline install</span>
<h1>PostgreSQL offline installer for Windows — <span>full setup without internet</span></h1>
<p class="page-lead">The standard PostgreSQL installer is self-contained and works completely offline. Download it once on any connected machine, transfer via USB, and install on any Windows 10 or 11 PC.</p>
</div></div>
<div class="wrap"><div class="content-layout">
<main><div class="section" aria-labelledby="what-h2"><span class="section-label">What is the offline installer?</span><h2 id="what-h2">PostgreSQL offline installer for Windows — full setup without internet</h2>
<p>The PostgreSQL Windows installer from EDB is a self-contained executable that includes the server, pgAdmin 4 and all command-line tools. It does not require an internet connection to install — everything is bundled in the single <code>.exe</code> file. Once downloaded on any machine with internet access, you can transfer it via USB drive and install on any Windows 10 or 11 computer.</p>
<div class="callout callout-ok"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.8" stroke-linecap="round" stroke-linejoin="round"><polyline points="20 6 9 17 4 12"/></svg><span>The PostgreSQL installer is fully self-contained. There is no separate offline mode — the standard installer works offline by design.</span></div>
</div>
<div class="section" aria-labelledby="steps-h2"><span class="section-label">How to install offline</span><h2 id="steps-h2">Step-by-step offline installation</h2><ul class="steps">
<li class="step"><div class="step-n">1</div><div><h3>Download on a connected machine</h3><p>On any PC with internet access, <a href="/download-windows.html">download the installer</a>: <code>postgresql-18.3-3-windows-x64.exe</code> (~300 MB). The download page is <a href="https://www.postgresql.org/download/windows/" rel="noopener">postgresql.org/download/windows</a>.</p></div></li>
<li class="step"><div class="step-n">2</div><div><h3>Verify the download (optional but recommended)</h3><p>Check the SHA-256 hash against the value shown on the download page:</p>
<div class="term"><div class="term-bar"><div class="term-dot" style="background:#ff5f56"></div><div class="term-dot" style="background:#ffbd2e"></div><div class="term-dot" style="background:#27c93f"></div><span class="term-label">PowerShell</span></div><div class="term-body"><div><span class="t-p">PS></span> <span class="t-c">Get-FileHash postgresql-18.3-3-windows-x64.exe -Algorithm SHA256</span></div><div><span class="t-v">Algorithm Hash Path</span></div><div><span class="t-v">SHA256 A1B2C3D4E5F6... postgresql-18.3...</span></div></div></div>
</div></li>
<li class="step"><div class="step-n">3</div><div><h3>Transfer to the offline machine</h3><p>Copy the <code>.exe</code> file to a USB drive, network share or any other transfer method. No additional files are needed — everything is in the single executable.</p></div></li>
<li class="step"><div class="step-n">4</div><div><h3>Run the installer offline</h3><p>On the offline machine, right-click the <code>.exe</code> → <strong>Run as administrator</strong>. The installer runs completely without internet access. Follow the setup wizard normally.</p>
<div class="callout callout-warn"><svg viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.8" stroke-linecap="round" stroke-linejoin="round"><path d="M10.29 3.86L1.82 18a2 2 0 0 0 1.71 3h16.94a2 2 0 0 0 1.71-3L13.71 3.86a2 2 0 0 0-3.42 0z"/><line x1="12" y1="9" x2="12" y2="13"/><line x1="12" y1="17" x2="12.01" y2="17"/></svg><span>Windows SmartScreen may warn about an unrecognised app. Click <strong>More info</strong> → <strong>Run anyway</strong>. This is safe for the official PostgreSQL installer.</span></div>
</div></li>
<li class="step"><div class="step-n">5</div><div><h3>Skip Stack Builder</h3><p>At the end of the wizard, Stack Builder will offer to download additional components. On an offline machine, <strong>uncheck all Stack Builder options</strong> and click Finish. Stack Builder requires internet to download its packages.</p></div></li>
<li class="step"><div class="step-n">6</div><div><h3>Verify the installation</h3>
<div class="term"><div class="term-bar"><div class="term-dot" style="background:#ff5f56"></div><div class="term-dot" style="background:#ffbd2e"></div><div class="term-dot" style="background:#27c93f"></div><span class="term-label">cmd.exe — new window</span></div><div class="term-body"><div><span class="t-p">C:\></span> <span class="t-c">psql -U postgres -c "SELECT version();"</span></div><div><span class="t-o">Password for user postgres:</span></div><div><span class="t-ok">PostgreSQL 18.3, compiled by Visual C++ build 1940, 64-bit</span></div></div></div>
</div></li></ul></div>
<div class="section" aria-labelledby="what-works-h2"><span class="section-label">Offline capabilities</span><h2 id="what-works-h2">What works offline, what does not</h2>
<div class="tbl-wrap"><table><thead><tr><th>Feature</th><th>Works offline?</th></tr></thead><tbody>
<tr><td>PostgreSQL server</td><td class="td-ok">Yes — fully local</td></tr>
<tr><td>pgAdmin 4</td><td class="td-ok">Yes — fully local</td></tr>
<tr><td>psql, pg_dump, pg_restore</td><td class="td-ok">Yes — fully local</td></tr>
<tr><td>Stack Builder packages</td><td class="td-warn">No — requires internet download</td></tr>
<tr><td>pgAdmin map tiles</td><td class="td-warn">No — loaded from map servers</td></tr>
</tbody></table></div>
</div>
<div class="section" aria-labelledby="faq-h2"><span class="section-label">FAQ</span><h2 id="faq-h2">Offline installer questions</h2><div class="faq">
<div class="faq-item"><details><summary>Is there a separate offline installer download?</summary><div class="faq-ans">No. The standard PostgreSQL Windows installer from postgresql.org is self-contained and works offline by design. There is no separate offline version to download.</div></details></div>
<div class="faq-item"><details><summary>Can I install PostgreSQL offline on Windows Server?</summary><div class="faq-ans">Yes. The installer works the same way on Windows Server 2016, 2019 and 2022. Transfer the <code>.exe</code> via USB or network share and run it as Administrator. See also <a href="/install-postgresql-windows-server.html">Windows Server guide</a>.</div></details></div>
<div class="faq-item"><details><summary>How do I transfer the installer to an air-gapped machine?</summary><div class="faq-ans">Any file transfer method works: USB drive, DVD, internal network share, secure copy (SCP), or even a shared folder if the machines are on the same local network. No internet connection is required on the target machine.</div></details></div>
<div class="faq-item"><details><summary>Do I need Visual C++ redistributables separately?</summary><div class="faq-ans">No. The PostgreSQL EDB installer bundles the required Visual C++ redistributables. They are installed automatically as part of the setup process, even on a clean Windows installation.</div></details></div>
</div></div>
<div class="cta-banner"><div><h2>Ready to install?</h2><p>Follow the full download and setup guide.</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 guide →</div><div class="rel-sub">full setup steps</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="/configure-windows-service.html" class="rel-card"><div class="rel-title">Windows service →</div><div class="rel-sub">auto-start</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" class="cur">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":"HowTo","name":"Install PostgreSQL Offline on Windows","description":"How to install PostgreSQL on Windows without internet access.","step":[{"@type":"HowToStep","position":1,"name":"Download installer","text":"Download postgresql-18.3-3-windows-x64.exe on a connected machine"},{"@type":"HowToStep","position":2,"name":"Transfer to offline machine","text":"Copy to USB drive or network share"},{"@type":"HowToStep","position":3,"name":"Run as Administrator","text":"Right-click .exe and run as administrator"},{"@type":"HowToStep","position":4,"name":"Skip Stack Builder","text":"Uncheck Stack Builder options at the end of setup"},{"@type":"HowToStep","position":5,"name":"Verify","text":"psql -U postgres -c SELECT version();"}]}</script>
<script>var el=document.getElementById("nl-off");if(el)el.classList.add("active");</script>
</body></html>