Offical Packages
Official releases of Npgsql are always available on nuget.org. This is the recommended way to use Npgsql.
We occasionally publish previews to nuget.org as well - these are generally quite safe for use, and can help us find issues before official packages are released.
Daily Builds
In additional to the official releases, we automatically publish CI packages for every build. You can use these to test new features or bug fixes that haven't been released yet. Two CI nuget feeds are available:
- The patch feed contains CI packages for the next hotfix/patch version. These packages are generally very stable and safe.
- The vNext feed contains CI packages for the next minor or major versions. These are less stable and should be tested with care.
Older, unsupported installation methods
Windows MSI Installer
Installation Distribution channels NPM Registry. We publish two modules to npm: swagger-ui and swagger-ui-dist. Swagger-ui is meant for consumption by JavaScript web projects that include module bundlers, such as Webpack, Browserify, and Rollup.
Windows Powershell Install Nupkg
- NB: With many very system dependent pkgs, unpkg shouldn't be used, because it doesn't do any system related stuff, on purpose. But for simple applications (and even ones that just install.
- To use or install package manually, go to Tools - Options - NuGet Package Manager - Package Sources. Click the Add button, choose the Source, and don't forget to click ' Update ' as it will update the folder location for your packages, edit your desired Name of your package source if you want.
If you need to use Npgsql as a database provider for PowerBI, Excel or other similar systems, you need to install it into the Windows Global Assembly Cache (GAC), and do some special configuration. Npgsql versions prior to 5.0.0 provided a Windows installer (MSI) which does installation for you, and which are still usable and maintained with critical bug fixes. Do not use the Windows MSI installer unless you're sure that your program requires GAC installation - this method is otherwise highly discouraged.
The Npgsql Windows MSI installer for Npgsql 4.1.x can be found on our Github releases page: it will install Npgsql (and optionally the Entity Framework providers) into your GAC and add Npgsql's DbProviderFactory into your
machine.config
file. Some additional assemblies which are Npgsql dependencies will be installed into the GAC as well (e.g. System.Threading.Tasks.Extensions.dll
).Visual Studio Integration
![Install a nupkg Install a nupkg](https://inotgo.com/imagesLocal/202108/03/20210803023810018s_3.png.jpg)
Older versions of Npgsql came with a Visual Studio extension (VSIX) which integrated PostgreSQL access into Visual Studio. The extension allowed connecting to PostgreSQL from within Visual Studio's Server Explorer, creating an Entity Framework 6 model from an existing database, etc. The extension had various limitations and known issues, mainly because of problems with Visual Studio's extensibility around database.
Use of the extension is no longer recommended. However, if you're like to give it a try, it can be installed directly from the Visual Studio Marketplace page.
DbProviderFactory in .NET Framework
On .NET Framework, you can register Npgsql's
DbProviderFactory
in your applications App.Config
(or Web.Config
), allowing you to use general, provider-independent ADO.NET types in your application (e.g. DbConnection
instead of NpgsqlConnection
) - see this tutorial. To do this, add the following to your App.config
:Interactive installer by EDB
Download the installer certified by EDB for all supported PostgreSQL versions.
![Unpkg Unpkg](/uploads/1/1/7/8/117887836/570532082.png)
This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developingyour databases, and StackBuilder; a package manager that can be used to download and installadditional PostgreSQL tools and drivers. Stackbuilder includes management,integration, migration, replication, geospatial, connectors and other tools.
This installer can run in graphical or silent install modes.
The installer is designed to be a straightforward, fast way to get up and running withPostgreSQL on Windows.
Install Nupkg Windows
Advanced users can also download azip archiveof the binaries, without the installer.This download is intended for users who wish to include PostgreSQL as part of another application installer.
Platform support
The installers are tested by EDB on the following platforms. They can generally be expected to run on other comparable versions:
Windows Install Nupkg File
PostgreSQL Version | 64 Bit Windows Platforms | 32 Bit Windows Platforms |
---|---|---|
13 | 2019, 2016 | |
12 | 2019, 2016, 2012 R2 | |
11 | 2019, 2016, 2012 R2 | |
10 | 2016, 2012 R2 & R1, 7, 8, 10 | 2008 R1, 7, 8, 10 |
9.6 | 2012 R2 & R1, 2008 R2, 7, 8, 10 | 2008 R1, 7, 8, 10 |