EDB Language Pack for Windows Discontinued: Configuring Python Support

[anthonydb]

Unfortunately, as of PostgreSQL 17, the Windows download from EDB described on page 5 of Chapter 1 no longer includes the Language Pack that had been part of the Stack Builder utility.

Instead, to configure Python for the exercise that uses a Python function in Chapter 17, please follow these revised steps:

1. PostgreSQL 17 for Windows currently requires Python 3.12.6. Download the official installer at https://www.python.org/ftp/python/3.12.6/python-3.12.6-amd64.exe
2. Performing the custom installation and choose a directoy that's easy to remember. For example, C:\Python
3. Next, follow the directions on Page 6 of Chapter 1 to add that directory to the PATH and PYTHONHOME variables under System Variables Instead of adding the directory shown in the book, add the directory where you installed Python
4. Restart your PC for the changes to take effect.

You now should be able to create the PL/Python extension in a database by running:

CREATE EXTENSION plpython3u;

Note

You can find additional information in the directory on your PC where PostgreSQL is installed, typically C:\Program File\PostgreSQL\17\doc\installation-notes.html

[rafissif]

Thank you so much, sir...

[EmunahLife5785]

Thank you for taking the time post this update!