Re: pg_dump: VACUUM and REINDEXING

asan On Sat, 7 May 2022 at 18:07, Guillaume Lelarge wrote: > Le sam. 7 mai 2022 à 10:21, Ron a écrit : > >> On 5/6/22 21:35, Hasan Marzooq wrote: >> >> Hello! >> >> I've some questions around Backup & Restore. >> >> 1: Is it necessary t

pg_dump: VACUUM and REINDEXING

Hello! I've some questions around Backup & Restore. 1: Is it necessary to perform a VACUUM and REINDEXING operation after restoring the dump from Postgres 9.6 to Postgres 13? The dump size could be 1/2 TB to 1 TB. 2: Also, are there any other operations that are recommended to perform after pg_r

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

entos rhel fedora" VERSION_ID="2" PRETTY_NAME="Amazon Linux 2" ANSI_COLOR="0;33" CPE_NAME="cpe:2.3:o:amazon:amazon_linux:2" HOME_URL="https://amazonlinux.com/"; Amazon Linux release 2 (Karoo) And: --- # rpm -E %{rhel} 7 Thanks! On Sun, 2 Jan 202

Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2

@pgdg96 postgresql96-devel.x86_64 9.6.24-1PGDG.rhel6@pgdg96 postgresql96-libs.x86_64 9.6.24-1PGDG.rhel6@pgdg96 postgresql96-server.x86_64 9.6.24-1PGDG.rhel6@pgdg96 --- On Thu, 30 Dec 2021 at 17:48, Magnus Hagander wrote: > O

pg_config header files are missing - Postgres 13 - Amazon Linux 2

Hello! We've a web application in play framework which uses Postgres 9.6 with plv8 and uuid-ossp extension. We now want to use Postgres 13 instead of 9.6. To achieve this, I'm trying to install Postgres 13 (on the same host where 9.6 is installed) with plv8 and uuid-ossp extension. PLV8