Não é possível instalar o PostgreSQL 9.2 no Linux Mint

Question

Sou novo em sistemas Linux. Eu tentei instalar o PostgreSQL 9.2. Eu fiz o seguinte:

sudo apt-get update
sudo apt-get -y install python-software-properties
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update

sudo apt-get -y install postgresql-9.2 postgresql-client-9.2 postgresql-contrib-9.2

Mas diz que não pode encontrar os pacotes. Eu li alguns tutoriais e em todos os lugares foi escrito que eu preciso usar o repositório ppa:pitti/postgresql .

O que há de errado?

UPDATE1

Instalei com sucesso os pacotes da resposta do @slm, mas não consigo iniciar o postgres. Quando tento psql , obtenho:

Command psql can be found in packages:
 * postgresql-client-common
 * postgres-xc-client

Além disso, não vejo o arquivo /etc/init.d/postgresql .

UPDATE2

$ dpkg -L postgresql-contrib-9.2
/.
/usr
/usr/lib
/usr/lib/postgresql
/usr/lib/postgresql/9.2
/usr/lib/postgresql/9.2/lib
/usr/lib/postgresql/9.2/lib/test_parser.so
/usr/lib/postgresql/9.2/lib/btree_gist.so
/usr/lib/postgresql/9.2/lib/pgstattuple.so
/usr/lib/postgresql/9.2/lib/pg_buffercache.so
/usr/lib/postgresql/9.2/lib/cube.so
/usr/lib/postgresql/9.2/lib/unaccent.so
/usr/lib/postgresql/9.2/lib/earthdistance.so
/usr/lib/postgresql/9.2/lib/pgrowlocks.so
/usr/lib/postgresql/9.2/lib/insert_username.so
/usr/lib/postgresql/9.2/lib/moddatetime.so
/usr/lib/postgresql/9.2/lib/isn.so
 /usr/lib/postgresql/9.2/lib/lo.so
/usr/lib/postgresql/9.2/lib/chkpass.so
/usr/lib/postgresql/9.2/lib/passwordcheck.so
/usr/lib/postgresql/9.2/lib/pg_freespacemap.so
/usr/lib/postgresql/9.2/lib/auth_delay.so
/usr/lib/postgresql/9.2/lib/pgcrypto.so
/usr/lib/postgresql/9.2/lib/pgxml.so
/usr/lib/postgresql/9.2/lib/btree_gin.so
/usr/lib/postgresql/9.2/lib/seg.so
/usr/lib/postgresql/9.2/lib/tcn.so
/usr/lib/postgresql/9.2/lib/auto_explain.so
/usr/lib/postgresql/9.2/lib/file_fdw.so
/usr/lib/postgresql/9.2/lib/uuid-ossp.so
/usr/lib/postgresql/9.2/lib/refint.so
/usr/lib/postgresql/9.2/lib/dict_int.so
/usr/lib/postgresql/9.2/lib/ltree.so
/usr/lib/postgresql/9.2/lib/tablefunc.so
/usr/lib/postgresql/9.2/lib/dummy_seclabel.so
/usr/lib/postgresql/9.2/lib/dict_xsyn.so
/usr/lib/postgresql/9.2/lib/adminpack.so
/usr/lib/postgresql/9.2/lib/fuzzystrmatch.so
/usr/lib/postgresql/9.2/lib/pg_trgm.so
/usr/lib/postgresql/9.2/lib/pg_stat_statements.so
/usr/lib/postgresql/9.2/lib/autoinc.so
/usr/lib/postgresql/9.2/lib/timetravel.so
/usr/lib/postgresql/9.2/lib/dblink.so
/usr/lib/postgresql/9.2/lib/sslinfo.so
/usr/lib/postgresql/9.2/lib/_int.so
/usr/lib/postgresql/9.2/lib/hstore.so
/usr/lib/postgresql/9.2/lib/pageinspect.so
/usr/lib/postgresql/9.2/lib/citext.so
/usr/lib/postgresql/9.2/bin
/usr/lib/postgresql/9.2/bin/pgbench
/usr/lib/postgresql/9.2/bin/pg_standby
/usr/lib/postgresql/9.2/bin/pg_archivecleanup
/usr/lib/postgresql/9.2/bin/vacuumlo
/usr/lib/postgresql/9.2/bin/pg_test_timing
/usr/lib/postgresql/9.2/bin/pg_test_fsync
/usr/lib/postgresql/9.2/bin/oid2name
/usr/share
/usr/share/doc
/usr/share/doc/postgresql-contrib-9.2
/usr/share/doc/postgresql-contrib-9.2/copyright
/usr/share/doc/postgresql-contrib-9.2/autoinc.example
/usr/share/doc/postgresql-contrib-9.2/changelog.gz
 /usr/share/doc/postgresql-contrib-9.2/changelog.Debian.gz
