Skip to main content
Generic·How-To

Installing PostgreSQL Locally and Loading Data

A comprehensive guide to installing PostgreSQL on your local machine, configuring it, and loading your first dataset.

Uma Kiran Ramadugu
Uma Kiran Ramadugu·Sep 3, 2026·12 min read

1. Problem Statement

Learning SQL or working on data engineering projects requires a reliable, fully functional database. Relying entirely on cloud databases can be expensive, and using lightweight solutions like SQLite often lacks advanced features (like window functions, complex joins, or robust data types) needed for real-world scenarios. The problem is creating a powerful, industry-standard database environment right on your own computer.

2. Why this has been invented

PostgreSQL was invented as an open-source, object-relational database system with an emphasis on extensibility and standards compliance. It was designed to handle complex queries, massive datasets, and high concurrency without the high licensing costs associated with proprietary enterprise databases. Running it locally gives developers a sandbox to test schemas, write complex queries, and build applications without impacting a production environment.

3. Technical Details

Here is how to get PostgreSQL running on your machine and load some sample data into it.

Step 1: Install PostgreSQL

  • Windows/macOS: Download the installer from the official PostgreSQL downloads page. The graphical installer by EnterpriseDB is recommended.
  • Linux (Ubuntu/Debian): Run sudo apt update followed by sudo apt install postgresql postgresql-contrib.
  • During installation, you will be prompted to set a password for the default postgres superuser. Remember this password! You will need it to connect to the database.
  • The installer may also offer to install pgAdmin, a graphical interface for managing PostgreSQL. Ensure this is selected.

Step 2: Get the Sample Dataset

  • We will use a real-world dataset: the Olist Brazilian E-Commerce Public Dataset.
  • Go to Kaggle - Olist Dataset.
  • Download and extract the dataset to a known folder on your computer (e.g., /Downloads/olist_data/).
  • We will load the olist_customers_dataset.csv file as an example.

Step 3: Connect and Create the Database

  • Open pgAdmin (installed in Step 1).
  • In the left sidebar, expand the “Servers” node and enter your password.
  • Right-click on “Databases”, select Create > Database…
  • Name the new database retail_db and click Save.

Step 4: Create the Table Schema

  • In pgAdmin, expand the retail_db database.
  • Click the Query Tool icon in the top toolbar (it looks like a database with a lightning bolt).
  • Execute the following SQL to create the customers table:

CREATE TABLE customers ( customer_id VARCHAR(50) PRIMARY KEY, customer_unique_id VARCHAR(50), customer_zip_code_prefix INTEGER, customer_city VARCHAR(100), customer_state CHAR(2) );

Step 5: Load the Kaggle Data

      To load massive datasets quickly, we use PostgreSQL's built-in `\copy` command instead of slow INSERT statements.
      Open the **psql** tool (Command Line Interface for PostgreSQL) that was installed with your database.
      Connect to your database: `\c retail_db`
      Run the following command to load the CSV, making sure to replace the path with the actual location on your laptop:

    `\copy customers FROM '/path/to/olist_customers_dataset.csv' WITH (FORMAT csv, HEADER true);`

      To verify the data loaded successfully, return to pgAdmin's Query Tool and run: `SELECT COUNT(*) FROM customers;`

4. Summary

Installing PostgreSQL locally provides a robust environment for mastering SQL and testing data models. By setting up the server, creating the retail_db database, defining a precise table schema, and loading a real-world Kaggle dataset using the efficient \copy command, you have established a foundational skill required for any modern data engineering workflow.

Chat with us