AdventureWorks-for-Postgres
AdventureWorks-for-Postgres copied to clipboard
lorint
Docker install fails
Thank you for bringing this great data set to Postgres!
I created a docker image using your instructions, but it failed.
The fix was rather simple and is in the pull request I just created.
The docker image is also publicly available on Docker hub as:
heimirthor/adventureworksforpostgres_db so anybody can pull it down
with something like:
docker pull heimirthor/adventureworksforpostgres_db
if they don't want to do any manual building.
I got it to work, but how do I connect to the Docker instance?
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
eb93aac20c5d postgressql_db "docker-entrypoint.s…" 56 seconds ago Up 55 seconds 5432/tcp, 0.0.0.0:5438->5438/tcp postgressql_db_1_d078b09562ef
I did try:
psql \c "Adventureworks"
And all I got was:
psql: FATAL: Peer authentication failed for user "Adventureworks"
@joehoeller did you try without "" quotes?
You can try to connect from a client tool just use local host and the port bound to your container. If you already have a local installation of postgres use other port then 5432, say use 5437
I am having an issue. I am able to run the container but for some reason the tables created are empty...
Adventureworks=# select * from person.person; businessentityid | persontype | namestyle | title | firstname | middlename | lastname | suffix | emailpromotion | additionalcontactinfo | demographics | row guid | modifieddate ------------------+------------+-----------+-------+-----------+------------+----------+--------+----------------+-----------------------+--------------+---- -----+-------------- (0 rows)