Re: How to install pgstattuple extension in postgres 10.6?

Поиск
Список
Период
Сортировка
От Keith
Тема Re: How to install pgstattuple extension in postgres 10.6?
Дата
Msg-id CAHw75vvp89zwHtYZL5rUifEM=Xa-CW0=vJTQAJ0TNP35yUydag@mail.gmail.com
обсуждение исходный текст
Ответ на How to install pgstattuple extension in postgres 10.6?  (Debraj Manna <subharaj.manna@gmail.com>)
Список pgsql-admin


On Tue, Jul 9, 2019 at 1:53 PM Debraj Manna <subharaj.manna@gmail.com> wrote:

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@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/pgs


If the contrib package has been installed, all you have to do is log as a superuser to the database you want the extension to exist and type:

CREATE EXTENSION pgstattuple;

You don't have to touch the sql files.

Keith

В списке pgsql-admin по дате отправления:

Предыдущее
От: Debraj Manna
Дата:
Сообщение: How to install pgstattuple extension in postgres 10.6?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: are there any expectations about pg indexes having prefixcompression?