Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Tom Lane) writes:
>> What I'm tempted to do is add this to pg_getaddrinfo_all (in
>> src/backend/libpq/ip.c):
>> ...
> That seems to work fine, too. And that seems somewhat more
> portable/elegant/something.
OK, patch applied as far b
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> Is there a more elegant way of setting the requested port to 0 than my
>> 2-liner?
>
> What I'm tempted to do is add this to pg_getaddrinfo_all (in
> src/backend/libpq/ip.c):
>
> {
> /* not all versions of ge
Chris Browne <[EMAIL PROTECTED]> writes:
> Is there a more elegant way of setting the requested port to 0 than my
> 2-liner?
What I'm tempted to do is add this to pg_getaddrinfo_all (in
src/backend/libpq/ip.c):
{
/* not all versions of getaddrinfo() zero *result on failure */
*r
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] (Tom Lane) writes:
>>> Chris Browne <[EMAIL PROTECTED]> writes:
(gdb) print addr->ai_addr->sa_data
$18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>>>
>>> Hmm, that looks a b
[EMAIL PROTECTED] (Tom Lane) writes:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
>> On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
>>> Also, do regular connections to this postmaster work across TCP/IP?
>>> If getaddrinfo() is broken I'd expect there to be problems binding
>>> to the postmast
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Tom Lane) writes:
>> Chris Browne <[EMAIL PROTECTED]> writes:
>>> (gdb) print addr->ai_addr->sa_data
>>> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>>
>> Hmm, that looks a bit odd --- what's the full declaration of str
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> (gdb) print addr->ai_addr->sa_data
>> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>
> Hmm, that looks a bit odd --- what's the full declaration of structs
> sockaddr and sockaddr_in on that machine?
Chris Browne <[EMAIL PROTECTED]> writes:
> (gdb) print addr->ai_addr->sa_data
> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
Hmm, that looks a bit odd --- what's the full declaration of structs
sockaddr and sockaddr_in on that machine?
regards, tom lane
--
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
>> Also, do regular connections to this postmaster work across TCP/IP?
>> If getaddrinfo() is broken I'd expect there to be problems binding
>> to the postmaster's listen socket too ...
> Yes, TCP/IP co
[EMAIL PROTECTED] (Tom Lane) writes:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
>> On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
>>> Would you try strace'ing postmaster start to see what gets passed to the
>>> socket() and bind() calls just before this message comes out?
>
>> Here is the rel
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> >> Would you try strace'ing postmaster start to see what gets passed to the
> >> socket() and bind() calls just before this message comes out?
>
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
>> Would you try strace'ing postmaster start to see what gets passed to the
>> socket() and bind() calls just before this message comes out?
> Here is the relative output from truss.
> socket(2, 2, 0)
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> >> That's bizarre. What error conditions does your man page for bind(2)
> >> document as yielding EACCES? The only one mentioned on my systems i
Brad Nicholson <[EMAIL PROTECTED]> writes:
> On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
>> That's bizarre. What error conditions does your man page for bind(2)
>> document as yielding EACCES? The only one mentioned on my systems is
>> "protected address", but we aren't requesting a reserv
I just had this problem last night my local firewall was blocking
connections on the loopback interface.
On Wed, 18 Oct 2006, Brad Nicholson wrote:
Can someone please provide a bit of information where the following
error is coming from? This is PG 8.1.3 on AIX 5.3
LOG: could not bind s
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
> > Can someone please provide a bit of information where the following
> > error is coming from? This is PG 8.1.3 on AIX 5.3
>
> > LOG: could not bind socket for statistics collector: Permission deni
Brad Nicholson <[EMAIL PROTECTED]> writes:
> Can someone please provide a bit of information where the following
> error is coming from? This is PG 8.1.3 on AIX 5.3
> LOG: could not bind socket for statistics collector: Permission denied
That's bizarre. What error conditions does your man page
Can someone please provide a bit of information where the following
error is coming from? This is PG 8.1.3 on AIX 5.3
LOG: could not bind socket for statistics collector: Permission denied
LOG: disabling statistics collector for lack of working socket
What exactly does the PG user not have app
18 matches
Mail list logo