/usr/share/doc/postgresql-contrib-9.2/moddatetime.example
/usr/share/doc/postgresql-contrib-9.2/refint.example
/usr/share/doc/postgresql-contrib-9.2/insert_username.example
/usr/share/doc/postgresql-contrib-9.2/timetravel.example
 /usr/share/postgresql
/usr/share/postgresql/9.2
/usr/share/postgresql/9.2/extension
/usr/share/postgresql/9.2/extension/pgstattuple.control
/usr/share/postgresql/9.2/extension/uuid-ossp.control
/usr/share/postgresql/9.2/extension/dblink--1.0.sql
/usr/share/postgresql/9.2/extension/dblink.control
/usr/share/postgresql/9.2/extension/timetravel.control
/usr/share/postgresql/9.2/extension/citext.control
/usr/share/postgresql/9.2/extension/xml2--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/isn.control
/usr/share/postgresql/9.2/extension/pageinspect.control
/usr/share/postgresql/9.2/extension/intarray.control
/usr/share/postgresql/9.2/extension/insert_username--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/refint--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/seg--1.0.sql
/usr/share/postgresql/9.2/extension/pg_stat_statements.control
/usr/share/postgresql/9.2/extension/tcn--1.0.sql
/usr/share/postgresql/9.2/extension/refint.control
/usr/share/postgresql/9.2/extension/lo--1.0.sql
/usr/share/postgresql/9.2/extension/pageinspect--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/isn--1.0.sql
/usr/share/postgresql/9.2/extension/tablefunc--1.0.sql
/usr/share/postgresql/9.2/extension/test_parser--1.0.sql
/usr/share/postgresql/9.2/extension/sslinfo--unpackaged--1.0.sql
 /usr/share/postgresql/9.2/extension/moddatetime.control
