tennis-crystal-ball
tennis-crystal-ball copied to clipboard
Docker image with PostgreSQL database pre-populated with ATP tennis data
Docker image mcekovic/uts-database with PostgreSQL database pre-populated with ATP tennis data as of season 2020:
- Install Docker
- Ensure PostgreSQL port 5432 is NOT open on your machine (i.e. PostgreSQL is not running if eventually installed)
- Run UTS database Docker image in a container:
docker run -p 5432:5432 -d --name uts-database mcekovic/uts-database
(this will take a while to download the image with data) - Enter PostgreSQL client command line tool:
docker exec -it uts-database psql -U tcb
- Execute SQL commands, like:
SELECT goat_rank, name, country_id, goat_points FROM player_v ORDER BY goat_points DESC NULLS LAST LIMIT 20;
- Next time you want Docker container with UTS database running type:
docker start uts-database
- If you want Docker container with UTS database to autostart when you start Docker Desktop/Daemon, add
--restart always
to thedocker run ...
command above - To refer to the UTS database Docker images created at the end of particular season use image URLs with following tags:
- mcekovic/uts-database:asof2020
- mcekovic/uts-database:asof2019
Refreshed with 2020 data.
"Ensure PostgreSQL port 5432 is NOT open on your machine (i.e. PostgreSQL is not running if eventually installed)"
How can I check this?
Please check if PostgreSQL service is running or not. On Windows, check 'Services' panel. On Linux, check 'systemctl status postgresql'.
On Wed, Jun 29, 2022 at 2:35 AM philkim72 @.***> wrote:
"Ensure PostgreSQL port 5432 is NOT open on your machine (i.e. PostgreSQL is not running if eventually installed)"
How can I check this?
— Reply to this email directly, view it on GitHub https://github.com/mcekovic/tennis-crystal-ball/issues/337#issuecomment-1169414970, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPUVTEFRNYTVE6FZ4RMZC3VROK6NANCNFSM4KDDY2HQ . You are receiving this because you authored the thread.Message ID: @.***>
Hello @mcekovic
Nice work with the database. managed to get it up and running.
When will it be updated with the latest statistics?
Thanks /Mike