Re: [HACKERS] [ADMIN] Problem building initdb on sparc10

2006-05-31 Thread Averbukh Stella
Hello Tom,

Thank you for the advice.  I removed pqsignalinquire() method and it
worked just fine.  


Stella Averbukh
_



-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 30, 2006 11:29 AM
To: Averbukh Stella
Cc: pgsql-admin@postgresql.org; pgsql-hackers@postgresql.org; Bruce
Momjian
Subject: Re: [ADMIN] Problem building initdb on sparc10 

Averbukh Stella [EMAIL PROTECTED] writes:
 I'm building postgresQL on Sparc10 and the build goes fine unil
initdb.

 /usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith 
 -Winline -Wendif-labels -fno-strict-aliasing initdb.o 
 -L../../../src/port -lpgport -L../../../src/interfaces/libpq -lpq 
 -L../../../src/port -Wl,-R/postgres/lib -L/lib -L/usr/lib 
 -L/usr/local/lib -L/usr/local/ssl/lib -L/platform/SUNW,Ultra-60/lib
 -L/usr/sfw/lib/sparcv9 -L/usr/sfw/lib/ -L/usr/local/lib/sparcv9 
 -lpgport -lz -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm -o initdb 
 Undefined first referenced symbol in file sigmask 
 ../../../src/interfaces/libpq/libpq.so
 sigblock ../../../src/interfaces/libpq/libpq.so

When did you last successfully build PG on this system?  I'm guessing
you must have been using 7.4 or older, because AFAICS this was broken by
this 8.0 change:

2004-01-08 21:02  momjian

* doc/src/sgml/libpq.sgml, src/backend/nodes/read.c,
src/interfaces/libpq/fe-connect.c,
src/interfaces/libpq/fe-print.c,
src/interfaces/libpq/fe-secure.c,
src/interfaces/libpq/libpq-fe.h,
src/interfaces/libpq/libpq-int.h,
src/interfaces/libpq/pqsignal.c,
src/interfaces/libpq/pqsignal.h: Allow libpq to do thread-safe
SIGPIPE handling.  This allows it to ignore SIGPIPE from send()
in
libpq, but terminate on any other SIGPIPE, unless the user
installs
their own signal handler.

This is a minor fix because the only time you get SIGPIPE from
libpq's send() is when the backend dies.

The code appears to unconditionally assume that sigmask() and sigblock()
exist.  Not a good assumption.

AFAICS pqsignalinquire() isn't even used anywhere (at least not in
HEAD), so the simplest answer may be to remove it rather than try to fix
it.  It's in src/interfaces/libpq/pqsignal.c.

regards, tom lane

__
This e-mail has been scanned by Arbitron's Email Content Service. 
__

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Averbukh Stella
Hi Tom,

Actually I'm building it first time.  The system didn't have prior
versions of postgreSQL installed.  I took postgresql-8.1.3.tar.gz code
distribution.  

I'll try to remove it from the code.

Thanks.

Stella Averbukh
_
Senior Software Lead, Arbitron Inc.
Phone: (410) 312-8387
Fax: (410) 312-8614
e-mail: mailto:[EMAIL PROTECTED]


-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 30, 2006 11:29 AM
To: Averbukh Stella
Cc: pgsql-admin@postgresql.org; pgsql-hackers@postgresql.org; Bruce
Momjian
Subject: Re: [ADMIN] Problem building initdb on sparc10 

Averbukh Stella [EMAIL PROTECTED] writes:
 I'm building postgresQL on Sparc10 and the build goes fine unil
initdb.

 /usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith 
 -Winline -Wendif-labels -fno-strict-aliasing initdb.o 
 -L../../../src/port -lpgport -L../../../src/interfaces/libpq -lpq 
 -L../../../src/port -Wl,-R/postgres/lib -L/lib -L/usr/lib 
 -L/usr/local/lib -L/usr/local/ssl/lib -L/platform/SUNW,Ultra-60/lib
 -L/usr/sfw/lib/sparcv9 -L/usr/sfw/lib/ -L/usr/local/lib/sparcv9 
 -lpgport -lz -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm -o initdb 
 Undefined first referenced symbol in file sigmask 
 ../../../src/interfaces/libpq/libpq.so
 sigblock ../../../src/interfaces/libpq/libpq.so

When did you last successfully build PG on this system?  I'm guessing
you must have been using 7.4 or older, because AFAICS this was broken by
this 8.0 change:

2004-01-08 21:02  momjian

* doc/src/sgml/libpq.sgml, src/backend/nodes/read.c,
src/interfaces/libpq/fe-connect.c,
src/interfaces/libpq/fe-print.c,
src/interfaces/libpq/fe-secure.c,
src/interfaces/libpq/libpq-fe.h,
src/interfaces/libpq/libpq-int.h,
src/interfaces/libpq/pqsignal.c,
src/interfaces/libpq/pqsignal.h: Allow libpq to do thread-safe
SIGPIPE handling.  This allows it to ignore SIGPIPE from send()
in
libpq, but terminate on any other SIGPIPE, unless the user
installs
their own signal handler.

This is a minor fix because the only time you get SIGPIPE from
libpq's send() is when the backend dies.

The code appears to unconditionally assume that sigmask() and sigblock()
exist.  Not a good assumption.

AFAICS pqsignalinquire() isn't even used anywhere (at least not in
HEAD), so the simplest answer may be to remove it rather than try to fix
it.  It's in src/interfaces/libpq/pqsignal.c.

regards, tom lane

__
This e-mail has been scanned by Arbitron's Email Content Service. 
__

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly