cancel
Showing results for 
Search instead for 
Did you mean: 

[Webinar] Installing Postgres on Windows

Highlighted
Community Manager

[Webinar] Installing Postgres on Windows

 
The Pulse of Postgres Slim.png
 
 
 
 
Coming Soon: Installing Postgres on Windows
 
With Marc Linster and Sandeep Thakkar

Date: October 9th, 2019
Time: 10.00am ET | 16.00 CET | 15.00 GMT

Join Postgres experts, Marc Linster and Sandeep Thakkar, as they provide a step-by-step guide for installing PostgreSQL and EDB Postgres Advanced Server on Windows.

Highlights include:

  • How to get the Postgres Windows installer
  • How to install it and the various modes of installation
  • How to patch the installation

This webinar is the third of a short series that explores Postgres installation on Linux (September 11, 2019 - recording available), Containers (September 25, 2019 - recording available), and Windows (October 9, 2019).

 
 
Interested in the webinar but not able to attend the live event? Register anyway and we’ll send you the recording shortly after the webinar.

About the Speakers: 
Image_Mark_Circle.png
Marc Linster, SVP, Product Development & Support
Sandeep Thakkar Headshot.png
Sandeep Thakkar, Senior Configuration Manager
1 REPLY 1
Community Manager

Re: [Webinar] Installing Postgres on Windows

Follow Up: [WEBINAR]  Installing Postgres on Windows

 

We hope you had a chance to join us for the webinar!!   If not, don't worry! 

You can view the webinar via the link below. Be sure to check out the Q & A Session too!

 

VIEW THE WEBINAR:  Installing Postgres on Windows

 

Q & A SESSION:

__________________

 

Question:

Can you update components on Advanced PSQl separately - say for example to upgrade just pgAdmin?

 

Answer:

If pgAdmin is installed through the Postgres installer then it can be upgraded only through the same installer that bundles newer pgAdmin version. Otherwise, the stand alone pgAdmin installer can always be used.

_____

 

Question:

Can you explain a little more what the parameters - edb 33, edb 66, edb 100 mean?

 

Answer:

Please refer to page 20 of EDB_Postgres_Advanced_Server_Installation_Guide_Windows_v11.pdf for more details.

_____

 

Question:

Are there performance differences between windows and linux hosts?

 

Answer:

There is no generic way to answer that question - this depends on the workload. Linux does tend to be the preferred platform for demanding workloads.

 

_____

 

Question:

The current EDB Postges 12 did not seem to have an option for PostGIS in stack builder. Will this be added soon or did I miss something?

 

Answer:

Releasing soon! Though EDB doesn’t build community PostGIS on Windows.

 

_____

 

Question:

Is there a performance difference on 64 bit windows versus 32 bit windows?

 

Answer:

Yes, absolutely. Windows 64 should be your platform of choice.

 

_____

 

Question:

Does Postgres support Windows Active Directory users or groups?

 

Answer: 

Yes

_____

 

Question:

When the windows installer breaks is there a way to install or upgrade manually?

 

Answer:

It depends on what stage of installation it breaks. Ideally, we want you to report the installation failure so that we can help you fix it.

 

_____

 

Question:

 How is the connection pooling handled in Windows?

 

Answer:

The application has to handle the connection pooling.

 

_____

 

Question:

Is there any plan to have the StackBuilder use an offline folder where we can put the patches and have it manage the updates that way?

 

Answer:

It’s possible to do that with the current stackbuilder. Please check the -a option to the stackbuilder tool.

 

_____

 

Question:

How do you do a backup or a dump of the EDB database and reimport the dump?

 

Answer:

The same way you do it in open source PostgreSQL.

 

_____

 

Question:

Several Windows Anti-Virus blocks access to the Temp directory, so there is no log and installations always fail.  Is there another way to install without the reliance on that location?

 

Answer:

Installer uses %TEMP% environment variable. You can set the new value on the command prompt as set TEMP=<custom_location> and run the installer from the same prompt. But make sure the custom location is also secure and not world-writable.

 

_____