DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=uIbG+HEGcBLbY8E8F4OxS1wikUJQVO+clM1YqIQL4wxUy5r+pNuhYfLUBe1ChV6eG6
	bEzf82mkPXXjnkN/Fk7BR1VJob3O1c4uU+KIj9MAYckxn5RpX+/OWMHiB8mUFoWeIF1t
	5bn6K90exmXHYbkR6NzBju07Ji63SVJpTnUnc=
Message-ID: <4BDEC707.1090403@gmail.com>
Date: Mon, 03 May 2010 14:52:23 +0200
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: "Dai, Tino" <tdai@loc.gov>
CC: "Daniel J. Summers" <daniel.lists@djs-consulting.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
References: <4BDE46F4.4070401@djs-consulting.com>
	<1CA7FF980DA3824F9A5C31532B7A40DCCDCE01FD@LCXCLMB01.LCDS.LOC.GOV>
In-Reply-To: <1CA7FF980DA3824F9A5C31532B7A40DCCDCE01FD@LCXCLMB01.LCDS.LOC.GOV>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Maybe SElinux is in the way?

Dai, Tino wrote:
> Couple of things to try:
>
> - The default process is not postmaster any more, rather is it postgres:
>
> http://www.postgresql.org/docs/8.4/interactive/server-start.html
>
> - Try manually starting up the postgres with the debug cranked all the way up, see what that gives you in the server logs
>
> - Perhaps try moving the port to somewhere else with the postgres command
>
> HTH,
> Tino
>
> ________________________________________
> From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] On Behalf Of Daniel J. Summers [daniel.lists@djs-consulting.com]
> Sent: Sunday, May 02, 2010 11:45 PM
> To: Dai, Tino; pgsql-admin@postgresql.org
> Subject: [ADMIN] Ubuntu 10.04 - Cannot Create TCP/IP Sockets
>
> Good evening.
>
> I've recently provisioned a new Ubuntu 10.04 server.  I ran "apt-get
> install postgresql-8.4", just like I normally do when I'm setting up a
> new server.  However, this time I got an error about an inability to
> create TCP/IP sockets.  The full error is below.
>
>   * Starting PostgreSQL 8.4 database server
>   * The PostgreSQL server failed to start. Please check the log output:
> 2010-05-03 03:36:06 UTC LOG:  could not bind IPv4 socket: Cannot assign
> requested address
> 2010-05-03 03:36:06 UTC HINT:  Is another postmaster already running on
> port 5432? If not, wait a few seconds and retry.
> 2010-05-03 03:36:06 UTC WARNING:  could not create listen socket for
> "localhost"
> 2010-05-03 03:36:06 UTC FATAL:  could not create any TCP/IP sockets
>
> However, there is nothing on port 5432...
>
> root@coolnewserver:~# netstat -l
> Active Internet connections (only servers)
> Proto Recv-Q Send-Q Local Address           Foreign Address         State
> tcp        0      0 *:ssh                   *:*                     LISTEN
> tcp        0      0 localhost:smtp          *:*                     LISTEN
> tcp6       0      0 [::]:ssh                [::]:*                  LISTEN
>
> ..and no postgresql processes...
>
> root@coolnewserver:~# ps -ef | grep postgresql
> root      7738  3403  0 03:37 pts/0    00:00:00 grep --color=auto postgresql
> root@coolnewserver:~# ps -ef | grep postmaster
> root      7740  3403  0 03:37 pts/0    00:00:00 grep --color=auto postmaster
>
> Possibly pertinent lines from /etc/postgresql/8.4/main/postgresql.conf...
>
> listen_addresses = 'localhost'
> port = 5432
> max_connections = 100
> unix_socket_directory = '/var/run/postgresql'
>
> ..permissions on that last directory are...
>
> drwxrwsr-x 2 postgres postgres   40 2010-05-03 03:10 postgresql
>
> ..and localhost is resolving...
>
> root@coolnewserver:~# nslookup localhost
> Server:        [IP]
> Address:    [IP]#53
>
> Name:    localhost
> Address: 127.0.0.1
>
> Using search engines, I've seen this error, and my question, asked on
> occasion; what I didn't find was what the actual solution was.  Anyone
> remember?  I'll be sure to post what I find, so that maybe others can
> benefit a few years from now.  :)
>
> Thanks...
>
>
> Daniel
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>