instalar xubuntu+postgresql+pgadmin

wget -O -- http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc > ok.key

 sudo apt-key add ok.key

 

http://www.ubuntugeek.com/how-to-install-postgresql-9-2-on-ubuntu-13-04-server.html

 

 

recovery postgres password http://www.netstorming.com.ar/2009/10/15/resetear-password-de-root-en-postgresql/

Installing PostgreSQL 9.1 on Ubuntu 10.04

27 Replies

PostgreSQL 9.0 final was released on 2010/09/20 which I’ve been waiting for to begin playing with it and evaluating it. The mainline Ubuntu Lucid apt repositories only have 8.4. According to the package maintainer, Martin Pitt, the postgresql-9.0 package won’t be added until Ubuntu Natty. Thankfully, he setup a backports repo for Ubuntu that we can pull from.

This is a very quick and painless process. If you have not done so already, make your life easier by installing python-software-properties:

sudo apt-get install python-software-properties

Next up is adding the backports repo and updating apt:

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update

UPDATE: In the comments, Jason Froebe points out that if you already have an earlier version of PostgreSQL installed, you can just upgrade it:

sudo apt-get upgrade

Finally install postgresql-9.1:

sudo apt-get install postgresql-9.1 libpq-dev
The libpq-dev package is for compiling wrappers/clients against libpq.

There you’re done!