Comments on How to Install Postgresql and phpPgAdmin on Ubuntu 15.04

PostgreSQL is a powerfull object-relational Database released under a OpenSource BSD-style license. PostgreSQL is well suited for large databases and has many advanced features, so it positions itself in the enterprise database segment. This tutorial will show the installation of PostgreSQL and its web based administration interface phpPgAdmin on Ubuntu 15.04.

6 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: jura12
Reply  

thanks

By: Ruben Cardenas
Reply  

Thanks, it helps me a lot

By: Efren Hdez
Reply  

I am have a connection error with php

/****************CONNECTION PHP************************/

$user = 'postgres';$passwd = 'efren';$db = 'pruebaphp';$port = 5432;$host = 'localhost';$strCnx = "host=$host port=$port dbname=$db user=$user password=$passwd";$cnx = pg_connect($strCnx) or die ("connection error. ". pg_last_error());echo "Connection succefull

";

/*******************Configuration fil****************/

/etc/postgresql/9.4/main/pg_hba.conf

 

# Database administrative login by Unix domain socketlocal   all             postgres                                md5# TYPE  DATABASE        USER            ADDRESS                 METHOD# "local" is for Unix domain socket connections onlylocal   all             all                                     md5# IPv4 local connections:host    all             all             localhost               md5# IPv6 local connections:host    all             all             ::1/128                 md5

 

 

 

By: Krys
Reply  

Great tutorial, works fine. Thanks

By: arvind
Reply  

psql command is not working....gives the error  :

psql: could not connect to server: No such file or directory    Is the server running locally and accepting    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

By: Hugo Gonzalez
Reply  

Thank you, very useful. It is a good start for me. I am Manager Oracle Database and this helps me supplement . I am very interested Free Software. This is very simple and based on this construire more and more experience. Thank you so much Regards,

Hugo gonzalez

Caracas, Venezuela.