windows Archives - 2ndQuadrant

Posts

Webinar: PostgreSQL on Windows [Follow Up]

August 17, 2020/0 Comments/in 2ndQuadrant, Webinars /by Quratulain Ghazali

PostgreSQL is a powerful database and supports multiple operating systems. Windows is a first-class example of PostgreSQL supported platforms. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “PostgreSQL on Windows”. The session was hosted by Andrew Dunstan, Senior Developer & PostgreSQL Committer at 2ndQuadrant. The webinar covered the following topics: […]

Developing PostgreSQL for Windows, Part 3

March 24, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

Let’s wrap this up. In part 1 of this blog series, I explained the different Windows build targets supported by PostgreSQL. In part 2, I showed how to test patches for Windows compatibility and how to easily spin up a Windows environment for testing and simple development. Now, in this third and final part, we’ll […]

Developing PostgreSQL for Windows, Part 2

March 4, 2020/0 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your patch might work on Windows. (For simplicity, I’ll say “Unix” to mean Linux, BSD, macOS, and similar.) First, there are a few ways to check […]

Developing PostgreSQL for Windows, Part 1

January 29, 2020/3 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut

As a PostgreSQL developer, I occasionally need to make my code work on Windows. As I don’t normally use Windows and don’t have a permanent Windows installation around, this has always been a bit cumbersome. I have developed a few techniques to make this easier, and I figure they are worth sharing. And actually this […]

pg_sysdatetime: a simple cross-platform PostgreSQL extension

September 12, 2014/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

A while ago I wrote about compiling PostgreSQL extensions under Visual Studio – without having to recompile the whole PostgreSQL source tree. I just finished the pg_sysdatetime extension, which is mainly for Windows but also supports compilation with PGXS on *nix. It’s small enough that it serves as a useful example of how to support […]

Compiling PostgreSQL extensions with Visual Studio on Windows

January 11, 2014/47 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

I’ve seen a number of users struggling with building PostgreSQL extensions under Visual Studio, so I thought I’d see what’s involved in getting it working. The result is this tutorial, showing how to compile a simple extension with Visual Studio 2010 Express Edition. Requirements You will need a supported version of Visual Studio installed. These […]

Simplifying compilation of PostgreSQL on Windows

January 9, 2013/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

As part of some internal continuous integration and testing work, I’ve put together some scripts to simplify the compilation of PostgreSQL on Windows. PostgreSQL its self is pretty easy to compile on Windows. You download and install ActiveState Perl and Visual Studio or the Microsoft Windows SDK, unpack a PostgreSQL source tree, copy config_default.pl to […]

During installation, cluster initialisation fails with the message “No error” on Windows

November 19, 2012/4 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Today I ran into another strange issue with PostgreSQL installation on Windows. It turned out not to be a problem with the installer; instead it was a form of broken Windows installation that I hadn’t seen before, so I thought I’d write it up. The installer already contains checks for several kinds of broken Windows […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here

Posts

Webinar: PostgreSQL on Windows [Follow Up]

Developing PostgreSQL for Windows, Part 3

Developing PostgreSQL for Windows, Part 2

Developing PostgreSQL for Windows, Part 1

pg_sysdatetime: a simple cross-platform PostgreSQL extension

Compiling PostgreSQL extensions with Visual Studio on Windows

Simplifying compilation of PostgreSQL on Windows

During installation, cluster initialisation fails with the message “No error” on Windows

Support & Services

Products

Postgres Learning Center

About Us