[Solved] I'm Getting An Error Trying To Connect To A Postgresql Database

[kamesenin]

This is the error:

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "inmobiliaria", SSL off in /home/inver/public_html/inmobiliaria/consulta.php on line 12

This is the file that connects to the database. Although locally it works.

<?php

/*Conexion a la base de datos*/

$user = "inver_inverdata";
$password = "*******";
$dbname = "inver_inmobiliaria";
$port = "5432";
$host = "localhost";

$cadenaConexion = "host=$host port=$port dbname=$dbname user=$user password=$password";

$conexion = pg_connect($cadenaConexion) or die("Error en la Conexión: ".pg_last_error());


 
/*$query = "select id, usuario, contrasenia from usuario";

$resultado = pg_query($conexion, $query) or die("Error en la Consulta SQL");
*/



?>

[Krydos]

Does it work now?

[Luigi123]

Moved to Customer Service.

[kamesenin]

  On 5/3/2017 at 2:36 PM, Krydos said:

Does it work now?

Yes it does!, thanks!