cd /optgit clone --branch v0.8.2 https://github.com/pgvector/pgvector.gitexport PG_CONFIG=/usr/local/pg18/bin/pg_configcd pgvectormakemake installgit clone https://github.com/citusdata/pg_cron.gitcd pg_cron# Ensure pg_config is in your path, e.g.export PATH=/usr/local/pg18/bin:$PATHmake && sudo PATH=$PATH make installp_ashcd /optgit clone https://github.com/NikolayS/pg_ash.gitcd /opt/pg_ash/sqlsu - postgrespsql \i /opt/pg_ash/sql/ash-install.sql-- start sampling (1 sample/second — uses pg_cron if available, otherwise prints external scheduling instructions)select ash.start('1 second');git clone https://github.com/pgaudit/pgaudit.gitmake install USE_PGXS=1 PG_CONFIG=/usr/local/pg18/bin/pg_configgit clone https://github.com/pgaudit/set_usercd set_usermake USE_PGXS=1 install PG_CONFIG=/usr/local/pg18/bin/pg_config git clone https://github.com/eulerto/wal2json.git$ tar -zxf wal2json-wal2json_2_6.tar.gz$ cd wal2json-wal2json_2_6$ export PATH=/usr/local/pg18/bin:$PATHmake USE_PGXS=1 install PG_CONFIG=/usr/local/pg18/bin/pg_config【$ make$ make install】wget -q -O - \ https://github.com/pgbackrest/pgbackrest/archive/release/2.58.0.tar.gz | \ tar zx -C /optsudo yum install make gcc openssl-devel libxml2-devel lz4-devel libzstd-devel bzip2-devel libyaml-devel libssh2-devel postgresql-develpip3 install mesonyum install bzip2-develyum install postgresql-develdnf config-manager --set-enabled crbdnf install -y libyaml-devel#yum install -y libyaml-develsudo sh -c 'ln -s $(pkg-config --path yaml) $(dirname $(pkg-config --path yaml))/yaml-0.1.pc'meson setup build --reconfigurednf install -y ninja-buildyum install libssh2* -ymeson setup build --reconfigureninja -C buildyum install postgresql-libs libssh2meson setup /opt/pgbackrest /opt/pgbackrest-release-2.58.0ninja -C /opt/pgbackrestsudo scp /opt/pgbackrest-release-2.58.0/build/src/pgbackrest /usr/binsudo chmod 755 /usr/bin/pgbackrestyum install perl-JSON-XSwget https://github.com/darold/pgbadger/archive/refs/tags/v13.2.tar.gztar -xf v13.2.tar.gzcd pgbadger-13.2/perl Makefile.PLmake && sudo make installwget https://www.pgbouncer.org/downloads/files/1.25.1/pgbouncer-1.25.1.tar.gztar -xf pgbouncer-1.25.1.tar.gzsudo dnf install -y libevent-develsudo dnf install -y pandoc./configure --prefix=/usr/localmakemake installwget https://github.com/jobinau/pg_gather/archive/refs/tags/v33.zipunzip v33.zip`````` git clone https://github.com/reorg/pg_repack.gitcd pg_repackexport PATH=/usr/local/pg18/bin:$PATHexport PG_CONFIG=/usr/local/pg18/bin/pg_configmakesudo make installgit clone https://github.com/cybertec-postgresql/pg_squeeze.gitcd pg_squeezemake make installgit clone https://github.com/ossc-db/pg_hint_plan.gitcd pg_hint_planmake make installgit clone https://github.com/Percona-Lab/pg_stat_monitor.gitcd pg_stat_monitormakemake installgit clone https://github.com/zubkov-andrei/pg_profile.gitgit clone https://github.com/pgpartman/pg_partman.gitmakemake install
夜雨聆风
