Comments on: Introduction to Postgres Indexes https://frontendmasters.com/blog/intro-to-postgres-indexes/ Helping Your Journey to Senior Developer Fri, 05 Sep 2025 01:37:20 +0000 hourly 1 https://wordpress.org/?v=6.8.3 By: Adam Rackis https://frontendmasters.com/blog/intro-to-postgres-indexes/#comment-39514 Fri, 05 Sep 2025 01:37:20 +0000 https://frontendmasters.com/blog/?p=6843#comment-39514 In reply to Lance Patterson.

I’m really not sure. You’ll need to have Postgres running somewhere, and then connect to it. You could spin up a DB with Supabase and follow their instructions for connecting. Or you could just use Docker, which is what I did for this post

docker container run -e POSTGRES_USER=docker -e POSTGRES_PASSWORD=docker -p 5432:5432 -v /Users/arackis/Documents/pg-data:/var/lib/postgresql/data postgres:17.5-alpine3.22

just change the mounted volume path accordingly, for your machine, and then connect via psql

psql postgresql://docker:docker@localhost:5432

]]> By: Lance Patterson https://frontendmasters.com/blog/intro-to-postgres-indexes/#comment-39513 Fri, 05 Sep 2025 01:32:55 +0000 https://frontendmasters.com/blog/?p=6843#comment-39513 Hi Adam,

I am attempting to create and setup the database using your github sql scripting, but I am encountering difficulty in configuring using my DBeaver SQL Manager Studio which is linked to the Postgres local host.

At this time, my default connection is the default schema labeled public, and so I am unsure how to proceed further here:

]]>