How to configure postgresql to accept TCP/IP connections

Поиск
Список
Период
Сортировка
От amit kumar awasthi
Тема How to configure postgresql to accept TCP/IP connections
Дата
Msg-id 20050420123147.22620.qmail@webmail28.rediffmail.com
обсуждение исходный текст
Список pgsql-sql
<p>   <br /> Hello sir <br /> actually i am working with Qt using postgresql i have to get connection <br />
{(database("trainee"),user("trainee"))}<br/> from the network (database remote accessing) so i have configured<br /><br
/>postgresql.conf and pg_hba.conf upto some extents<br /><br /> the fields that i  have configured r as follows even
then<br /><br /> while connecting by giving any address (even localhost) it flashes error<br /><br /> no pg_hba.conf
entryfor host 127.0.0.1 user"trainee" database "trainee"<br /> SSL off <br /> QPSQL:Unable to connect<br /><br /> in
pg_hba.conf<br/><br /> # Using sockets credentials for improved security. Not available everywhere,<br /> # but works
onLinux, *BSD (and probably some others)<br /> local  all    all            ident  sameuser<br /> #local  all    all   
       127.0.0.1  sameuser<br /> only this entry i have made<br /><br /> in postgresql.conf<br /><br /> # - Connection
Settings-<br /><br /> tcpip_socket = true<br /> max_connections = 100<br />      # note: increasing max_connections
costsabout 500 bytes of shared<br />      # memory per connection slot, in addition to costs from shared_buffers<br />
       # and max_locks_per_transaction.<br /> superuser_reserved_connections = 2<br /> #port = 5432<br />
#unix_socket_directory= '/home/trainee/trainee'<br /> #unix_socket_group = 'trainee'<br /><br /><br />
#authentication_timeout= 60     # 1-600, in seconds<br /> #ssl =true<br /><br /> if i do ssl true active then even ir
isnot giving psql prompt<br /><br /><br /> please help me i am in trouble<br /><br /><br /><a
href="http://clients.rediff.com/signature/track_sig.asp"target="_blank"><img border="0" hspace="0"
src="http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/inbox.htm@Bottom"vspace="0" /></a> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Mauro Bertoli
Дата:
Сообщение: php wrapper
Следующее
От: Kai Hessing
Дата:
Сообщение: Re: can a function return a virtual table?