Victoria's Notes

Installing PostgreSQL on Windows 11

I have a project that needs to get out of the world of volatile CSV files and into a data source that Tableau can connect to. To that end, I installed PostgreSQL on my computer. That's the easy part-- the hard stuff involving Python, pandas, and setting up a professional environment comes later.

For now, the steps for installing PostgreSQL on Windows 11:

  1. Go to postgresql.org and select Download.
  2. Choose Windows.
  3. Select the Download the installer link.
  4. Select the latest version for Windows x86-64.
  5. Open the installation file and follow the prompts.
    • Folders: Go with the default folders for installation and data.
    • Components: Accept all components (PostgreSQL Server, pgAdmin 4, Stack Builder, and Command Line Tools).
    • Password: Enter a password for your admin user. Make sure it's easy to remember, or keep it in a password vault.
    • Port: Leave the port as the standard 5432.
    • Locale: Leave as the default locale.
  6. You'll be prompted to launch Stack Builder to install more tools and drivers. Unless you know what you want or would like to explore what's available, go ahead and skip it.

#etl #postgresql