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

postgresql_11: 11.0 -> 11.1 #50646

Merged
merged 1 commit into from Nov 26, 2018
Merged

postgresql_11: 11.0 -> 11.1 #50646

merged 1 commit into from Nov 26, 2018

Conversation

r-ryantm
Copy link
Contributor

Semi-automatic update generated by https://github.com/ryantm/nixpkgs-update tools. This update was made based on information from https://repology.org/metapackage/postgresql/versions.

meta.description for postgresql_11 is: '"A powerful, open source object-relational database system"'.

Checks done (click to expand)
  • built on NixOS
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/postmaster passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/postgres passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/ecpg passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_archivecleanup passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_basebackup passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_receivewal passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_recvlogical passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_config passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_controldata passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_ctl passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_dump passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_restore passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_dumpall passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_resetwal passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_rewind passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_test_fsync passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_test_timing passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_upgrade passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_verify_checksums passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_waldump passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pgbench passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/psql passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/createdb passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/dropdb passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/createuser passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/dropuser passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/clusterdb passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/vacuumdb passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/reindexdb passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_isready passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/oid2name passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/pg_standby passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/vacuumlo passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/.initdb-wrapped passed the binary check.
  • /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin/initdb passed the binary check.
  • 35 of 35 passed binary check by having a zero exit code.
  • 35 of 35 passed binary check by having the new version present in output.
  • found 11.1 with grep in /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1
  • directory tree listing: https://gist.github.com/e6028fed2791179a8650fcccc4a4f98c
  • du listing: https://gist.github.com/6bb8d8720134108825307c8b7ffa81b3
Rebuild report (click to expand)

4 total rebuild path(s)

1 package rebuild(s)

1 x86_64-linux rebuild(s)
1 i686-linux rebuild(s)
1 x86_64-darwin rebuild(s)
1 aarch64-linux rebuild(s)

First fifty rebuilds by attrpath
postgresql_11

Instructions to test this update (click to expand)

Either download from Cachix:

nix-store -r /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1 \
  --option binary-caches 'https://cache.nixos.org/ https://r-ryantm.cachix.org/' \
  --option trusted-public-keys '
  r-ryantm.cachix.org-1:gkUbLkouDAyvBdpBX0JOdIiD2/DP1ldF3Z3Y6Gqcc4c=
  cache.nixos.org-1:6NCHdD59X431o0gWypbMrAURkbJ16ZPMQFGspcDShjY=
  '

