Alex Balashov wrote: > It does not appear that you have PostgreSQL set up to listen on a TCP > socket, but only UNIX domain socket. You have this line commented out: > > #listen_addresses = 'localhost' > > It is required in order to listen on TCP. You should uncomment it: > > listen_addresses = '127.0.0.1'
Changes to postgresql.conf generally require a restart pf PostgreSQL to take affect. How to do this will depend on the (Linux) distribution you're running and/or how you installed PostgreSQL. And as Alex points out : > In any case, this is not within the general purview of the list. \\||/ Rod -- > [email protected] wrote: > >> i have installed database *postgresql* for storing call details. when i >> restart database i get the error. >> >> [*r...@localhost server]# psql -h 127.0.0.1 -U asterisk Password >> psql: could not connect to server: Connection refused >> Is the server running on host "127.0.0.1" and accepting >> TCP/IP connections on port 5432?* >> >> >> >> *this is my /var/lib/pgsql/data/postgresql.conf* >> >> *# CONNECTIONS AND AUTHENTICATION >> #--------------------------------------------------------------------------- >> >> # - Connection Settings - >> >> #listen_addresses = 'localhost' # what IP address(es) to listen on; >> # comma-separated list of addresses; >> # defaults to 'localhost', '*' = all >> port = 5432 >> max_connections = 100 >> # note: increasing max_connections costs ~400 bytes of shared memory per >> # connection slot, plus lock space (see max_locks_per_transaction). You >> # might also need to raise shared_buffers to support more connections. >> #superuser_reserved_connections = 2 >> #unix_socket_directory = '' >> #unix_socket_group = '' >> #unix_socket_permissions = 0777 # octal >> #bonjour_name = '' # defaults to the computer* >> >> >> >> >> >> asterisk is not able to make TCP/Ip connection. plz guide me where i am >> doing wrong. >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
