droher/boxball

Row-based Postgres not populating

Closed this issue · 3 comments

Describe the bug
Waited well over 90 minutes for the population of the row-based postgres docker image, and it seems like the data isn't populating in the postgres database. The data seems to exist in the boxball directory, but it's not showing when I try to access it in the database.

I installed the sqlite image to see if it was all the images, but it worked as expected, so it might just be that particular image that has a problem

To Reproduce
Steps to reproduce the behavior:

  1. Follow instructions to start up row-based postgres docker image
  2. Leave up for 6 hours, and the data is not populated

Expected behavior
Data should populate in around 90 minutes

Screenshots
image

image

Desktop:

  • OS: Fedora 39 (Workstation) x86_64
  • Kernel: 6.5.9-300.fc39.x86_64
  • Docker: 24.0.7

I have fixed it, it was on my end.

droher commented

What was the fix, in case others have a similar problem?

I didn't check the schema list with \dn

image

I'm a student and new to postgres and thought that \dt would list all tables in the connected database in postgres. It only lists tables in public schemas, which is why I thought it was not populating.

Screenshot from 2023-12-09 15-16-17

This could've been discovered with a StackOverflow post, but instead I rush to make an issue. 🤦