pg_upgrade sillyness

pg_upgrade --old-datadir data --new-datadir data18 --old-bindir=/usr/lib/postgresql12/bin --new-bindir=/usr/lib/postgresql18/bin

could not open version file "data18/PG_VERSION": No such file or directory
Failure, exiting

It should just create damn directory structure itself already. Have you no defaults?

$ /usr/lib/postgresql18/bin/initdb -D data18 --encoding=UTF8 --no-data-checksums --auth=ident
$ /usr/lib/postgresql18/bin/pg_upgrade -b /usr/lib/postgresql12/bin -B /usr/lib/postgresql18/bin -d data -D data18
(systemctl start postgresql)
$ psql -f /var/lib/pgsql/update_extensions.sql
$ /usr/lib/postgresql18/bin/vacuumdb --all --analyze-in-stages --missing-stats-only

Posted 2026-10-12 17:10 / Tags: Postgres, Sql. / link

Notes on photo sphere/panoramic EXIF metadata

• Google's EXIF/XMP metadata tag specification for panoramic images
• Panorama images with sky are to have a negative value for the CroppedAreaTopPixels tag. (The panoramic viewer of Facebook ignores the value altogether, though, and assumes the horizon in the middle of the picture.)
• If a camera or software normally produces panoramic images with cylindrical projection, then doing a vertical capture actually produces a transverse cylindrical image. There is no standardized value for the EXIF ProjectionType field to cover this. (One option is to reproject them to equirectangular — which, again, is not very well supported.)
• Facebook's document on what tags to set
• The Facebook web interface insists that FullPanoHeightPixels be half the size of FullPanoWidthPixels. Else you get “no new photos were uploaded”.

/ Tags: Photo.