- Download and install PostgreSQL: https://www.postgresql.org/download/
- To use
psql
, add the PostgreSQL installation directory (e.g.C:\Program Files\PostgreSQL\16\bin
) to your PATH (Windows: Windows+Start "environment variables" > Environment Variables > User variable = Path > Edit... > New > OK > OK > OK) - Restart your terminal.
- Verify Postgres is installed with
psql -U postgres
and the password you used in the installation wizard (\q
to quit).
- Download DBeaver.
- Create a new PostgreSQL connection.