I didn’t understand the below
“It didn't solve the purpose I was doing so, but some simple things to always remember while working with docker.” You are still having issues? Thanks, Regina From: Devendra Yadav [mailto:[email protected]] Sent: Wednesday, February 1, 2023 10:26 AM To: Regina Obe <[email protected]> Cc: PostGIS Users Discussion <[email protected]> Subject: Re: Postgis docker upgrade error That helped Thanks a lot Regina, much appreciated ☺️ It didn't solve the purpose I was doing so, but some simple things to always remember while working with docker. Regards Devendra On Wed, 1 Feb, 2023, 7:04 pm Regina Obe, <[email protected] <mailto:[email protected]> > wrote: Devendra sorry just realized I was getting your email because I’m an owner of postgis-users. So perhaps you aren’t registered or were unregistered because your email bounced at one point in time. You can reregister here - https://lists.osgeo.org/mailman/listinfo/postgis-users Regarding your question below: I just tested and ran into the same issue. That issue happens if when you setup your docker container, you didn’t specify a POSTGRES_USER. I think this is a bug either in instructions or the container script not defaulting to postgres if a POSTGRES_USER is not specified when docker run is set. Work around for that, you can specify at exec time as follows: docker exec -e POSTGRES_USER=postgres some-postgis update-postgis.sh Hope that helps, Regina From: Devendra Yadav [mailto:[email protected] <mailto:[email protected]> ] Sent: Wednesday, February 1, 2023 9:29 AM To: Regina Obe <[email protected] <mailto:[email protected]> > Cc: [email protected] <mailto:[email protected]> Subject: Re: Postgis docker upgrade error Thanks for confirming Regina I am able to connect via psql using postgres user I am using the image from here - https://registry.hub.docker.com/r/postgis/postgis/ And I am running the following command to upgrade postgis - docker exec some-postgis update-postgis.sh Regards, Devendra Yadav On Wed, 1 Feb, 2023, 6:20 pm Regina Obe, <[email protected] <mailto:[email protected]> > wrote: This came thru fine. 1) Which docker image are you using and how are you connecting to it? 2) What command are you using – exactly to connect via psql Can you connect by entering the docker container Sounds like you are using the root account instead of something psql -h localhost -p 5432 -U postgres Thanks, Regina From: postgis-users [mailto:[email protected] <mailto:[email protected]> ] On Behalf Of Devendra Yadav Sent: Wednesday, February 1, 2023 5:13 AM To: [email protected] <mailto:[email protected]> Subject: Re: Postgis docker upgrade error Why is it getting rejected even when I have subscribed? On Wed, 1 Feb, 2023, 2:11 pm , <[email protected] <mailto:[email protected]> > wrote: Your message has been rejected, probably because you are not subscribed to the mailing list and the list's policy is to prohibit non-members from posting to it. If you think that your messages are being rejected in error, contact the mailing list owner at [email protected] <mailto:[email protected]> . ---------- Forwarded message ---------- From: Devendra Yadav <[email protected] <mailto:[email protected]> > To: [email protected] <mailto:[email protected]> Cc: Bcc: Date: Wed, 1 Feb 2023 14:11:16 +0400 Subject: Postgis docker upgrade error Hello Experts, I am running a docker image of postgis (latest one) from docker hub. I am unable to proceed with postgis update. Could someone be able to assist with the error below - Updating PostGIS extensions 'template_postgis' to 3.3.2 PSL: error connection to server on socket "var/run/postgresql/s.PGSQL.5432" failed: FATAL: role "root" does not exist I tried passing th postgres use explicitly, didn't help. Regards Devendra Yadav
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
