Thread: Postgresql Server is not starting during it's installation
Hello Sir, During the installation of "Postgresql Database Server" when I am tring execute the command "/usr/local/pgsql/bin/postgres-D /usr/local/pgsql/data" it shows an error message: LOG: could not translate host name "localhost", service "5432" to address: Name or service not known WARNING: could not create listen socket for "localhost" FATAL: could not create any TCP/IP sockets Now I am in a great trouble. You please send me the necessary steps to rectify that problem. I am waiting for your reply. With regards, Ankur Sahu, Software Engineer. ___________________________________ IIT Kharagpur, http://www.iitkgp.ac.in
On 9/18/07, ankur@adm.iitkgp.ernet.in <ankur@adm.iitkgp.ernet.in> wrote: > Hello Sir, > During the installation of "Postgresql Database Server" when I am tring execute the command "/usr/local/pgsql/bin/postgres-D /usr/local/pgsql/data" it shows an error message: > LOG: could not translate host name "localhost", service "5432" to address: Name or service not known > WARNING: could not create listen socket for "localhost" > FATAL: could not create any TCP/IP sockets > Now I am in a great trouble. You please send me the necessary steps to rectify that problem. I am waiting for your reply. I think we need more information to help out. What OS, what pg version, and also, what were the events leading up to this point.
On 9/18/07, Ankur <ankur@adm.iitkgp.ernet.in> wrote: > Sir, > Thanks for your reply. I am giving you the necessary information. I am > using Red Hat Enterprise Linux AS (Version 3 Update 9). Postgresql version > is 8.2.4. When I am initializing the database server by executing the > command "$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data" it shows > successful message. But after that when I am trying to start the database > server by executing the command "$ /usr/local/pgsql/bin/postgres -D > /usr/local/pgsql/data" it generates an error message like: > LOG: could not translate host name "localhost", service "5432" to > address: Name or service not known > WARNING: could not create listen socket for "localhost" > FATAL: could not create any TCP/IP sockets > > Sir, please tell me the required steps to rectify that problem. I am waiting > for your reply. Please keep threads on the list, others might benefit from this, and someone else might have a better answer than me. Looks like you've already got something listening on that port. do ps ax|grep postgres and see what pops up.