I"m trying to help someone who refused to upgrade to PG13 and now has an expired SSL cert. It may be made more difficult because of Apt-get update fails inside container yarn repo not signed - #5 by pfaffman , but I modified the pg12 and pg13 templates so that they should work, but I can’t get it to…

Can’t you add the below to hooks to create the unaccent extension if it’s missing? after_postgres: - exec: su postgres -c 'psql discourse -c "create extension if not exists unaccent;"'

Looks like that did it! I had to add it to the pg12 and postgres. Well, it did it enough to get it running again with PG12, but I never got the PG13 upgrade to work. I made a backup. moved the postgres stuff to a backup directory, rebuilt, and restored the backup.

Problem with postgres upgrade

Product Support Self-hosting

pfaffman (Jay Pfaffman) February 9, 2023, 3:33am 3

Sounds like a plan! I’ll check it out on the morning. Thanks

Topic		Replies	Views
Trouble with postgre（maybe） Self-hosting	5	1817	August 13, 2020
Upgrade of postgres failed Self-hosting	1	1191	September 25, 2020
Forum offline due to failed rebuilds on Tests-Pass Self-hosting	1	1235	December 11, 2020
Manual upgrade failure due to postgres error Self-hosting	1	537	October 28, 2020
Update failed (postgresql) Self-hosting	7	4101	June 3, 2020

Problem with postgres upgrade

Related topics