Instalacion Postgres
-
Upload
ragmyl -
Category
Technology
-
view
2.905 -
download
0
description
Transcript of Instalacion Postgres
![Page 1: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/1.jpg)
Aplicaciones > Accesorios > Terminal de <<Root>>
![Page 2: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/2.jpg)
Contraseña Administrativa
![Page 3: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/3.jpg)
![Page 4: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/4.jpg)
![Page 5: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/5.jpg)
![Page 6: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/6.jpg)
aptitude search postgres (busca todos los paquetes que tenga relación con la palabra postgres)
![Page 7: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/7.jpg)
![Page 8: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/8.jpg)
aptitude install postgresql-8.3 postgresql-client
![Page 9: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/9.jpg)
![Page 10: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/10.jpg)
![Page 11: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/11.jpg)
![Page 12: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/12.jpg)
sudo passwd postgres (actualización de la contraseña del postgres)
![Page 13: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/13.jpg)
![Page 14: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/14.jpg)
sudo su postgres -c "psql template1" (Entrada via consola al postgres)
![Page 15: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/15.jpg)
![Page 16: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/16.jpg)
ALTER USER postgres WITH PASSWORD 'nueva_contraseña'; (cambiamos la contraseña del usuario postgres)
![Page 17: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/17.jpg)
\q (comando para salir del postgres)
![Page 18: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/18.jpg)
sudo gedit /etc/postgresql/8.3/main/postgresql.conf (editamos el archivo de configuración)
![Page 19: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/19.jpg)
![Page 20: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/20.jpg)
![Page 21: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/21.jpg)
listen_addresses = '*' (Descomentamos la linea y colocamos *
para recibir conexiones externas)
![Page 22: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/22.jpg)
![Page 23: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/23.jpg)
password_encryption = on (Descomentamos y
guardamos)
![Page 24: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/24.jpg)
/etc/init.d/postgresql-8.3 restart (Reiniciamos el servidor postgres)
![Page 25: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/25.jpg)
![Page 26: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/26.jpg)
su postgres -c "psql template1"
![Page 27: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/27.jpg)
\l (muestra la lista de bases de datos)
![Page 28: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/28.jpg)
![Page 29: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/29.jpg)
aptitude install php5-pgsql
![Page 30: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/30.jpg)
![Page 31: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/31.jpg)
/etc/init.d/apache2 restart (Reiniciamos el servidor Apache)
![Page 32: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/32.jpg)
Entramos Navegador
![Page 33: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/33.jpg)
http://phppgadmin.sourceforge.net/
![Page 34: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/34.jpg)
Download
![Page 35: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/35.jpg)
(Se descarga el archivo)
![Page 36: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/36.jpg)
Se descomprime
![Page 37: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/37.jpg)
Se mueve a la carpeta de /var/www/
![Page 38: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/38.jpg)
gedit /var/www/phpPgAdmin-4.2.2/conf/config.inc.php
![Page 39: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/39.jpg)
![Page 40: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/40.jpg)
![Page 41: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/41.jpg)
cambiamos md5 por trust
![Page 42: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/42.jpg)
gedit /etc/postgresql/8.3/main/postgresql.conf
![Page 43: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/43.jpg)
![Page 44: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/44.jpg)
$conf[‘extra_login_security’]=true;
![Page 45: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/45.jpg)
$conf[‘extra_login_security’]=false;
![Page 46: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/46.jpg)
$conf[‘servers’][0][‘host’]= ‘’;
![Page 47: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/47.jpg)
$conf[‘servers’][0][‘host’]= ‘localhost’;
![Page 48: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/48.jpg)
Entramos al phpPgAdmin
![Page 49: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/49.jpg)
logearse con el usuario de postgres
![Page 50: Instalacion Postgres](https://reader036.fdocuments.co/reader036/viewer/2022081413/5469f0e3af7959653c8b683e/html5/thumbnails/50.jpg)