search

lorint / AdventureWorks-for-Postgres

Set up the AdventureWorks sample database for use with Postgres
MIT License
369 stars 185 forks source link

Docker install fails #5

Open heimir-sverrisson opened 7 years ago

heimir-sverrisson commented 7 years ago

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 commented 5 years ago

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 commented 4 years ago

@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 commented 4 years ago

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

pedrojunqueira commented 4 years ago

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