droher / boxball

Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
Apache License 2.0
117 stars 16 forks source link

Row-based Postgres not populating #77

Closed ericlesslie closed 7 months ago

ericlesslie commented 7 months ago

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:

ericlesslie commented 7 months ago

I have fixed it, it was on my end.

droher commented 7 months ago

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

ericlesslie commented 7 months ago

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. 🤦