apt repository atalia.postgresql.org/morgue should be replaced by apt-archive.postgresql.org

[ferry]

apt repository atalia.postgresql.org/morgue is gone: https://www.postgresql.org/about/news/2024/

https://atalia.postgresql.org/morgue replaced by htps:/apt-archive.postgresql.org/pub/repos/apt/pool/main

[stegben]

I got 403 while accessing https://apt-archive.postgresql.org/pub/repos/apt/pool/main
Is there any alternatives?

[ferry]

you have to add /index.html to see the content of the dirs on this repository, for example:

https://apt-archive.postgresql.org/pub/repos/apt/pool/main/b/barman/index.html

[stegben]

Thanks lol, I feel so dumb now...

[stegben]

@ferry I can download the deb file through browser (Chrome 81.0) but failed to download via wget when building docker image. What am I missing?

I was building the image using this Dockerfile, what I did was replacing these lines into:

RUN install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/repmgr-common_4.0.6-2.pgdg+1_all.deb" 
RUN install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/postgresql-$PG_MAJOR-repmgr_4.0.6-2.pgdg+1_amd64.deb" 

After modifying, I ran:
docker build -f ./src/Postgres-latest.Dockerfile -t postgres:new1 ./src
What I got is:

# ...previos steps were success
Step 5/55 : RUN install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/repmgr-common_4.0.6-2.pgdg+1_all.deb"
 ---> Running in 6c973dc935c8
--2020-04-29 06:47:47--  https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/repmgr-common_4.0.6-2.pgdg+1_all.deb
Resolving apt-archive.postgresql.org (apt-archive.postgresql.org)... 13.227.74.21, 13.227.74.63, 13.227.74.35, ...
Connecting to apt-archive.postgresql.org (apt-archive.postgresql.org)|13.227.74.21|:443... connected.
HTTP request sent, awaiting response... 403 Forbidden
2020-04-29 06:47:53 ERROR 403: Forbidden.

The command '/bin/sh -c install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/repmgr-common_4.0.6-2.pgdg+1_all.deb"' returned a non-zero code: 8

[ferry]

it is the + character that causes your problem. it should be replaced by %2B, thus:

RUN install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/repmgr-common_4.0.6-2.pgdg%2B1_all.deb"
RUN install_deb_pkg "https://apt-archive.postgresql.org/pub/repos/apt/pool/main/r/repmgr/postgresql-$PG_MAJOR-repmgr_4.0.6-2.pgdg%2B1_amd64.deb"

[stegben]

Thanks a lot! It works. You saved my day.

[adgeese]

Upstream is working when:

echo "Change Upstream.."
fgrep -iR "install_deb_pkg" -lz | xargs sed -i 's/http:\/\/atalia\.postgresql\.org\/morgue\//https:\/\/apt-archive.postgresql.org\/pub\/repos\/apt\/pool\/main\//g'
echo "Change + to %2B in the URL to stop Forbidden"
fgrep -iR "4.0.6-2.pgdg+1" -lz | xargs sed -i 's/pgdg+1/pgdg%2B1/g'

[bergner]

Besides the issues already mentioned here there are other problems as well.

• Some pgdg80+1 packages don't exist on apt-archive. In my tests I was referencing pgdg+1 instead.
• There are some dpkg dependency problems.

A suggested merge request which uses apt-archive and also fixes the above problems is available at #266. If you just want to try it (if the merge request isn't merged) you can git clone my fork https://github.com/bergner/PostDock. docker-compose build works for all variants.

[ruslankrivoshein]

Now you should

RUN install_deb_pkg "atalia.postgresql.org/morgue/repmgr-common_5.0.0-4.pgdg+1_all.deb"
RUN install_deb_pkg "atalia.postgresql.org/morgue/postgresql-$PG_MAJOR-repmgr_5.0.0-4.pgdg+1_amd64.deb"

UPD:
There is a lot of errors with links to packages...