create extension tablefunc;

vagrant ssh
sudo su - postgres

postgres@postgresql:~$ psql -h localhost -U postgres -d vic -c 'create extension tablefunc'
Password for user postgres:
psql: FATAL:  password authentication failed for user "postgres"

-h localhost...