Intro Postgreql

Primeros pasos

http://www.postgresql.org.es/documentacion sudo apt-get install postgresql pgadmin3 sudo -u postgres psql /password   postgres=# alter user postgres with password 'nueva contraseña';

Creación de usuario, tabla y extensiones

 sudo -u postgres createuser myusername
 Shall the new role be a superuser? (y/n) y
 
 createdb book
 
 psql book -c "CREATE EXTENSION tablefunc" 
 ERROR:  could not open extension control file "/usr/share/postgresql/9.1/extension/tablefunc.control": No such file or directory
 
 sudo apt-get install postgresql-contrib 
 
 psql book -c "CREATE EXTENSION tablefunc" 
 psql book -c "CREATE EXTENSION fuzzystrmatch" 
 psql book -c "CREATE EXTENSION pg_trgm" 
 psql book -c "CREATE EXTENSION cube" 
 psql book -c "CREATE EXTENSION dict_xsyn"

Configuración postgresql

• http://tubasededatoslibre.org/site/instalacion-de-postgresql-en-debian-gnulinux-squeeze/

Postgresql 9 en Ubuntu

$sudo nano /etc/apt/sources.list 
 
  deb http://ppa.launchpad.net/pitti/postgresql/ubuntu precise main 
  deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu precise main 
 
 
$sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys 8683D8A2 
$sudo apt-get update 
 
$sudo apt-get install postgresql pgadmin3