Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unable to start postgresql on ubuntu runner. #11721

Open
3 of 15 tasks
yogeshmahajan-1903 opened this issue Mar 4, 2025 · 3 comments
Open
3 of 15 tasks

Unable to start postgresql on ubuntu runner. #11721

yogeshmahajan-1903 opened this issue Mar 4, 2025 · 3 comments
Assignees
@vidyasagarnimmagaddi
Labels
Area: Databases bug report OS: Ubuntu

Comments

@yogeshmahajan-1903
Copy link

yogeshmahajan-1903 commented Mar 4, 2025 •
edited
Loading

Description

Unable to start postgresql on ubuntu runner.

Here is yml file -

name: Tests on Postgres installation

on: [push, pull_request]

jobs:
  run-feature-tests-pg:
    strategy:
      fail-fast: false
      matrix:
        os: [ubuntu-22.04]
        pgver: [13, 14, 15, 16, 17]

    runs-on: ${{ matrix.os }}

    steps:
      - uses: actions/checkout@v4

      - name: Setup the PGDG APT repo on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
          wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

      - name: Install platform dependencies on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo apt update
          sudo apt install -y libpq-dev libffi-dev libssl-dev libkrb5-dev zlib1g-dev postgresql-${{ matrix.pgver }} postgresql-${{ matrix.pgver }}-pldebugger pgagent

      - name: Start PostgreSQL on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo ls -la /etc/postgresql/
          sudo ls -la /etc/postgresql/${{ matrix.pgver }}/main/
          sudo su - postgres -c "/usr/lib/postgresql/${{ matrix.pgver }}/bin/postgres -D /var/lib/postgresql/${{ matrix.pgver }}/main -c config_file=/etc/postgresql/${{ matrix.pgver }}/main/postgresql.conf &"

          until sudo runuser -l postgres -c "pg_isready -p 59${{ matrix.pgver }}" 2>/dev/null; do
            >&2 echo "Postgres is unavailable - sleeping for 2 seconds"
            sleep 2
          done

And output -

