How to install pgstattuple extension in postgres 10.6?

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to install pgstattuple extension in postgres 10.6?
Date: 2019-07-09 17:52:18
Message-ID: CAF6DVKPCWMOS=Y1-i4x7r95J76dfg-G6618yDUSD_fSvmVXHzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can someone let me know how to install pgstattuple extension in postgres
10.6 running on Ubuntu 16?

I have installed postgres-contrib and can see the following .sql files
under extension folder

ubuntu(at)vrni-proxy:~$ ls
/usr/share/postgresql/10/extension/pgstattuple*/usr/share/postgresql/10/extension/pgstattuple--1.0--1.1.sql
/usr/share/postgresql/10/extension/pgstattuple--1.3--1.4.sql
/usr/share/postgresql/10/extension/pgstattuple.control/usr/share/postgresql/10/extension/pgstattuple--1.1--1.2.sql
/usr/share/postgresql/10/extension/pgstattuple--1.4--1.5.sql
/usr/share/postgresql/10/extension/pgstattuple--unpackaged--1.0.sql/usr/share/postgresql/10/extension/pgstattuple--1.2--1.3.sql
/usr/share/postgresql/10/extension/pgstattuple--1.4.sql

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2019-07-09 18:02:47 Re: How to install pgstattuple extension in postgres 10.6?
Previous Message Thorsten Schöning 2019-07-09 10:42:07 Re: Does anyone backup directly on Synology NAS using Barman or similar?