Docker install fails

[heimir-sverrisson]

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.

[daddydrac]

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"

[pedrojunqueira]

@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

[pedrojunqueira]

I am having an issue. I am able to run the container but for some reason the tables created are empty...

[pedrojunqueira]

Adventureworks=# select * from person.person;
businessentityid | persontype | namestyle | title | firstname | middlename | lastname | suffix | emailpromotion | additionalcontactinfo | demographics | row
guid | modifieddate
------------------+------------+-----------+-------+-----------+------------+----------+--------+----------------+-----------------------+--------------+----
-----+--------------
(0 rows)