/usr/share/postgresql/9.2/extension/intagg.control
/usr/share/postgresql/9.2/extension/timetravel--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/insert_username.control
/usr/share/postgresql/9.2/extension/hstore--1.0--1.1.sql
/usr/share/postgresql/9.2/extension/moddatetime--1.0.sql
/usr/share/postgresql/9.2/extension/file_fdw--1.0.sql
/usr/share/postgresql/9.2/extension/tsearch2--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pg_freespacemap--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pg_stat_statements--1.0--1.1.sql
/usr/share/postgresql/9.2/extension/isn--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pg_trgm--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/btree_gist--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/earthdistance--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/refint--1.0.sql
/usr/share/postgresql/9.2/extension/btree_gin--1.0.sql
/usr/share/postgresql/9.2/extension/autoinc.control
/usr/share/postgresql/9.2/extension/pgcrypto.control
/usr/share/postgresql/9.2/extension/pg_trgm.control
/usr/share/postgresql/9.2/extension/btree_gin.control
/usr/share/postgresql/9.2/extension/seg.control
/usr/share/postgresql/9.2/extension/pg_trgm--1.0.sql
/usr/share/postgresql/9.2/extension/hstore--1.1.sql
/usr/share/postgresql/9.2/extension/test_parser.control
/usr/share/postgresql/9.2/extension/dict_xsyn--1.0.sql
/usr/share/postgresql/9.2/extension/sslinfo--1.0.sql
/usr/share/postgresql/9.2/extension/tablefunc--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/tcn.control
/usr/share/postgresql/9.2/extension/lo.control
/usr/share/postgresql/9.2/extension/uuid-ossp--1.0.sql
/usr/share/postgresql/9.2/extension/chkpass.control
/usr/share/postgresql/9.2/extension/btree_gin--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/fuzzystrmatch.control
/usr/share/postgresql/9.2/extension/timetravel--1.0.sql
/usr/share/postgresql/9.2/extension/cube--1.0.sql
/usr/share/postgresql/9.2/extension/dblink--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/insert_username--1.0.sql
/usr/share/postgresql/9.2/extension/ltree--1.0.sql
/usr/share/postgresql/9.2/extension/citext--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/ltree--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pgstattuple--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/btree_gist--1.0.sql
/usr/share/postgresql/9.2/extension/dict_xsyn.control
/usr/share/postgresql/9.2/extension/pgcrypto--1.0.sql
/usr/share/postgresql/9.2/extension/uuid-ossp--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pg_buffercache--1.0.sql
/usr/share/postgresql/9.2/extension/unaccent--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/seg--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/file_fdw.control
/usr/share/postgresql/9.2/extension/tsearch2--1.0.sql
/usr/share/postgresql/9.2/extension/fuzzystrmatch--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/lo--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/unaccent--1.0.sql
/usr/share/postgresql/9.2/extension/fuzzystrmatch--1.0.sql
/usr/share/postgresql/9.2/extension/intarray--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/autoinc--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/ltree.control
/usr/share/postgresql/9.2/extension/pg_buffercache--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/cube.control
/usr/share/postgresql/9.2/extension/pgcrypto--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/chkpass--1.0.sql
/usr/share/postgresql/9.2/extension/earthdistance--1.0.sql
/usr/share/postgresql/9.2/extension/pg_stat_statements--1.1.sql
/usr/share/postgresql/9.2/extension/pgrowlocks--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pgrowlocks--1.0.sql
/usr/share/postgresql/9.2/extension/moddatetime--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/unaccent.control
/usr/share/postgresql/9.2/extension/dict_int--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/intarray--1.0.sql
/usr/share/postgresql/9.2/extension/pgstattuple--1.0.sql
/usr/share/postgresql/9.2/extension/pg_freespacemap--1.0.sql
/usr/share/postgresql/9.2/extension/autoinc--1.0.sql
/usr/share/postgresql/9.2/extension/tsearch2.control
/usr/share/postgresql/9.2/extension/test_parser--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/pageinspect--1.0.sql
/usr/share/postgresql/9.2/extension/pg_freespacemap.control
/usr/share/postgresql/9.2/extension/xml2--1.0.sql
/usr/share/postgresql/9.2/extension/citext--1.0.sql
/usr/share/postgresql/9.2/extension/chkpass--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/hstore--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/dict_int--1.0.sql
/usr/share/postgresql/9.2/extension/hstore.control
/usr/share/postgresql/9.2/extension/intagg--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/xml2.control
/usr/share/postgresql/9.2/extension/pgrowlocks.control
/usr/share/postgresql/9.2/extension/sslinfo.control
/usr/share/postgresql/9.2/extension/cube--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/adminpack--1.0.sql
/usr/share/postgresql/9.2/extension/pg_buffercache.control
 /usr/share/postgresql/9.2/extension/pg_stat_statements--unpackaged--1.0.sql
/usr/share/postgresql/9.2/extension/btree_gist.control
/usr/share/postgresql/9.2/extension/intagg--1.0.sql
/usr/share/postgresql/9.2/extension/adminpack.control
/usr/share/postgresql/9.2/extension/dict_int.control
/usr/share/postgresql/9.2/extension/tablefunc.control
/usr/share/postgresql/9.2/extension/earthdistance.control
/usr/share/postgresql/9.2/man
/usr/share/postgresql/9.2/man/man1
/usr/share/postgresql/9.2/man/man1/pg_test_timing.1.gz
/usr/share/postgresql/9.2/man/man1/pg_test_fsync.1.gz
/usr/share/postgresql/9.2/man/man1/pg_standby.1.gz
/usr/share/postgresql/9.2/man/man1/pgbench.1.gz
/usr/share/postgresql/9.2/man/man1/oid2name.1.gz
/usr/share/postgresql/9.2/man/man1/pg_archivecleanup.1.gz
/usr/share/postgresql/9.2/man/man1/vacuumlo.1.gz

    

Answer 1

Você pode experimentar as instruções descritas neste post intituladas: Instale o PostgreSQL mais recente no Linux Mint . Etapas gerais:

1. crie /etc/apt/sources.list.d/pgdg.list contendo:

   deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
   

2. Importe a chave de assinatura do repositório e atualize as listas de pacotes

   $ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
     sudo apt-key add -
   

3. Atualizar índices do repositório

   $ sudo apt-get update
   

4. Instale o postgreSQL (execute todos esses cmds como root)

   $ sudo apt-get install postgresql-9.2
   $ sudo apt-get install postgresql-contrib-9.2
   $ sudo apt-get install pgadmin3
   

Answer 2

Se o psql não estiver funcionando, pode ser que não esteja lá no PATH. Tente fazer um find para o psql e veja se ele está lá.