Skip site navigation (1) Skip section navigation (2)

Configuración de Postgres en un Server de Hosting

From: Luis Alberto Vargas Miranda <luis(dot)vargasm(at)hotmail(dot)com>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Configuración de Postgres en un Server de Hosting
Date: 2008-05-26 04:35:03
Message-ID: BAY140-W487BE5A466469AA3D0DBE29FC20@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Estimados
 
Actualmente estoy en un Proyecto para un Cliente, el cual no tiene un Servidor, y debido a que la aplicación que desarrollaremos está en PHP, este Cliente optó por alquilar un Hosting. Este Hosting es el tipico que se contrata para webs. Bueno el tema despues de instalar Postgres, deseo conectarme desde PgAdmin y me da el siguiente error que aun no he podido solucionar:
 
Access to database deniedThe server doesn't grant access to the database: the server reports FATAL: no pg_hba.conf entry for host "200.37.126.89", user "ats_postgres", database "postgres", SSL off To access a database on a PostgreSQL server, you first have to grant primary access to the server for your client (Host Based Authentication). PostgreSQL will check the pg_hba.conf file if a pattern that matches your client address / username / database is present and enabled before any SQL GRANT access control lists are evaluated. The initial settings in pg_hba.conf are quite restrictive, in order to avoid unwanted security holes caused by unreviewed but mandatory system settings. You'll probably want to add something like host all all 192.168.0.0/24 md5 This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24. You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process.
Gracias de antemano! Saludos!

Atentamente
Luis Alberto Vargas Miranda
----------------------------------------------
luis(dot)vargasm(at)hotmail(dot)com


(51) (54) - 9690757 (Movistar)

(51) (54) - 9122312 (Claro)

(51) (1) - 94001131 (Nextel)

(51*400*1131) (Nextel Conexión Directa)
----------------------------------------------
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

Responses

pgsql-es-ayuda by date

Next:From: Crispin T.Date: 2008-05-26 06:29:21
Subject: almacenar en bd o no?
Previous:From: Gabriel Hermes Colina ZambraDate: 2008-05-26 04:08:49
Subject: Re: Necesito orientacion en servidor postgresql en servidor DELL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group