2025-03-04T08:41:25.6875168Z Current runner version: '2.322.0'
2025-03-04T08:41:25.6903300Z ##[group]Operating System
2025-03-04T08:41:25.6904088Z Ubuntu
2025-03-04T08:41:25.6904850Z 22.04.5
2025-03-04T08:41:25.6905440Z LTS
2025-03-04T08:41:25.6905950Z ##[endgroup]
2025-03-04T08:41:25.6906521Z ##[group]Runner Image
2025-03-04T08:41:25.6907176Z Image: ubuntu-22.04
2025-03-04T08:41:25.6907702Z Version: 20250223.1.0
2025-03-04T08:41:25.6908762Z Included Software: https://github.com/actions/runner-images/blob/ubuntu22/20250223.1/images/ubuntu/Ubuntu2204-Readme.md
2025-03-04T08:41:25.6910370Z Image Release: https://github.com/actions/runner-images/releases/tag/ubuntu22%2F20250223.1
2025-03-04T08:41:25.6911316Z ##[endgroup]
2025-03-04T08:41:25.6911915Z ##[group]Runner Image Provisioner
2025-03-04T08:41:25.6912541Z 2.0.422.1
2025-03-04T08:41:25.6912998Z ##[endgroup]
2025-03-04T08:41:25.6915297Z ##[group]GITHUB_TOKEN Permissions
2025-03-04T08:41:25.6917934Z Actions: write
2025-03-04T08:41:25.6918796Z Attestations: write
2025-03-04T08:41:25.6919642Z Checks: write
2025-03-04T08:41:25.6920257Z Contents: write
2025-03-04T08:41:25.6920801Z Deployments: write
2025-03-04T08:41:25.6921374Z Discussions: write
2025-03-04T08:41:25.6921883Z Issues: write
2025-03-04T08:41:25.6922402Z Metadata: read
2025-03-04T08:41:25.6922958Z Packages: write
2025-03-04T08:41:25.6923511Z Pages: write
2025-03-04T08:41:25.6923988Z PullRequests: write
2025-03-04T08:41:25.6924563Z RepositoryProjects: write
2025-03-04T08:41:25.6925175Z SecurityEvents: write
2025-03-04T08:41:25.6925721Z Statuses: write
2025-03-04T08:41:25.6926302Z ##[endgroup]
2025-03-04T08:41:25.6929607Z Secret source: Actions
2025-03-04T08:41:25.6930701Z Prepare workflow directory
2025-03-04T08:41:25.7238257Z Prepare all required actions
2025-03-04T08:41:25.7275595Z Getting action download info
2025-03-04T08:41:25.8614507Z Download action repository 'actions/checkout@v4' (SHA:11bd71901bbe5b1630ceea73d27597364c9af683)
2025-03-04T08:41:26.0376382Z Complete job name: run-feature-tests-pg (ubuntu-22.04, 16)
2025-03-04T08:41:26.1083824Z ##[group]Run actions/checkout@v4
2025-03-04T08:41:26.1084725Z with:
2025-03-04T08:41:26.1085198Z   repository: yogeshmahajan-1903/pgadmin4
2025-03-04T08:41:26.1085893Z   token: ***
2025-03-04T08:41:26.1086299Z   ssh-strict: true
2025-03-04T08:41:26.1086705Z   ssh-user: git
2025-03-04T08:41:26.1087188Z   persist-credentials: true
2025-03-04T08:41:26.1087651Z   clean: true
2025-03-04T08:41:26.1088070Z   sparse-checkout-cone-mode: true
2025-03-04T08:41:26.1088572Z   fetch-depth: 1
2025-03-04T08:41:26.1088975Z   fetch-tags: false
2025-03-04T08:41:26.1089660Z   show-progress: true
2025-03-04T08:41:26.1090228Z   lfs: false
2025-03-04T08:41:26.1090660Z   submodules: false
2025-03-04T08:41:26.1091085Z   set-safe-directory: true
2025-03-04T08:41:26.1091811Z ##[endgroup]
2025-03-04T08:41:26.3381795Z Syncing repository: yogeshmahajan-1903/pgadmin4
2025-03-04T08:41:26.3383720Z ##[group]Getting Git version info
2025-03-04T08:41:26.3384473Z Working directory is '/home/runner/work/pgadmin4/pgadmin4'
2025-03-04T08:41:26.3385461Z [command]/usr/bin/git version
2025-03-04T08:41:26.3492404Z git version 2.48.1
2025-03-04T08:41:26.3521534Z ##[endgroup]
2025-03-04T08:41:26.3535652Z Temporarily overriding HOME='/home/runner/work/_temp/55125d08-469b-4893-b889-39288e8ae725' before making global git config changes
2025-03-04T08:41:26.3536985Z Adding repository directory to the temporary git global config as a safe directory
2025-03-04T08:41:26.3547636Z [command]/usr/bin/git config --global --add safe.directory /home/runner/work/pgadmin4/pgadmin4
2025-03-04T08:41:26.3591749Z Deleting the contents of '/home/runner/work/pgadmin4/pgadmin4'
2025-03-04T08:41:26.3595753Z ##[group]Initializing the repository
2025-03-04T08:41:26.3601814Z [command]/usr/bin/git init /home/runner/work/pgadmin4/pgadmin4
2025-03-04T08:41:26.3682041Z hint: Using 'master' as the name for the initial branch. This default branch name
2025-03-04T08:41:26.3683212Z hint: is subject to change. To configure the initial branch name to use in all
2025-03-04T08:41:26.3684558Z hint: of your new repositories, which will suppress this warning, call:
2025-03-04T08:41:26.3685221Z hint:
2025-03-04T08:41:26.3685697Z hint: 	git config --global init.defaultBranch <name>
2025-03-04T08:41:26.3686274Z hint:
2025-03-04T08:41:26.3686820Z hint: Names commonly chosen instead of 'master' are 'main', 'trunk' and
2025-03-04T08:41:26.3687700Z hint: 'development'. The just-created branch can be renamed via this command:
2025-03-04T08:41:26.3688395Z hint:
2025-03-04T08:41:26.3688788Z hint: 	git branch -m <name>
2025-03-04T08:41:26.3692378Z Initialized empty Git repository in /home/runner/work/pgadmin4/pgadmin4/.git/
2025-03-04T08:41:26.3703239Z [command]/usr/bin/git remote add origin https://github.com/yogeshmahajan-1903/pgadmin4
2025-03-04T08:41:26.3738269Z ##[endgroup]
2025-03-04T08:41:26.3739784Z ##[group]Disabling automatic garbage collection
2025-03-04T08:41:26.3743710Z [command]/usr/bin/git config --local gc.auto 0
2025-03-04T08:41:26.3773800Z ##[endgroup]
2025-03-04T08:41:26.3775087Z ##[group]Setting up auth
2025-03-04T08:41:26.3780984Z [command]/usr/bin/git config --local --name-only --get-regexp core\.sshCommand
2025-03-04T08:41:26.3812320Z [command]/usr/bin/git submodule foreach --recursive sh -c "git config --local --name-only --get-regexp 'core\.sshCommand' && git config --local --unset-all 'core.sshCommand' || :"
2025-03-04T08:41:26.4155002Z [command]/usr/bin/git config --local --name-only --get-regexp http\.https\:\/\/github\.com\/\.extraheader
2025-03-04T08:41:26.4183375Z [command]/usr/bin/git submodule foreach --recursive sh -c "git config --local --name-only --get-regexp 'http\.https\:\/\/github\.com\/\.extraheader' && git config --local --unset-all 'http.https://github.com/.extraheader' || :"
2025-03-04T08:41:26.4408573Z [command]/usr/bin/git config --local http.https://github.com/.extraheader AUTHORIZATION: basic ***
2025-03-04T08:41:26.4445012Z ##[endgroup]
2025-03-04T08:41:26.4446298Z ##[group]Fetching the repository
2025-03-04T08:41:26.4455127Z [command]/usr/bin/git -c protocol.version=2 fetch --no-tags --prune --no-recurse-submodules --depth=1 origin +269393a408040340c0422517cb9ad176f893680f:refs/remotes/origin/GH_3564
2025-03-04T08:41:28.0880817Z From https://github.com/yogeshmahajan-1903/pgadmin4
2025-03-04T08:41:28.0883697Z  * [new ref]         269393a408040340c0422517cb9ad176f893680f -> origin/GH_3564
2025-03-04T08:41:28.0907338Z ##[endgroup]
2025-03-04T08:41:28.0909080Z ##[group]Determining the checkout info
2025-03-04T08:41:28.0911116Z ##[endgroup]
2025-03-04T08:41:28.0913459Z [command]/usr/bin/git sparse-checkout disable
2025-03-04T08:41:28.0954674Z [command]/usr/bin/git config --local --unset-all extensions.worktreeConfig
2025-03-04T08:41:28.0982225Z ##[group]Checking out the ref
2025-03-04T08:41:28.0984552Z [command]/usr/bin/git checkout --progress --force -B GH_3564 refs/remotes/origin/GH_3564
2025-03-04T08:41:28.5724940Z Switched to a new branch 'GH_3564'
2025-03-04T08:41:28.5731088Z branch 'GH_3564' set up to track 'origin/GH_3564'.
2025-03-04T08:41:28.5753942Z ##[endgroup]
2025-03-04T08:41:28.5793832Z [command]/usr/bin/git log -1 --format=%H
2025-03-04T08:41:28.5817440Z 269393a408040340c0422517cb9ad176f893680f
2025-03-04T08:41:28.6022636Z ##[group]Run sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
2025-03-04T08:41:28.6023686Z �[36;1msudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'�[0m
2025-03-04T08:41:28.6024485Z �[36;1mwget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -�[0m
2025-03-04T08:41:28.6077159Z shell: /usr/bin/bash -e {0}
2025-03-04T08:41:28.6077481Z ##[endgroup]
2025-03-04T08:41:28.7150011Z Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
2025-03-04T08:41:29.7236244Z OK
2025-03-04T08:41:29.7389149Z ##[group]Run sudo apt update
2025-03-04T08:41:29.7390040Z �[36;1msudo apt update�[0m
2025-03-04T08:41:29.7390592Z �[36;1msudo apt install -y libpq-dev libffi-dev libssl-dev libkrb5-dev zlib1g-dev postgresql-16 postgresql-16-pldebugger pgagent�[0m
2025-03-04T08:41:29.7440650Z shell: /usr/bin/bash -e {0}
2025-03-04T08:41:29.7440911Z ##[endgroup]
2025-03-04T08:41:29.7598282Z 
2025-03-04T08:41:29.7598693Z WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
2025-03-04T08:41:29.7599364Z 
2025-03-04T08:41:29.8486409Z Get:1 file:/etc/apt/apt-mirrors.txt Mirrorlist [142 B]
2025-03-04T08:41:29.8836682Z Hit:2 http://azure.archive.ubuntu.com/ubuntu jammy InRelease
2025-03-04T08:41:29.8861663Z Get:3 http://azure.archive.ubuntu.com/ubuntu jammy-updates InRelease [128 kB]
2025-03-04T08:41:29.8917814Z Get:4 http://azure.archive.ubuntu.com/ubuntu jammy-backports InRelease [127 kB]
2025-03-04T08:41:29.8991602Z Get:5 http://azure.archive.ubuntu.com/ubuntu jammy-security InRelease [129 kB]
2025-03-04T08:41:29.9933177Z Get:6 https://packages.microsoft.com/repos/azure-cli jammy InRelease [3596 B]
2025-03-04T08:41:30.0315972Z Get:7 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease [3632 B]
2025-03-04T08:41:30.0793081Z Get:8 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages [2354 kB]
2025-03-04T08:41:30.1006286Z Get:9 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main Translation-en [392 kB]
2025-03-04T08:41:30.1044224Z Get:10 http://azure.archive.ubuntu.com/ubuntu jammy-updates/restricted amd64 Packages [3008 kB]
2025-03-04T08:41:30.1342999Z Get:11 http://azure.archive.ubuntu.com/ubuntu jammy-updates/restricted Translation-en [528 kB]
2025-03-04T08:41:30.1393448Z Get:12 http://azure.archive.ubuntu.com/ubuntu jammy-updates/universe amd64 Packages [1192 kB]
2025-03-04T08:41:30.1466504Z Get:13 http://azure.archive.ubuntu.com/ubuntu jammy-updates/universe Translation-en [293 kB]
2025-03-04T08:41:30.2658609Z Get:14 http://azure.archive.ubuntu.com/ubuntu jammy-security/main amd64 Packages [2114 kB]
2025-03-04T08:41:30.2774324Z Get:15 http://azure.archive.ubuntu.com/ubuntu jammy-security/main Translation-en [330 kB]
2025-03-04T08:41:30.2810828Z Get:16 http://azure.archive.ubuntu.com/ubuntu jammy-security/restricted amd64 Packages [2904 kB]
2025-03-04T08:41:30.2952856Z Get:17 http://azure.archive.ubuntu.com/ubuntu jammy-security/restricted Translation-en [510 kB]
2025-03-04T08:41:30.3208784Z Get:20 https://packages.microsoft.com/repos/azure-cli jammy/main amd64 Packages [2212 B]
2025-03-04T08:41:30.3412503Z Get:18 http://azure.archive.ubuntu.com/ubuntu jammy-security/universe amd64 Packages [966 kB]
2025-03-04T08:41:30.3472520Z Get:19 http://azure.archive.ubuntu.com/ubuntu jammy-security/universe Translation-en [207 kB]
2025-03-04T08:41:30.4015385Z Get:21 https://packages.microsoft.com/ubuntu/22.04/prod jammy/main amd64 Packages [186 kB]
2025-03-04T08:41:30.4136002Z Get:22 https://packages.microsoft.com/ubuntu/22.04/prod jammy/main arm64 Packages [46.8 kB]
2025-03-04T08:41:30.4168691Z Get:23 https://packages.microsoft.com/ubuntu/22.04/prod jammy/main armhf Packages [17.4 kB]
2025-03-04T08:41:30.7388127Z Get:24 https://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease [129 kB]
2025-03-04T08:41:31.2263685Z Get:25 https://apt.postgresql.org/pub/repos/apt jammy-pgdg/main amd64 Packages [354 kB]
2025-03-04T08:41:35.2453463Z Fetched 15.9 MB in 2s (8417 kB/s)
2025-03-04T08:41:35.9898333Z Reading package lists...
2025-03-04T08:41:36.1208599Z Building dependency tree...
2025-03-04T08:41:36.1287409Z Reading state information...
2025-03-04T08:41:36.1342064Z W: https://apt.postgresql.org/pub/repos/apt/dists/jammy-pgdg/InRelease: Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION section in apt-key(8) for details.
2025-03-04T08:41:36.1343446Z 49 packages can be upgraded. Run 'apt list --upgradable' to see them.
2025-03-04T08:41:36.1461487Z 
2025-03-04T08:41:36.1462346Z WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
2025-03-04T08:41:36.1462687Z 
2025-03-04T08:41:36.1864910Z Reading package lists...
2025-03-04T08:41:36.3242290Z Building dependency tree...
2025-03-04T08:41:36.3253977Z Reading state information...
2025-03-04T08:41:36.4508703Z libffi-dev is already the newest version (3.4.2-4).
2025-03-04T08:41:36.4509688Z libffi-dev set to manually installed.
2025-03-04T08:41:36.4511995Z libssl-dev is already the newest version (3.0.2-0ubuntu1.19).
2025-03-04T08:41:36.4512706Z zlib1g-dev is already the newest version (1:1.2.11.dfsg-2ubuntu9.2).
2025-03-04T08:41:36.4513363Z libpq-dev is already the newest version (17.4-1.pgdg22.04+2).
2025-03-04T08:41:36.4513978Z The following additional packages will be installed:
2025-03-04T08:41:36.4514878Z   comerr-dev krb5-multidev libboost-filesystem1.74.0 libboost-thread1.74.0
2025-03-04T08:41:36.4515757Z   libgssapi-krb5-2 libgssrpc4 libk5crypto3 libkadm5clnt-mit12
2025-03-04T08:41:36.4516822Z   libkadm5srv-mit12 libkdb5-10 libkrb5-3 libkrb5support0 postgresql-client-16
2025-03-04T08:41:36.4520196Z Suggested packages:
2025-03-04T08:41:36.4520693Z   doc-base krb5-doc krb5-user pgadmin3 | pgadmin4 postgresql-doc-16
2025-03-04T08:41:36.4521252Z Recommended packages:
2025-03-04T08:41:36.4521549Z   krb5-locales
2025-03-04T08:41:36.5206967Z The following NEW packages will be installed:
2025-03-04T08:41:36.5208049Z   comerr-dev krb5-multidev libboost-filesystem1.74.0 libboost-thread1.74.0
2025-03-04T08:41:36.5211033Z   libgssrpc4 libkadm5clnt-mit12 libkadm5srv-mit12 libkdb5-10 libkrb5-dev
2025-03-04T08:41:36.5212108Z   pgagent postgresql-16 postgresql-16-pldebugger postgresql-client-16
2025-03-04T08:41:36.5216361Z The following packages will be upgraded:
2025-03-04T08:41:36.5220815Z   libgssapi-krb5-2 libk5crypto3 libkrb5-3 libkrb5support0
2025-03-04T08:41:36.5479059Z 4 upgraded, 13 newly installed, 0 to remove and 45 not upgraded.
2025-03-04T08:41:36.5857596Z Need to get 21.8 MB of archives.
2025-03-04T08:41:36.5858271Z After this operation, 76.7 MB of additional disk space will be used.
2025-03-04T08:41:36.5858941Z Get:1 file:/etc/apt/apt-mirrors.txt Mirrorlist [142 B]
2025-03-04T08:41:36.6382437Z Get:2 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libk5crypto3 amd64 1.19.2-2ubuntu0.6 [86.5 kB]
2025-03-04T08:41:36.6744670Z Get:3 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkrb5support0 amd64 1.19.2-2ubuntu0.6 [32.5 kB]
2025-03-04T08:41:36.7086014Z Get:4 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkrb5-3 amd64 1.19.2-2ubuntu0.6 [357 kB]
2025-03-04T08:41:36.7475886Z Get:5 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libgssapi-krb5-2 amd64 1.19.2-2ubuntu0.6 [145 kB]
2025-03-04T08:41:36.7829888Z Get:6 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libgssrpc4 amd64 1.19.2-2ubuntu0.6 [58.7 kB]
2025-03-04T08:41:36.8188098Z Get:7 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkdb5-10 amd64 1.19.2-2ubuntu0.6 [40.5 kB]
2025-03-04T08:41:36.8528854Z Get:8 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkadm5srv-mit12 amd64 1.19.2-2ubuntu0.6 [54.7 kB]
2025-03-04T08:41:36.8869469Z Get:9 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkadm5clnt-mit12 amd64 1.19.2-2ubuntu0.6 [41.9 kB]
2025-03-04T08:41:36.9216946Z Get:10 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 comerr-dev amd64 2.1-1.46.5-2ubuntu1.2 [41.0 kB]
2025-03-04T08:41:36.9557162Z Get:11 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 krb5-multidev amd64 1.19.2-2ubuntu0.6 [125 kB]
2025-03-04T08:41:36.9907101Z Get:12 http://azure.archive.ubuntu.com/ubuntu jammy/main amd64 libboost-filesystem1.74.0 amd64 1.74.0-14ubuntu3 [264 kB]
2025-03-04T08:41:37.0281935Z Get:13 http://azure.archive.ubuntu.com/ubuntu jammy/main amd64 libboost-thread1.74.0 amd64 1.74.0-14ubuntu3 [262 kB]
2025-03-04T08:41:37.0651850Z Get:14 http://azure.archive.ubuntu.com/ubuntu jammy-updates/main amd64 libkrb5-dev amd64 1.19.2-2ubuntu0.6 [12.0 kB]
2025-03-04T08:41:37.6218715Z Get:15 https://apt.postgresql.org/pub/repos/apt jammy-pgdg/main amd64 pgagent amd64 4.2.3-2.pgdg22.04+1 [95.3 kB]
2025-03-04T08:41:38.0143354Z Get:16 https://apt.postgresql.org/pub/repos/apt jammy-pgdg/main amd64 postgresql-client-16 amd64 16.8-1.pgdg22.04+1 [1913 kB]
2025-03-04T08:41:39.2682796Z Get:17 https://apt.postgresql.org/pub/repos/apt jammy-pgdg/main amd64 postgresql-16 amd64 16.8-1.pgdg22.04+1 [18.1 MB]
2025-03-04T08:41:40.0760811Z Get:18 https://apt.postgresql.org/pub/repos/apt jammy-pgdg/main amd64 postgresql-16-pldebugger amd64 1:1.8-2.pgdg22.04+1 [84.4 kB]
2025-03-04T08:41:40.3384950Z Preconfiguring packages ...
2025-03-04T08:41:40.3898273Z Fetched 21.8 MB in 4s (6198 kB/s)
2025-03-04T08:41:40.4400200Z (Reading database ... 
2025-03-04T08:41:40.4400582Z (Reading database ... 5%
2025-03-04T08:41:40.4400968Z (Reading database ... 10%
2025-03-04T08:41:40.4401198Z (Reading database ... 15%
2025-03-04T08:41:40.4401420Z (Reading database ... 20%
2025-03-04T08:41:40.4401627Z (Reading database ... 25%
2025-03-04T08:41:40.4401873Z (Reading database ... 30%
2025-03-04T08:41:40.4402079Z (Reading database ... 35%
2025-03-04T08:41:40.4402296Z (Reading database ... 40%
2025-03-04T08:41:40.4402515Z (Reading database ... 45%
2025-03-04T08:41:40.4402710Z (Reading database ... 50%
2025-03-04T08:41:40.4827058Z (Reading database ... 55%
2025-03-04T08:41:40.5140101Z (Reading database ... 60%
2025-03-04T08:41:40.5530615Z (Reading database ... 65%
2025-03-04T08:41:40.5861087Z (Reading database ... 70%
2025-03-04T08:41:40.6313204Z (Reading database ... 75%
2025-03-04T08:41:40.6889058Z (Reading database ... 80%
2025-03-04T08:41:40.7635020Z (Reading database ... 85%
2025-03-04T08:41:40.8065908Z (Reading database ... 90%
2025-03-04T08:41:40.8691790Z (Reading database ... 95%
2025-03-04T08:41:40.8692169Z (Reading database ... 100%
2025-03-04T08:41:40.8692680Z (Reading database ... 270733 files and directories currently installed.)
2025-03-04T08:41:40.8739829Z Preparing to unpack .../libk5crypto3_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:40.9226593Z Unpacking libk5crypto3:amd64 (1.19.2-2ubuntu0.6) over (1.19.2-2ubuntu0.5) ...
2025-03-04T08:41:40.9754510Z Setting up libk5crypto3:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.0140761Z (Reading database ... 
2025-03-04T08:41:41.0141273Z (Reading database ... 5%
2025-03-04T08:41:41.0141643Z (Reading database ... 10%
2025-03-04T08:41:41.0142008Z (Reading database ... 15%
2025-03-04T08:41:41.0142369Z (Reading database ... 20%
2025-03-04T08:41:41.0142703Z (Reading database ... 25%
2025-03-04T08:41:41.0143034Z (Reading database ... 30%
2025-03-04T08:41:41.0143259Z (Reading database ... 35%
2025-03-04T08:41:41.0143475Z (Reading database ... 40%
2025-03-04T08:41:41.0143695Z (Reading database ... 45%
2025-03-04T08:41:41.0143906Z (Reading database ... 50%
2025-03-04T08:41:41.0242899Z (Reading database ... 55%
2025-03-04T08:41:41.0265160Z (Reading database ... 60%
2025-03-04T08:41:41.0292463Z (Reading database ... 65%
2025-03-04T08:41:41.0322836Z (Reading database ... 70%
2025-03-04T08:41:41.0373693Z (Reading database ... 75%
2025-03-04T08:41:41.0525086Z (Reading database ... 80%
2025-03-04T08:41:41.0785327Z (Reading database ... 85%
2025-03-04T08:41:41.0801798Z (Reading database ... 90%
2025-03-04T08:41:41.0984453Z (Reading database ... 95%
2025-03-04T08:41:41.0984872Z (Reading database ... 100%
2025-03-04T08:41:41.0985293Z (Reading database ... 270733 files and directories currently installed.)
2025-03-04T08:41:41.1033226Z Preparing to unpack .../libkrb5support0_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.1066253Z Unpacking libkrb5support0:amd64 (1.19.2-2ubuntu0.6) over (1.19.2-2ubuntu0.5) ...
2025-03-04T08:41:41.1538276Z Setting up libkrb5support0:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.1942427Z (Reading database ... 
2025-03-04T08:41:41.1942808Z (Reading database ... 5%
2025-03-04T08:41:41.1943173Z (Reading database ... 10%
2025-03-04T08:41:41.1943536Z (Reading database ... 15%
2025-03-04T08:41:41.1943882Z (Reading database ... 20%
2025-03-04T08:41:41.1944471Z (Reading database ... 25%
2025-03-04T08:41:41.1944835Z (Reading database ... 30%
2025-03-04T08:41:41.1945168Z (Reading database ... 35%
2025-03-04T08:41:41.1945720Z (Reading database ... 40%
2025-03-04T08:41:41.1946705Z (Reading database ... 45%
2025-03-04T08:41:41.1947057Z (Reading database ... 50%
2025-03-04T08:41:41.2045947Z (Reading database ... 55%
2025-03-04T08:41:41.2068683Z (Reading database ... 60%
2025-03-04T08:41:41.2096503Z (Reading database ... 65%
2025-03-04T08:41:41.2128010Z (Reading database ... 70%
2025-03-04T08:41:41.2179018Z (Reading database ... 75%
2025-03-04T08:41:41.2330809Z (Reading database ... 80%
2025-03-04T08:41:41.2593585Z (Reading database ... 85%
2025-03-04T08:41:41.2610206Z (Reading database ... 90%
2025-03-04T08:41:41.2794787Z (Reading database ... 95%
2025-03-04T08:41:41.2795186Z (Reading database ... 100%
2025-03-04T08:41:41.2795622Z (Reading database ... 270733 files and directories currently installed.)
2025-03-04T08:41:41.2841478Z Preparing to unpack .../libkrb5-3_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.2870519Z Unpacking libkrb5-3:amd64 (1.19.2-2ubuntu0.6) over (1.19.2-2ubuntu0.5) ...
2025-03-04T08:41:41.3405357Z Setting up libkrb5-3:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.3809174Z (Reading database ... 
2025-03-04T08:41:41.3809720Z (Reading database ... 5%
2025-03-04T08:41:41.3810083Z (Reading database ... 10%
2025-03-04T08:41:41.3810431Z (Reading database ... 15%
2025-03-04T08:41:41.3810765Z (Reading database ... 20%
2025-03-04T08:41:41.3811095Z (Reading database ... 25%
2025-03-04T08:41:41.3811428Z (Reading database ... 30%
2025-03-04T08:41:41.3811752Z (Reading database ... 35%
2025-03-04T08:41:41.3812081Z (Reading database ... 40%
2025-03-04T08:41:41.3812411Z (Reading database ... 45%
2025-03-04T08:41:41.3812744Z (Reading database ... 50%
2025-03-04T08:41:41.3910163Z (Reading database ... 55%
2025-03-04T08:41:41.3932534Z (Reading database ... 60%
2025-03-04T08:41:41.3960227Z (Reading database ... 65%
2025-03-04T08:41:41.3990979Z (Reading database ... 70%
2025-03-04T08:41:41.4041828Z (Reading database ... 75%
2025-03-04T08:41:41.4194255Z (Reading database ... 80%
2025-03-04T08:41:41.4462958Z (Reading database ... 85%
2025-03-04T08:41:41.4480048Z (Reading database ... 90%
2025-03-04T08:41:41.4675950Z (Reading database ... 95%
2025-03-04T08:41:41.4676317Z (Reading database ... 100%
2025-03-04T08:41:41.4676805Z (Reading database ... 270733 files and directories currently installed.)
2025-03-04T08:41:41.4727500Z Preparing to unpack .../libgssapi-krb5-2_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.4758177Z Unpacking libgssapi-krb5-2:amd64 (1.19.2-2ubuntu0.6) over (1.19.2-2ubuntu0.5) ...
2025-03-04T08:41:41.5281666Z Setting up libgssapi-krb5-2:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.5648926Z Selecting previously unselected package libgssrpc4:amd64.
2025-03-04T08:41:41.5716152Z (Reading database ... 
2025-03-04T08:41:41.5716543Z (Reading database ... 5%
2025-03-04T08:41:41.5716903Z (Reading database ... 10%
2025-03-04T08:41:41.5717290Z (Reading database ... 15%
2025-03-04T08:41:41.5717635Z (Reading database ... 20%
2025-03-04T08:41:41.5717973Z (Reading database ... 25%
2025-03-04T08:41:41.5718317Z (Reading database ... 30%
2025-03-04T08:41:41.5718657Z (Reading database ... 35%
2025-03-04T08:41:41.5718994Z (Reading database ... 40%
2025-03-04T08:41:41.5719511Z (Reading database ... 45%
2025-03-04T08:41:41.5719857Z (Reading database ... 50%
2025-03-04T08:41:41.5817115Z (Reading database ... 55%
2025-03-04T08:41:41.5839613Z (Reading database ... 60%
2025-03-04T08:41:41.5866724Z (Reading database ... 65%
2025-03-04T08:41:41.5897855Z (Reading database ... 70%
2025-03-04T08:41:41.5948571Z (Reading database ... 75%
2025-03-04T08:41:41.6106674Z (Reading database ... 80%
2025-03-04T08:41:41.6365852Z (Reading database ... 85%
2025-03-04T08:41:41.6382671Z (Reading database ... 90%
2025-03-04T08:41:41.6566797Z (Reading database ... 95%
2025-03-04T08:41:41.6567171Z (Reading database ... 100%
2025-03-04T08:41:41.6567998Z (Reading database ... 270733 files and directories currently installed.)
2025-03-04T08:41:41.6615289Z Preparing to unpack .../00-libgssrpc4_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.6626935Z Unpacking libgssrpc4:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.6878146Z Selecting previously unselected package libkdb5-10:amd64.
2025-03-04T08:41:41.7038072Z Preparing to unpack .../01-libkdb5-10_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.7050316Z Unpacking libkdb5-10:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.7291440Z Selecting previously unselected package libkadm5srv-mit12:amd64.
2025-03-04T08:41:41.7450339Z Preparing to unpack .../02-libkadm5srv-mit12_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.7461409Z Unpacking libkadm5srv-mit12:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.7698648Z Selecting previously unselected package libkadm5clnt-mit12:amd64.
2025-03-04T08:41:41.7857486Z Preparing to unpack .../03-libkadm5clnt-mit12_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.7866196Z Unpacking libkadm5clnt-mit12:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.8096968Z Selecting previously unselected package comerr-dev:amd64.
2025-03-04T08:41:41.8253769Z Preparing to unpack .../04-comerr-dev_2.1-1.46.5-2ubuntu1.2_amd64.deb ...
2025-03-04T08:41:41.8285764Z Unpacking comerr-dev:amd64 (2.1-1.46.5-2ubuntu1.2) ...
2025-03-04T08:41:41.8592185Z Selecting previously unselected package krb5-multidev:amd64.
2025-03-04T08:41:41.8749857Z Preparing to unpack .../05-krb5-multidev_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:41.8757409Z Unpacking krb5-multidev:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:41.9104106Z Selecting previously unselected package libboost-filesystem1.74.0:amd64.
2025-03-04T08:41:41.9263288Z Preparing to unpack .../06-libboost-filesystem1.74.0_1.74.0-14ubuntu3_amd64.deb ...
2025-03-04T08:41:41.9272818Z Unpacking libboost-filesystem1.74.0:amd64 (1.74.0-14ubuntu3) ...
2025-03-04T08:41:41.9637818Z Selecting previously unselected package libboost-thread1.74.0:amd64.
2025-03-04T08:41:41.9800684Z Preparing to unpack .../07-libboost-thread1.74.0_1.74.0-14ubuntu3_amd64.deb ...
2025-03-04T08:41:41.9808932Z Unpacking libboost-thread1.74.0:amd64 (1.74.0-14ubuntu3) ...
2025-03-04T08:41:42.0112499Z Selecting previously unselected package pgagent.
2025-03-04T08:41:42.0276554Z Preparing to unpack .../08-pgagent_4.2.3-2.pgdg22.04+1_amd64.deb ...
2025-03-04T08:41:42.0285027Z Unpacking pgagent (4.2.3-2.pgdg22.04+1) ...
2025-03-04T08:41:42.0711167Z Selecting previously unselected package postgresql-client-16.
2025-03-04T08:41:42.0874205Z Preparing to unpack .../09-postgresql-client-16_16.8-1.pgdg22.04+1_amd64.deb ...
2025-03-04T08:41:42.0882965Z Unpacking postgresql-client-16 (16.8-1.pgdg22.04+1) ...
2025-03-04T08:41:42.2894277Z Selecting previously unselected package postgresql-16.
2025-03-04T08:41:42.3061022Z Preparing to unpack .../10-postgresql-16_16.8-1.pgdg22.04+1_amd64.deb ...
2025-03-04T08:41:42.3098423Z Unpacking postgresql-16 (16.8-1.pgdg22.04+1) ...
2025-03-04T08:41:43.5292502Z Selecting previously unselected package postgresql-16-pldebugger.
2025-03-04T08:41:43.5464213Z Preparing to unpack .../11-postgresql-16-pldebugger_1%3a1.8-2.pgdg22.04+1_amd64.deb ...
2025-03-04T08:41:43.5471989Z Unpacking postgresql-16-pldebugger (1:1.8-2.pgdg22.04+1) ...
2025-03-04T08:41:43.5746346Z Selecting previously unselected package libkrb5-dev:amd64.
2025-03-04T08:41:43.5912214Z Preparing to unpack .../12-libkrb5-dev_1.19.2-2ubuntu0.6_amd64.deb ...
2025-03-04T08:41:43.5920462Z Unpacking libkrb5-dev:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:43.6497329Z Setting up postgresql-client-16 (16.8-1.pgdg22.04+1) ...
2025-03-04T08:41:44.0418806Z update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
2025-03-04T08:41:44.0650943Z Setting up libboost-filesystem1.74.0:amd64 (1.74.0-14ubuntu3) ...
2025-03-04T08:41:44.0677032Z Setting up libgssrpc4:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.0702198Z Setting up comerr-dev:amd64 (2.1-1.46.5-2ubuntu1.2) ...
2025-03-04T08:41:44.0733628Z Setting up libboost-thread1.74.0:amd64 (1.74.0-14ubuntu3) ...
2025-03-04T08:41:44.0755974Z Setting up libkadm5clnt-mit12:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.0777843Z Setting up libkdb5-10:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.0798268Z Setting up postgresql-16 (16.8-1.pgdg22.04+1) ...
2025-03-04T08:41:44.9343368Z Setting up postgresql-16-pldebugger (1:1.8-2.pgdg22.04+1) ...
2025-03-04T08:41:44.9364411Z Setting up libkadm5srv-mit12:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.9388695Z Setting up pgagent (4.2.3-2.pgdg22.04+1) ...
2025-03-04T08:41:44.9413131Z Setting up krb5-multidev:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.9437069Z Setting up libkrb5-dev:amd64 (1.19.2-2ubuntu0.6) ...
2025-03-04T08:41:44.9465133Z Processing triggers for install-info (6.8-4build1) ...
2025-03-04T08:41:45.3694790Z Processing triggers for libc-bin (2.35-0ubuntu3.9) ...
2025-03-04T08:41:45.4846803Z Processing triggers for man-db (2.10.2-1) ...
2025-03-04T08:41:46.0047607Z Processing triggers for postgresql-common (274.pgdg22.04+1) ...
2025-03-04T08:41:46.2266663Z Building PostgreSQL dictionaries from installed myspell/hunspell packages...
2025-03-04T08:41:46.2271801Z   en_us
2025-03-04T08:41:46.3151554Z Removing obsolete dictionary files:
2025-03-04T08:41:46.5648927Z NEEDRESTART-VER: 3.5
2025-03-04T08:41:46.9082053Z NEEDRESTART-KCUR: 6.8.0-1021-azure
2025-03-04T08:41:46.9082552Z NEEDRESTART-KEXP: 6.8.0-1021-azure
2025-03-04T08:41:46.9082879Z NEEDRESTART-KSTA: 1
2025-03-04T08:41:46.9083119Z NEEDRESTART-SVC: mono-xsp4.service
2025-03-04T08:41:46.9083390Z NEEDRESTART-SVC: packagekit.service
2025-03-04T08:41:46.9083662Z NEEDRESTART-SVC: php8.1-fpm.service
2025-03-04T08:41:46.9083916Z NEEDRESTART-SVC: ssh.service
2025-03-04T08:41:46.9084155Z NEEDRESTART-SVC: [email protected]
2025-03-04T08:41:48.4347174Z ##[group]Run sudo ls -la /etc/postgresql/
2025-03-04T08:41:48.4347560Z �[36;1msudo ls -la /etc/postgresql/�[0m
2025-03-04T08:41:48.4347850Z �[36;1msudo ls -la /etc/postgresql/16/main/�[0m
2025-03-04T08:41:48.4348501Z �[36;1msudo su - postgres -c "/usr/lib/postgresql/16/bin/postgres -D /var/lib/postgresql/16/main -c config_file=/etc/postgresql/16/main/postgresql.conf &"�[0m
2025-03-04T08:41:48.4349128Z �[36;1m�[0m
2025-03-04T08:41:48.4349628Z �[36;1muntil sudo runuser -l postgres -c "pg_isready -p 5916" 2>/dev/null; do�[0m
2025-03-04T08:41:48.4350061Z �[36;1m  >&2 echo "Postgres is unavailable - sleeping for 2 seconds"�[0m
2025-03-04T08:41:48.4350377Z �[36;1m  sleep 2�[0m
2025-03-04T08:41:48.4350569Z �[36;1mdone�[0m
2025-03-04T08:41:48.4398108Z shell: /usr/bin/bash -e {0}
2025-03-04T08:41:48.4398354Z ##[endgroup]
2025-03-04T08:41:48.4531521Z total 20
2025-03-04T08:41:48.4531909Z drwxr-xr-x   3 postgres postgres  4096 Feb 23 21:47 .
2025-03-04T08:41:48.4532307Z drwxr-xr-x 135 root     root     12288 Mar  4 08:41 ..
2025-03-04T08:41:48.4532652Z drwxr-xr-x   3 postgres postgres  4096 Feb 23 21:47 14
2025-03-04T08:41:48.4607573Z ls: cannot access '/etc/postgresql/16/main/': No such file or directory
2025-03-04T08:41:48.4628836Z ##[error]Process completed with exit code 2.
2025-03-04T08:41:48.4709893Z Post job cleanup.
2025-03-04T08:41:48.5627584Z [command]/usr/bin/git version
2025-03-04T08:41:48.5662699Z git version 2.48.1
2025-03-04T08:41:48.5706142Z Temporarily overriding HOME='/home/runner/work/_temp/19bb9c66-6685-470b-8622-5bf0ab38ce62' before making global git config changes
2025-03-04T08:41:48.5707388Z Adding repository directory to the temporary git global config as a safe directory
2025-03-04T08:41:48.5712625Z [command]/usr/bin/git config --global --add safe.directory /home/runner/work/pgadmin4/pgadmin4
2025-03-04T08:41:48.5748798Z [command]/usr/bin/git config --local --name-only --get-regexp core\.sshCommand
2025-03-04T08:41:48.5781608Z [command]/usr/bin/git submodule foreach --recursive sh -c "git config --local --name-only --get-regexp 'core\.sshCommand' && git config --local --unset-all 'core.sshCommand' || :"
2025-03-04T08:41:48.6025644Z [command]/usr/bin/git config --local --name-only --get-regexp http\.https\:\/\/github\.com\/\.extraheader
2025-03-04T08:41:48.6046245Z http.https://github.com/.extraheader
2025-03-04T08:41:48.6058836Z [command]/usr/bin/git config --local --unset-all http.https://github.com/.extraheader
2025-03-04T08:41:48.6090513Z [command]/usr/bin/git submodule foreach --recursive sh -c "git config --local --name-only --get-regexp 'http\.https\:\/\/github\.com\/\.extraheader' && git config --local --unset-all 'http.https://github.com/.extraheader' || :"
2025-03-04T08:41:48.6424013Z Cleaning up orphan processes

Platforms affected

  • Azure DevOps
  • GitHub Actions - Standard Runners
  • GitHub Actions - Larger Runners

Runner images affected

  • Ubuntu 20.04
  • Ubuntu 22.04
  • Ubuntu 24.04
  • macOS 13
  • macOS 13 Arm64
  • macOS 14
  • macOS 14 Arm64
  • macOS 15
  • macOS 15 Arm64
  • Windows Server 2019
  • Windows Server 2022
  • Windows Server 2025

Image version and build link

https://github.com/yogeshmahajan-1903/pgadmin4/actions/runs/13649033614/job/38153270401

Is it regression?

Yes.
Old
Image: ubuntu-22.04
Version: 20250209.1.0
New
Image: ubuntu-22.04
Version: 20250223.1.0

Expected behavior

PostgreSQL should start.

Actual behavior

PostgreSQL does not start.

Repro steps

name: Tests on Postgres installation

on: [push, pull_request]

jobs:
  run-feature-tests-pg:
    strategy:
      fail-fast: false
      matrix:
        os: [ubuntu-22.04]
        pgver: [13, 14, 15, 16, 17]

    runs-on: ${{ matrix.os }}

    steps:
      - uses: actions/checkout@v4

      - name: Setup the PGDG APT repo on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
          wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

      - name: Install platform dependencies on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo apt update
          sudo apt install -y libpq-dev libffi-dev libssl-dev libkrb5-dev zlib1g-dev postgresql-${{ matrix.pgver }} postgresql-${{ matrix.pgver }}-pldebugger pgagent

      - name: Start PostgreSQL on Linux
        if: ${{ matrix.os == 'ubuntu-22.04' }}
        run: |
          sudo ls -la /etc/postgresql/
          sudo ls -la /etc/postgresql/${{ matrix.pgver }}/main/
          sudo su - postgres -c "/usr/lib/postgresql/${{ matrix.pgver }}/bin/postgres -D /var/lib/postgresql/${{ matrix.pgver }}/main -c config_file=/etc/postgresql/${{ matrix.pgver }}/main/postgresql.conf &"

          until sudo runuser -l postgres -c "pg_isready -p 59${{ matrix.pgver }}" 2>/dev/null; do
            >&2 echo "Postgres is unavailable - sleeping for 2 seconds"
            sleep 2
          done
@vidyasagarnimmagaddi vidyasagarnimmagaddi self-assigned this Mar 4, 2025
@vidyasagarnimmagaddi
Copy link
Contributor

Hi @yogeshmahajan-1903 ,Thank you for bringing this issue to our attention. We will look into this issue and will update you after investigating.


@ankane ankane mentioned this issue Mar 6, 2025
Closed
@enescakir
Copy link
Contributor

PostgreSQL post scripts have changed recently. https://salsa.debian.org/postgresql/postgresql-common/-/commit/d9139f7777a42a39b5b6fabbffc9f020fad4dce5

The new database won't be initialized if any other database already exists. Since the runner image comes with PostgreSQL 14 by default, the new version won't automatically trigger pg_createcluster for the newly installed version.

You can delete the PostgreSQL 14 cluster just before installing the new version.

pg_dropcluster 14 main --stop

It will initialize a new database when you install the new version.

@ankane
Copy link

ankane commented Mar 6, 2025

Also, if installing an earlier version of Postgres, you need to remove the previous version (or a new cluster won't be created).

sudo apt-get remove postgresql-14

https://salsa.debian.org/postgresql/postgresql-common/-/blob/debian/274/debian/maintscripts-functions#L90-92

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vidyasagarnimmagaddi vidyasagarnimmagaddi

Labels
Area: Databases bug report OS: Ubuntu
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ankane @enescakir @yogeshmahajan-1903 @vidyasagarnimmagaddi