Postgresql – How to install pgstattuple extension in postgres 10.6

postgresql

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 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/pgstattuple--1.4.sql

Best Answer

CREATE EXTENSION — loads a new extension into the current database.

So, you could do something like:

CREATE EXTENSION pgstattuple;

Related Solutions

Postgresql – What’s the default superuser username/password for postgres after a new install

CAUTION The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be DANGEROUS!

This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system.

What you should do is follow Chris James's answer:

sudo -u postgres psql postgres

# \password postgres

Enter new password:

To explain it a little bit. There are usually two default ways to login to PostgreSQL server:

By running the "psql" command as a UNIX user (so-called IDENT/PEER authentication), e.g.: sudo -u postgres psql. Note that sudo -u does NOT unlock the UNIX user.
by TCP/IP connection using PostgreSQL's own managed username/password (so-called TCP authentication) (i.e., NOT the UNIX password).

So you never want to set the password for UNIX account "postgres". Leave it locked as it is by default.

Of course things can change if you configure it differently from the default setting. For example, one could sync the PostgreSQL password with UNIX password and only allow local logins. That would be beyond the scope of this question.

Ubuntu – installing postgres on ubuntu package not available

In Ubuntu official repositories only PostgreSQL 9.1 is available. That is why it couldn't be found.

In order to get PostgreSQL v9.2 in your VPS using apt you should follow the official PostgreSQL procedure for Ubuntu found here

It consists of adding PostgreSQL official repository as one of your repository source

Create the file /etc/apt/sources.list.d/pgdg.list
Insert this line deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
Import the repository signing key wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
Refresh your repositories cache sudo apt-get update

Now you can simply do sudo apt-get install postgresql-9.2

Best Answer

Related Solutions

Postgresql – What’s the default superuser username/password for postgres after a new install

Ubuntu – installing postgres on ubuntu package not available

Related Topic