(r-ryantm's Cachix cache is only trusted for this store-path realization.)

Or, build yourself:

nix-build -A postgresql_11 https://github.com/r-ryantm/nixpkgs/archive/5088c137ae343e9fde08f76cb7eb9c5e32aabc08.tar.gz

After you've downloaded or built it, look at the files and if there are any, run the binaries:

ls -la /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1
ls -la /nix/store/cy2cpagavdva5fl70km0jxqnbq0xkkms-postgresql-11.1/bin

cc @ocharles @thoughtpolice for testing.

@r-ryantm
postgresql_11: 11.0 -> 11.1
5088c13 
Semi-automatic update generated by
https://github.com/ryantm/nixpkgs-update tools. This update was made
based on information from
https://repology.org/metapackage/postgresql/versions
@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: postgresql_11

Partial log (click to expand)

checking for references to /build in /nix/store/jykkbq55wifaq2p6k85sc5f3w10qhapj-postgresql-11.1-lib...
shrinking RPATHs of ELF executables and libraries in /nix/store/g16rc0rh2gmbjdwx08m6ig0lxwij7z45-postgresql-11.1-doc
strip is /nix/store/p9akxn2sfy4wkhqdqa3li97pc6jaz3r1-binutils-2.30/bin/strip
patching script interpreter paths in /nix/store/g16rc0rh2gmbjdwx08m6ig0lxwij7z45-postgresql-11.1-doc
checking for references to /build in /nix/store/g16rc0rh2gmbjdwx08m6ig0lxwij7z45-postgresql-11.1-doc...
shrinking RPATHs of ELF executables and libraries in /nix/store/4py1nqia5bjvwfx541pa5984rvr6f9w3-postgresql-11.1-man
gzipping man pages under /nix/store/4py1nqia5bjvwfx541pa5984rvr6f9w3-postgresql-11.1-man/share/man/
strip is /nix/store/p9akxn2sfy4wkhqdqa3li97pc6jaz3r1-binutils-2.30/bin/strip
patching script interpreter paths in /nix/store/4py1nqia5bjvwfx541pa5984rvr6f9w3-postgresql-11.1-man
checking for references to /build in /nix/store/4py1nqia5bjvwfx541pa5984rvr6f9w3-postgresql-11.1-man...

@GrahamcOfBorg
Copy link

Success on x86_64-darwin (full log)

Attempted: postgresql_11

Partial log (click to expand)

/nix/store/isfggvc6946vj9c7f10slyy9gyx9z40k-postgresql-11.1/lib/pgxs/config/install-sh: interpreter directive changed from "/bin/sh" to "/nix/store/n9hba031gjky8hpjgx9fnlaxhidyzxbz-bash-4.4-p23/bin/sh"
/nix/store/isfggvc6946vj9c7f10slyy9gyx9z40k-postgresql-11.1/lib/pgxs/config/missing: interpreter directive changed from " /bin/sh" to "/nix/store/n9hba031gjky8hpjgx9fnlaxhidyzxbz-bash-4.4-p23/bin/sh"
strip is /nix/store/g5r4apl0za012ffs6ladinwa5w0m1l3k-cctools-binutils-darwin/bin/strip
stripping (with command strip and flags -S) in /nix/store/zdfysnlpdvzwswwjhyd3hjzla2n66nd7-postgresql-11.1-lib/lib
patching script interpreter paths in /nix/store/zdfysnlpdvzwswwjhyd3hjzla2n66nd7-postgresql-11.1-lib
strip is /nix/store/g5r4apl0za012ffs6ladinwa5w0m1l3k-cctools-binutils-darwin/bin/strip
patching script interpreter paths in /nix/store/knpn2mdv0r1y89lqzhb4z9qpk8hx5bqp-postgresql-11.1-doc
gzipping man pages under /nix/store/0kyld5a65caxphhgjvn6njl55z6l1frc-postgresql-11.1-man/share/man/
strip is /nix/store/g5r4apl0za012ffs6ladinwa5w0m1l3k-cctools-binutils-darwin/bin/strip
patching script interpreter paths in /nix/store/0kyld5a65caxphhgjvn6njl55z6l1frc-postgresql-11.1-man

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: postgresql_11

Partial log (click to expand)

checking for references to /build in /nix/store/pdcd2r5azs7b3gvag869n7ll4cya0j1h-postgresql-11.1-lib...
shrinking RPATHs of ELF executables and libraries in /nix/store/y2qnaqs3dndn17i8br150p0mck4011wd-postgresql-11.1-doc
strip is /nix/store/vcc4svb8gy29g4pam2zja6llkbcwsyiq-binutils-2.30/bin/strip
patching script interpreter paths in /nix/store/y2qnaqs3dndn17i8br150p0mck4011wd-postgresql-11.1-doc
checking for references to /build in /nix/store/y2qnaqs3dndn17i8br150p0mck4011wd-postgresql-11.1-doc...
shrinking RPATHs of ELF executables and libraries in /nix/store/3m83bbbyl255j7chwz80nyg9909l683r-postgresql-11.1-man
gzipping man pages under /nix/store/3m83bbbyl255j7chwz80nyg9909l683r-postgresql-11.1-man/share/man/
strip is /nix/store/vcc4svb8gy29g4pam2zja6llkbcwsyiq-binutils-2.30/bin/strip
patching script interpreter paths in /nix/store/3m83bbbyl255j7chwz80nyg9909l683r-postgresql-11.1-man
checking for references to /build in /nix/store/3m83bbbyl255j7chwz80nyg9909l683r-postgresql-11.1-man...

@thoughtpolice thoughtpolice merged commit 128a446 into NixOS:master Nov 26, 2018
@r-ryantm r-ryantm deleted the auto-update/postgresql branch December 8, 2018 22:26
danbst added a commit to danbst/nixpkgs that referenced this pull request Feb 21, 2019
@danbst
postgresql: fix regression in NixOS after update to 11.2
dcbf57a 
ryantm bot updates `psqlSchema` alongside with version: NixOS#50646, NixOS#55860
but `psqlSchema` is used to generate `stateDir`. It shouldn't be updated.

Ideally it should be equal to postgresql major version for pg versions,
but we already have deployments in /var/lib/postgresql/11.1. Strange why
nobody complained when it was changed from 11.0 -> 11.1.

I propose do correct naming for PG12+, but status quo for current versions.

Fixes NixOS#56134
@danbst danbst mentioned this pull request Feb 21, 2019
Merged
danbst added a commit that referenced this pull request Feb 21, 2019
@danbst
postgresql: fix regression in NixOS after update to 11.2 (#56146)
d0d0992 
ryantm bot updates `psqlSchema` alongside with version: #50646, #55860
but `psqlSchema` is used to generate `stateDir`. It shouldn't be updated.

Ideally it should be equal to postgresql major version for pg versions,
but we already have deployments in /var/lib/postgresql/11.1. Strange why
nobody complained when it was changed from 11.0 -> 11.1.

I propose do correct naming for PG12+, but status quo for current versions.

Fixes #56134
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@thoughtpolice thoughtpolice Awaiting requested review from thoughtpolice thoughtpolice is a code owner

Assignees
No one assigned
Labels
10.rebuild-darwin: 1-10 10.rebuild-linux: 1-10
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

None yet
3 participants
@r-ryantm @GrahamcOfBorg @thoughtpolice