sábado, 4 de julho de 2015

Instalação do PostgreSQL 9.4

Instalando os Repositórios

Debian (Squeeze) 6.x

Create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main

Debian (Wheezy) 7.x

Create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main

Debian (Jessie) 8.x

Create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main

Importar a chave de assinatura do repositório, e atualizar as listas de pacotes

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

Instalação

Para instalar o PostgreSQL em Debian , use o apt- get ( ou outro apt- condução) de comando

# apt-get install postgresql-9.4

O repositório contém muitos pacotes diferentes, incluindo addons de terceiros. Maioria pacotes de comando e importantes são ( substitua o número da versão , se necessário) :
  • postgresql-client-9.4 - client libraries and client binaries
  • postgresql-9.4 - core database server
  • postgresql-contrib-9.4 - additional supplied modules
  • libpq-dev - libraries and headers for C language frontend development
  • postgresql-server-dev-9.4 - libraries and headers for C language backend development
  • pgadmin3 - pgAdmin III graphical administration utility