Setting Up Postgres 17 Database Along with pgAdmin

In this edition of the newsletter, we cover the step-by-step process for setting up the latest Postgres (version 17) on Windows. While the steps focus on Windows, they can be adapted for Mac. Additionally, we explore how to confirm the installation and manage the Postgres service effectively.

Objectives of This Lesson

• Download and install Postgres 17.
• Configure pgAdmin for database interaction.
• Verify the installation and manage the Postgres service.
• Understand how to manage Postgres on Windows or Mac.

Practice Datasets:

You can download the datasets from the following GitHub link: GitHub Datasets

Step 1: Downloading Postgres 17

• Open your browser and search for "Postgres Database Downloads."
• Navigate to the official downloads page and select your operating system (Windows or Mac).
• For this guide, download the Windows installer for Postgres 17.2.
• If you are using Mac, choose the Mac installer.
• Wait for the .exe (Windows) or package file (Mac) to fully download.

Step 2: Installing Postgres

1. Launch the Installer:

Double-click the downloaded file to start the installation.

2. Choose Installation Preferences:

• Select the default installation location unless you need to customize it.
• Deselect unnecessary components like Stack Builder to simplify the setup.

3. Ensure the Following Components are Selected:

• PostgreSQL Server: The database engine.
• pgAdmin 4: The IDE for database interaction.
• Command Line Tools: Useful for advanced database scripting.

4. Set the Superuser Password:

• Enter and confirm a password for the Postgres superuser account.
• Make sure to remember this password for future use.

5. Configure Port Number:

• Use the default Postgres port: 5432.

6. Complete the Installation:

• Proceed through the remaining prompts, and wait for the installation to finish.

Step 3: Verifying Postgres Installation

1. Confirm Service Status:

• Open Task Manager > Services tab.
• Look for the Postgres service listed under "P."
• Ensure the status is Running.

2. Managing the Service:

• Open the Task Manager and go to the Services tab.
• Locate the Postgres service (sorted alphabetically) and right-click on it.
• Choose an action such as Stop, Restart, or Modify Properties.
• To configure the startup type, select Properties from the right-click menu.
• In the Properties window, you can select Automatic to ensure Postgres starts automatically when the system boots, or select Manual if you prefer to manually start Postgres after each reboot.
• Apply the changes and exit.

Step 4: Using pgAdmin to Connect to Postgres

Once the installation is verified, launch pgAdmin. This IDE allows you to:

• Manage databases.
• Execute SQL queries.
• Visualize schema and tables for easy database management.

Tips for Mac Users

If you face any issues during installation on Mac, feel free to reach out for support. We are here to help you troubleshoot and get started.

Why This Matters

Postgres is a powerful relational database management system (RDBMS) that pairs seamlessly with Python and Pandas for data analysis. Setting it up correctly ensures smooth integration for workflows involving large-scale data manipulation, storage, and retrieval.

What’s Next?

In the next lecture, we will explore Connecting to a PostgreSQL Database using pgAdmin. pgAdmin is a powerful graphical user interface (GUI) tool that allows you to interact with your PostgreSQL database easily.

Click ?? to Enroll in the Python for Beginners: Learn Python with Hands-on Projects. It only costs $10 and you can reach out to us for $10 Coupon.

Conclusion

In this lesson, we covered the setup of Postgres 17 and pgAdmin on Windows, including the installation, configuration, and verification processes. This setup is a crucial first step in integrating Pandas with relational databases for seamless data workflows.

Next, we’ll explore how to connect Pandas to Postgres and perform operations like reading and writing data. Stay tuned as we continue to bridge the gap between data analysis and database management!

Call to Action:

? Follow Siva Kalyan Geddada and Abhinav Sai Penmetsa Abhinav Sai Penmetsa for more insightful articles on data integration and analytics!

?? Share this newsletter with your network to help them set up and use Postgres effectively.

?? Questions? Drop a comment or reach out directly—we’re here to help!

Let’s make database management and integration with Pandas effortless! ??