Thread: PLEASE HELP ME

 

Hello sir
actually i am working with Qt using postgresql i have to get connection
{(database("trainee"),user("trainee"))}
from the network (database remote accessing) so i have configured

postgresql.conf and pg_hba.conf upto some extents

the fields that i  have configured r as follows even then

while connecting by giving any address (even localhost) it flashes error

no pg_hba.conf entry for host 127.0.0.1 user"trainee" database "trainee"
SSL off
QPSQL:Unable to connect

in pg_hba.conf

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
local  all    all            ident  sameuser
#local  all    all            127.0.0.1  sameuser
only this entry i have made

in postgresql.conf

# - Connection Settings -

tcpip_socket = true
max_connections = 100
    # note: increasing max_connections costs about 500 bytes of shared
    # memory per connection slot, in addition to costs from shared_buffers
        # and max_locks_per_transaction.
superuser_reserved_connections = 2
#port = 5432
#unix_socket_directory = '/home/trainee/trainee'
#unix_socket_group = 'trainee'


#authentication_timeout = 60    # 1-600, in seconds
#ssl =true

if i do ssl true active then even ir is not giving psql prompt


please help me i am in trouble

On Apr 21, 2005, at 1:22 AM, amit kumar awasthi wrote:

>  # Using sockets credentials for improved security. Not available
> everywhere,
>  # but works on Linux, *BSD (and probably some others)
>  local  all    all            ident  sameuser
>  #local  all    all            127.0.0.1  sameuser
>  only this entry i have made
>
>


local is for unix domain sockets. You need a setting for host to enable
TCP/IP connections via 127.0.0.1. Something like:

host    all         all         127.0.0.1         255.255.255.255
ident

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL