Conversation

Notices

1. Embed this notice
   Marcin Mikołajczak (mkljczk@pl.fediverse.pl)'s status on Thursday, 29-Sep-2022 03:19:41 JST Marcin Mikołajczak

   What would be the simplest way to upgrade postgresql 10 to postgresql 14?

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Thursday, 29-Sep-2022 03:19:39 JST Alex Gleason

     in reply to
     sudo -Hu postgres pg_dump -Fc pleroma > pleroma.dump
     
     Set up a new server with Postgres 14 and rsync over your config, then
     
     sudo -Hu postgres pg_restore -j 8 -Fc -d pleroma /path/to/pleroma.dump
   • Embed this notice
     Johnny Peligro (mischievoustomato@varishangout.net)'s status on Thursday, 29-Sep-2022 04:06:49 JST Johnny Peligro

     in reply to

     • Alex Gleason
     @alex @mkljczk if -j means jobs then doing -j $(nproc) or -j (nproc) for fish would be better
     Alex Gleason likes this.