X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CD9C8544EE for ; Mon, 7 Mar 2005 23:35:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42018-10 for ; Mon, 7 Mar 2005 23:35:58 +0000 (GMT) Received: from mx100.technologyservicesmanagementgroup.com (mx100.technologyservicesmanagementgroup.com [66.193.36.26]) by svr1.postgresql.org (Postfix) with ESMTP id 3842D56407 for ; Mon, 7 Mar 2005 23:35:54 +0000 (GMT) Received: from mail.mailporter.net (mail.mailporter.net [66.193.36.114]) by mx100.technologyservicesmanagementgroup.com (Postfix) with ESMTP id D4F18280A5 for ; Mon, 7 Mar 2005 15:35:51 -0800 (PST) Received: from [207.114.230.7] [207.114.230.7] by mail.mailporter.net with ESMTP (SMTPD32-8.13) id A558C1CF013E; Mon, 07 Mar 2005 15:35:52 -0800 Message-ID: <422CE553.5060605@mailporter.net> Date: Mon, 07 Mar 2005 15:35:47 -0800 From: "Roderick A. Anderson" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PostgreSQL not reading postgresql.conf file Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Declude-Sender: raa@mailporter.net [207.114.230.7] X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/101 X-Sequence-Number: 16599 Or at least it seems that way. I have Pg 8.0.1 from the PGDG RPMs installed in a Linux-Vserver ( which I have used before with Pg 7.2 and 7.3 ). I have changed the postgresql.conf file and added/modified the listen_addresses to the Vserver's IP. In pgstartup.log I always see these lines after every restart. LOG: could not bind IPv4 socket: Cannot assign requested address HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. WARNING: could not create listen socket for "localhost" LOG: logger shutting down LOG: could not bind IPv4 socket: Cannot assign requested address HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. WARNING: could not create listen socket for "localhost" LOG: logger shutting down LOG: could not bind IPv4 socket: Cannot assign requested address HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. WARNING: could not create listen socket for "localhost" There were(/are) some issues with localhost ( 127.0.0.1 ) and Linux-Vservers but I have got around them before. I just can't remember what I did. ( Good case of needing to do better documentation on my part. :-) The funny thing is the postmaster seems to be running ps aux gives me postgres 7680 0.1 0.5 16708 3036 ? S 14:49 0:02 /usr/bin/postmast postgres 7684 0.0 0.3 6592 1984 ? S 14:49 0:00 postgres: logger postgres 7686 0.0 0.5 16708 3084 ? S 14:49 0:00 postgres: writer I've looked through the /etc/init.d/postgresql file and don't see anything _odd_ so it's probably a head-space issue on my part. Clue sticks anyone? TIA, Rod -- --- [This E-mail scanned for viruses by Declude Virus]