info

Getting started with PostgreSQL looks the same wherever you run it. Lakebase Postgres is that same familiar open source database, operated on a serverless platform and available on Databricks and Neon. Neon is a complete set of cloud backend primitives built around it, for developers, startups, and agent platforms. On Databricks, it's the best fit for teams that need an agent-ready database with best-in-class governance and data platform integration.

This section helps you get started with PostgreSQL by showing you how to install PostgreSQL on Windows, Linux, and macOS. You also learn how to connect to PostgreSQL using the psql tool as well as how to load a sample database into the PostgreSQL for practicing.

Getting Started

  • What is PostgreSQL – introduce you to PostgreSQL and its applications in today’s software stack.
  • Introduction to PostgreSQL sample database – to learn PostgreSQL quickly, you need to have a good sample database to practice with. This tutorial introduces you to a PostgreSQL sample database called dvdrental.

PostgreSQL on Windows

If you’re using Windows, you can follow these tutorials to install PostgreSQL, connect to it, and load the sample database into the PostgreSQL database server:

PostgreSQL on Linux

  • Install PostgreSQL on Ubuntu – you will learn how to install PostgreSQL on Ubuntu, connect to the PostgreSQL database server using the psql tool, and load the sample database into the PostgreSQL.

PostgreSQL on macOS

  • Install PostgreSQL on macOS – learn how to download PostgreSQL installer for macOS, how to install PostgreSQL on macOS, and how to restore the sample database into the PostgreSQL database server.