# Circleci Migration Issues (Postgres) **URL:** \ **Category:** Build Environment\ **Created:** [August 3, 2018, 1:04pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043 "2018-08-03T13:04:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![vinaybol](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/vinaybol/32/18770_2.png) [@vinaybol](https://discuss.circleci.com/u/vinaybol)\ **Post date:** [August 3, 2018, 1:04pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/1 "2018-08-03T13:04:47Z")
Can you give me docker image with postgres 9.6 and port 5432 for python 3.6? I’m getting various errors while i’m trying to change the configuration according to the errors. The problem is psql is unable to find or connect to database. The default database url seems to have been changed from version 1 to 2, previously in 1.0 it was “postgres://ubuntu:@127.0.0.1:5432/circle\_test”. Now I’m using image: **circleci/postgres:9.6.5-alpine-ram** with database url “ **postgres://root@127.0.0.1:5433/circle\_test** ”(port seems to be 5433 for this image). Is this the proper url where “ **root** ” is username and “ **circle\_test** ” is database? or What are default username and database name for above image? Also I believe the port was hard coded somewhere in our application, so if you can give me a docker image for postgres 9.6 with port 5432 for python 3.6 and its default username and database name, it would be really helpful. Errors I got are: 1.)(Before) > ‘psql fatal role “circleci” not found.’ 2.)(Currently after some changes) > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”? I hope I made some sense. I can provide you with whatever the information you want or even yml config files if necessary. (“[https://circleci.com/docs/2.0/databases/#postgresql-database-testing-example](https://circleci.com/docs/2.0/databases/#postgresql-database-testing-example)”, followed this link but didn’t help). This has been pending since a month and has to be resolved soon. Please help. Thank You. ---
**Author:** ![halfer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/halfer/32/9083_2.png) [@halfer](https://discuss.circleci.com/u/halfer)\ **Post date:** [August 3, 2018, 1:19pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/2 "2018-08-03T13:19:19Z")
There are a number of examples in this forum - search for “postgres”. Something came up in the last week or so, I seem to recall. ---
**Author:** ![vinaybol](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/vinaybol/32/18770_2.png) [@vinaybol](https://discuss.circleci.com/u/vinaybol)\ **Post date:** [August 3, 2018, 1:35pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/3 "2018-08-03T13:35:04Z")
Please give link, I couldn’t find and hence had to post ---
**Author:** ![halfer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/halfer/32/9083_2.png) [@halfer](https://discuss.circleci.com/u/halfer)\ **Post date:** [August 3, 2018, 2:01pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/4 "2018-08-03T14:01:50Z")
It was [this one](https://discuss.circleci.com/t/nightmares-trying-to-get-postgresql-10-on-ubuntu-14-04/23769/4). Aside: when posting questions anywhere on the web, format them if you can - making them readable is a form of helping others to help you. In particular, double Enter creates a paragraph break, which you can use to separate a long post into sections. 1. If you have a list, use a real 2. ordered list 3. like so If you have an error, use a quote block: > psql: could not connect to server: No such file or directory The markup language here is called Markdown, and it is well worth learning. There’s emoji too. 😺 ---
**Author:** ![halfer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/halfer/32/9083_2.png) [@halfer](https://discuss.circleci.com/u/halfer)\ **Post date:** [August 3, 2018, 2:52pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/6 "2018-08-03T14:52:41Z")
OK, well, carry on searching. If you get stuck, drop the secondary container and install Postgres in your primary container - it’s just `apt-get` to grab it, and possibly a command to start it. That will at least get you running. Note that you are unlikely to be bumping into CircleCI-specific issues - these are just Linux issues, which can be debugged just as if you were experiencing them on a local machine. ---
**Author:** ![vinaybol](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/vinaybol/32/18770_2.png) [@vinaybol](https://discuss.circleci.com/u/vinaybol)\ **Post date:** [August 3, 2018, 2:58pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/7 "2018-08-03T14:58:39Z")
I hope you read the post . Also check the link attached. You can ask someone else to look into it if you can’t. I asked for some information, not to resolve the errors. ---
**Author:** ![halfer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/halfer/32/9083_2.png) [@halfer](https://discuss.circleci.com/u/halfer)\ **Post date:** [August 3, 2018, 4:13pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/8 "2018-08-03T16:13:25Z")
> I hope you read the post I did! 😼 > You can ask someone else to look into it if you can’t. I can, but I won’t - I am a volunteer here. Your level of entitlement is rather too high for me, so I will drop out of this thread. I have given you a suggestion on how to get Postgres working temporarily, and if your work is genuinely urgent, you would do well to take it. ---
**Author:** ![vinaybol](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/vinaybol/32/18770_2.png) [@vinaybol](https://discuss.circleci.com/u/vinaybol)\ **Post date:** [August 3, 2018, 4:20pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/9 "2018-08-03T16:20:40Z")
Thank You very much ---
**Author:** ![system](https://global.discourse-cdn.com/circleci/original/3X/5/1/511608acda8e85906e15909b57bd0a46c1dbe291.png) [@system](https://discuss.circleci.com/u/system)\ **Post date:** [November 1, 2018, 4:20pm UTC](https://discuss.circleci.com/t/circleci-migration-issues-postgres/24043/10 "2018-11-01T16:20:43Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.