Can I install PostgreSQL entirely offline?

Yes. Use the full Windows installer (18.3-3), transfer it to the target PC, run the setup offline, and skip Stack Builder.

How can I verify the installer integrity offline?

Before going offline, download the installer and verify its digital signature (Properties → Digital Signatures) or checksum while still online.

Administrator privileges are recommended to install services and write to Program Files.

Some extensions from Stack Builder require internet. Install them later when online, or ship the required MSI packages in advance if available.

Yes. Use the 64-bit installer for 64-bit Windows (recommended). Match ODBC driver architecture to your client app.

On an online machine, download the 64-bit installer above.
Copy the postgresql-18.3-3-windows-x64.exe to a USB drive or secure share.
Move the file to the offline Windows PC.
Run the installer as Administrator, select your data directory, and set a strong postgres password.
Keep the default port 5432 unless it’s already used.
Skip Stack Builder and any components that require internet. You can add extras later.
Finish setup. Open Command Prompt and run psql --version. If not found, fix PATH issues.

While still online, verify the installer before moving it offline:

Right‑click the .exe → Properties → Digital Signatures tab. Verify the signer is trusted.
Optionally compute a checksum (e.g., SHA‑256) and store it with the file.

After transfer, re‑check the signature on the offline PC to ensure the file wasn’t altered.

Core PostgreSQL server, command‑line tools, Windows service registration.

Optional extensions via Stack Builder and some client tools. Install later when online.

psqlODBC x64/x86 can be installed separately. See the ODBC guide.