Re: [ADMIN] Problem building initdb on sparc10

2006-06-05 Thread Averbukh Stella
Thank you guys.

I tried both suggestions while I was trying to fix the problem but it
didn't work.  The only thing that worked was commenting out that
pqsignalinquire function in pqsignal.c as Tom Lane suggested. 


Stella Averbukh
_


-Original Message-
From: louis gonzales [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 04, 2006 10:51 PM
To: Ganesh Chaudhari
Cc: Averbukh Stella; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problem building initdb on sparc10

I also had some issues when building Slony-I for Solaris 9 on an E450,
with PostgreSQL 8.0.1.  Take a look at /var/ld/ld.config - do a google
search on how to configure the ld.config file, which is essentially the
Library lookup file used by the OS.

Ganesh Chaudhari wrote:

 I encountered similar problem but not sure what I did to make it work.

 I would say check makefile properly, may be you missed to put at 
 someother place too where its needed. Also export LD library path 
 before starting the build with all path.

 LD_LIBRARY_PATH=/usr/lib:/usr/local/lib:/usr/sfw/lib
 export LD_LIBRARY_PATH

 Thanks
 Ganesh

 On 5/30/06, *Averbukh Stella* [EMAIL PROTECTED] 
 mailto:[EMAIL PROTECTED] wrote:

 Hello,

 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
 ld: fatal: Symbol referencing errors. No output written to initdb
 collect2: ld returned 1 exit status
 gmake[2]: *** [initdb] Error 1
 gmake[2]: Leaving directory
 `/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'
 gmake[1]: *** [all] Error 2
 gmake[1]: Leaving directory
 `/export/home/usaver/postgres/postgresql-8.1.3/src/bin'
 gmake: *** [all] Error 2

 I ran ldd on libpq.so ldd interfaces/libpq/libpq.so
 libresolv.so.2 = /lib/libresolv.so.2
 libsocket.so.1 = /lib/libsocket.so.1
 libnsl.so.1 = /lib/libnsl.so.1
 *libgcc_s.so.1 = (file not found)*
 libc.so.1 = /lib/libc.so.1
 libmp.so.2 = /lib/libmp.so.2
 libmd5.so.1 = /lib/libmd5.so.1
 libscf.so.1 = /lib/libscf.so.1
 libdoor.so.1 = /lib/libdoor.so.1
 libuutil.so.1 = /lib/libuutil.so.1
 libm.so.2 = /lib/libm.so.2
 /platform/SUNW,Ultra-60/lib/libc_psr.so.1
 /platform/SUNW,Ultra-60/lib/libmd5_psr.so.1
 If you notice libgcc_s.so.1 was not found. But I found it using
 find (see bellow)

 # find / -name libgcc_s.so.1
 /usr/sfw/lib/sparcv9/libgcc_s.so.1
 /usr/sfw/lib/libgcc_s.so.1
 /usr/local/lib/sparcv9/libgcc_s.so.1
 /usr/local/lib/libgcc_s.so.1

 I added all librararies directories to Makefile. See compilation
 line bellow. Unfortunately, something is not linking. I searched
 internet for the similar problem on Sparc and could not find
anything.

 Did anybody see this error before and can suggest me a way to fix
it?

 Thank you all.


 /Stella Averbukh/
 _
 Senior Software Lead, Arbitron Inc.






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

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [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 5: don't forget to increase your free space map settings


[ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Averbukh Stella
Title: Problem building initdb on sparc10






Hello, 


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
ld: fatal: Symbol referencing errors. No output written to initdb
collect2: ld returned 1 exit status
gmake[2]: *** [initdb] Error 1
gmake[2]: Leaving directory `/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/export/home/usaver/postgres/postgresql-8.1.3/src/bin'
gmake: *** [all] Error 2


I ran ldd on libpq.so ldd interfaces/libpq/libpq.so
libresolv.so.2 = /lib/libresolv.so.2
libsocket.so.1 = /lib/libsocket.so.1
libnsl.so.1 = /lib/libnsl.so.1
libgcc_s.so.1 = (file not found)
libc.so.1 = /lib/libc.so.1
libmp.so.2 = /lib/libmp.so.2
libmd5.so.1 = /lib/libmd5.so.1
libscf.so.1 = /lib/libscf.so.1
libdoor.so.1 = /lib/libdoor.so.1
libuutil.so.1 = /lib/libuutil.so.1
libm.so.2 = /lib/libm.so.2
/platform/SUNW,Ultra-60/lib/libc_psr.so.1
/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1 

If you notice libgcc_s.so.1 was not found. But I found it using find (see bellow) 


# find / -name libgcc_s.so.1
/usr/sfw/lib/sparcv9/libgcc_s.so.1
/usr/sfw/lib/libgcc_s.so.1
/usr/local/lib/sparcv9/libgcc_s.so.1
/usr/local/lib/libgcc_s.so.1


I added all librararies directories to Makefile. See compilation line bellow. Unfortunately, something is not linking. I searched internet for the similar problem on Sparc and could not find anything.

Did anybody see this error before and can suggest me a way to fix it?


Thank you all.



Stella Averbukh

_

Senior Software Lead, Arbitron Inc.







Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Andy Shellam
Title: Problem building initdb on sparc10








Should you need to add lgcc to the
linker path? (e.g. L/usr/lib lgcc) or lgcc_s?



I had a similar thing with readline.
Just a guess!



Andy













From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Averbukh Stella
Sent: 30 May 2006 2:22 pm
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Problem building
initdb on sparc10





Hello,


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
ld: fatal: Symbol referencing errors. No output written to initdb
collect2: ld returned 1 exit status
gmake[2]: *** [initdb] Error 1
gmake[2]: Leaving directory `/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin'
gmake: *** [all] Error 2 

I
ran ldd on libpq.so ldd
interfaces/libpq/libpq.so
libresolv.so.2 = /lib/libresolv.so.2
libsocket.so.1 = /lib/libsocket.so.1
libnsl.so.1 = /lib/libnsl.so.1
libgcc_s.so.1 = (file not found)
libc.so.1 = /lib/libc.so.1
libmp.so.2 = /lib/libmp.so.2
libmd5.so.1 = /lib/libmd5.so.1
libscf.so.1 = /lib/libscf.so.1
libdoor.so.1 = /lib/libdoor.so.1
libuutil.so.1 = /lib/libuutil.so.1
libm.so.2 = /lib/libm.so.2
/platform/SUNW,Ultra-60/lib/libc_psr.so.1
/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1 
If you notice libgcc_s.so.1 was not found. But I found it
using find (see bellow) 

# find / -name libgcc_s.so.1
/usr/sfw/lib/sparcv9/libgcc_s.so.1
/usr/sfw/lib/libgcc_s.so.1
/usr/local/lib/sparcv9/libgcc_s.so.1
/usr/local/lib/libgcc_s.so.1 

I
added all librararies directories to Makefile. See compilation line bellow.
Unfortunately, something is not linking. I searched internet for the similar
problem on Sparc and could not find anything.

Did
anybody see this error before and can suggest me a way to fix it?


Thank
you all. 



Stella Averbukh

_ 
Senior Software Lead, Arbitron Inc. 



!DSPAM:14,447c473434492073859513! 










Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Averbukh Stella
Title: Problem building initdb on sparc10



Andy,

thank you very much for the idea.

I tried what you 
suggested even though -lgcc flag is usually used with -nostdlib and -nodefaultlibs 
flags, which I do not use. In any case it didn't help. 


thahks 
again.
Stella 
Averbukh _ 



From: Andy Shellam 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 
9:35 AMTo: Averbukh StellaCc: 
pgsql-admin@postgresql.orgSubject: RE: [ADMIN] Problem building 
initdb on sparc10


Should you need to add 
lgcc to the linker path? (e.g. L/usr/lib lgcc) or 
lgcc_s?

I had a similar thing 
with readline. Just a guess!

Andy






From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Averbukh 
StellaSent: 30 May 2006 2:22 
pmTo: pgsql-admin@postgresql.orgSubject: [ADMIN] Problem building initdb on 
sparc10

Hello, 
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 initdbUndefined first referencedsymbol in filesigmask 
../../../src/interfaces/libpq/libpq.sosigblock 
../../../src/interfaces/libpq/libpq.sold: fatal: Symbol referencing errors. 
No output written to initdbcollect2: ld returned 1 exit statusgmake[2]: 
*** [initdb] Error 1gmake[2]: Leaving directory 
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'gmake[1]: *** 
[all] Error 2gmake[1]: Leaving directory 
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin'gmake: *** [all] 
Error 2 
I 
ran ldd on libpq.so ldd 
interfaces/libpq/libpq.solibresolv.so.2 = 
/lib/libresolv.so.2libsocket.so.1 = /lib/libsocket.so.1libnsl.so.1 
= /lib/libnsl.so.1libgcc_s.so.1 = 
(file not found)libc.so.1 = /lib/libc.so.1libmp.so.2 
= /lib/libmp.so.2libmd5.so.1 = /lib/libmd5.so.1libscf.so.1 = 
/lib/libscf.so.1libdoor.so.1 = /lib/libdoor.so.1libuutil.so.1 = 
/lib/libuutil.so.1libm.so.2 = 
/lib/libm.so.2/platform/SUNW,Ultra-60/lib/libc_psr.so.1/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1 
If you notice 
libgcc_s.so.1 was not found. But I found it using find (see 
bellow) 
# find / -name 
"libgcc_s.so.1"/usr/sfw/lib/sparcv9/libgcc_s.so.1/usr/sfw/lib/libgcc_s.so.1/usr/local/lib/sparcv9/libgcc_s.so.1/usr/local/lib/libgcc_s.so.1 
I added all librararies directories 
to Makefile. See compilation line bellow. Unfortunately, something is not 
linking. I searched internet for the similar problem on Sparc and could not find 
anything.
Did 
anybody see this error before and can suggest me a way to fix it? 

Thank you all. 


Stella 
Averbukh _ 
Senior Software Lead, 
Arbitron Inc. 
!DSPAM:14,447c473434492073859513! 
__This 
e-mail has been scanned by Arbitron's Email Content Service. 
__


Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Sergiusz Jarczyk

Hi

[...]


I ran ldd on libpq.so ldd interfaces/libpq/libpq.so
libresolv.so.2 = /lib/libresolv.so.2
libsocket.so.1 = /lib/libsocket.so.1
libnsl.so.1 = /lib/libnsl.so.1
*libgcc_s.so.1 = (file not found)*
libc.so.1 = /lib/libc.so.1
libmp.so.2 = /lib/libmp.so.2
libmd5.so.1 = /lib/libmd5.so.1
libscf.so.1 = /lib/libscf.so.1
libdoor.so.1 = /lib/libdoor.so.1
libuutil.so.1 = /lib/libuutil.so.1
libm.so.2 = /lib/libm.so.2
/platform/SUNW,Ultra-60/lib/libc_psr.so.1
/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1
If you notice libgcc_s.so.1 was not found. But I found it using find 
(see bellow)


# find / -name libgcc_s.so.1
/usr/sfw/lib/sparcv9/libgcc_s.so.1
/usr/sfw/lib/libgcc_s.so.1
/usr/local/lib/sparcv9/libgcc_s.so.1
/usr/local/lib/libgcc_s.so.1

Did you tried with LD_LIBRARY_PATH pointing to /usr/sfw/lib or 
/usr/local/lib? Normally, Solaris software ignore this variable, but 
many software, linked against GNU libraries, do (GNU ld is using it too).


Sergiusz


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Andy Shellam
Title: Problem building initdb on sparc10








Hmm, I did the same on my system (Redhat
Fedora 3) and only got the following required libraries:




linux-gate.so.1 = (0xb7ff3000)


libcrypt.so.1 = /lib/libcrypt.so.1 (0xb7fa2000)


libresolv.so.2 = /lib/libresolv.so.2 (0xb7f8e000)


libnsl.so.1 = /lib/libnsl.so.1 (0xb7f78000)


libc.so.6 = /lib/tls/libc.so.6 (0xb7e4d000)


/lib/ld-linux.so.2 (0x00308000)



Whats the libgcc_s library for?
Is it something thats SPARC-specific?













From: Averbukh Stella
[mailto:[EMAIL PROTECTED] 
Sent: 30 May 2006 3:00 pm
To: [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Problem
building initdb on sparc10





Andy,



thank you very much for the idea.





I tried what you suggested even though -lgcc flag is usually
used with -nostdlib and -nodefaultlibs
flags, which I do not use. In any case it didn't help. 











thahks again.



Stella
Averbukh 
_ 















From: Andy Shellam [mailto:[EMAIL PROTECTED]

Sent: Tuesday, May 30, 2006 9:35
AM
To: Averbukh Stella
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Problem
building initdb on sparc10

Should you need to add lgcc to the
linker path? (e.g. L/usr/lib lgcc) or lgcc_s?



I had a similar thing with readline.
Just a guess!



Andy













From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Averbukh Stella
Sent: 30 May 2006 2:22 pm
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Problem building
initdb on sparc10





Hello,


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
ld: fatal: Symbol referencing errors. No output written to initdb
collect2: ld returned 1 exit status
gmake[2]: *** [initdb] Error 1
gmake[2]: Leaving directory
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin'
gmake: *** [all] Error 2 

I
ran ldd on libpq.so ldd
interfaces/libpq/libpq.so
libresolv.so.2 = /lib/libresolv.so.2
libsocket.so.1 = /lib/libsocket.so.1
libnsl.so.1 = /lib/libnsl.so.1
libgcc_s.so.1 = (file not found)
libc.so.1 = /lib/libc.so.1
libmp.so.2 = /lib/libmp.so.2
libmd5.so.1 = /lib/libmd5.so.1
libscf.so.1 = /lib/libscf.so.1
libdoor.so.1 = /lib/libdoor.so.1
libuutil.so.1 = /lib/libuutil.so.1
libm.so.2 = /lib/libm.so.2
/platform/SUNW,Ultra-60/lib/libc_psr.so.1
/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1 
If you notice libgcc_s.so.1 was not found. But I found it
using find (see bellow) 

# find / -name libgcc_s.so.1
/usr/sfw/lib/sparcv9/libgcc_s.so.1
/usr/sfw/lib/libgcc_s.so.1
/usr/local/lib/sparcv9/libgcc_s.so.1
/usr/local/lib/libgcc_s.so.1 

I
added all librararies directories to Makefile. See compilation line bellow.
Unfortunately, something is not linking. I searched internet for the similar
problem on Sparc and could not find anything.

Did
anybody see this error before and can suggest me a way to fix it?


Thank
you all. 



Stella Averbukh

_ 
Senior Software Lead, Arbitron Inc. 






__
This e-mail has been scanned by Arbitron's Email Content Service. 
__
!DSPAM:14,447c500c34495121086930! 










Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Averbukh Stella
Yes, I did try to set LD_LIBRARY_PATH.  This is what it has right now.

# echo $LD_LIBRARY_PATH
/usr/sfw/lib:/lib:/platform/SUNW,Ultra-60/lib:/usr/local/lib:/usr/lib

Thanks.

Stella Averbukh
_


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sergiusz Jarczyk
Sent: Tuesday, May 30, 2006 10:18 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problem building initdb on sparc10

Hi

[...]

 I ran ldd on libpq.so ldd interfaces/libpq/libpq.so
 libresolv.so.2 = /lib/libresolv.so.2
 libsocket.so.1 = /lib/libsocket.so.1
 libnsl.so.1 = /lib/libnsl.so.1
 *libgcc_s.so.1 = (file not found)*
 libc.so.1 = /lib/libc.so.1
 libmp.so.2 = /lib/libmp.so.2
 libmd5.so.1 = /lib/libmd5.so.1
 libscf.so.1 = /lib/libscf.so.1
 libdoor.so.1 = /lib/libdoor.so.1
 libuutil.so.1 = /lib/libuutil.so.1
 libm.so.2 = /lib/libm.so.2
 /platform/SUNW,Ultra-60/lib/libc_psr.so.1
 /platform/SUNW,Ultra-60/lib/libmd5_psr.so.1
 If you notice libgcc_s.so.1 was not found. But I found it using find 
 (see bellow)

 # find / -name libgcc_s.so.1
 /usr/sfw/lib/sparcv9/libgcc_s.so.1
 /usr/sfw/lib/libgcc_s.so.1
 /usr/local/lib/sparcv9/libgcc_s.so.1
 /usr/local/lib/libgcc_s.so.1

Did you tried with LD_LIBRARY_PATH pointing to /usr/sfw/lib or
/usr/local/lib? Normally, Solaris software ignore this variable, but
many software, linked against GNU libraries, do (GNU ld is using it
too).

Sergiusz


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

__
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


Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Andy Shellam
Title: RE: [ADMIN] Problem building initdb on sparc10






Although I did actually find this library on my system:

find / -name libgcc_s.so.1

/lib/libgcc_s.so.1


_
From: Averbukh Stella [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2006 3:45 pm
To: Andy Shellam
Subject: Read: RE: [ADMIN] Problem building initdb on sparc10

Your message

 To: Averbukh Stella

 Cc: pgsql-admin@postgresql.org

 Subject: RE: [ADMIN] Problem building initdb on sparc10

 Sent: Tue, 30 May 2006 10:44:48 -0400

was read on Tue, 30 May 2006 10:45:25 -0400



!DSPAM:14,447c5aa434497666914776!




Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Averbukh Stella
Title: Problem building initdb on sparc10



Hi Andy,

I have no idea if it's Sparc specific. I usually do 
Java development and last time I did large c/c++ build on unix platform was a 
long time ago, so my skills in this area are a little bit 
rusty.

Stella.



From: Andy Shellam 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 
10:45 AMTo: Averbukh StellaCc: 
pgsql-admin@postgresql.orgSubject: RE: [ADMIN] Problem building 
initdb on sparc10


Hmm, I did the same on 
my system (Redhat Fedora 3) and only got the following required 
libraries:

 
linux-gate.so.1 = (0xb7ff3000)
 
libcrypt.so.1 = /lib/libcrypt.so.1 (0xb7fa2000)
 
libresolv.so.2 = /lib/libresolv.so.2 
(0xb7f8e000)
 
libnsl.so.1 = /lib/libnsl.so.1 (0xb7f78000)
 
libc.so.6 = /lib/tls/libc.so.6 (0xb7e4d000)
 
/lib/ld-linux.so.2 (0x00308000)

Whats the libgcc_s 
library for? Is it something thats 
SPARC-specific?






From: Averbukh 
Stella [mailto:[EMAIL PROTECTED] Sent: 30 May 2006 3:00 pmTo: 
[EMAIL PROTECTED]Cc: pgsql-admin@postgresql.orgSubject: RE: [ADMIN] Problem building 
initdb on sparc10

Andy,

thank you very much for the 
idea.


I tried what you suggested even 
though -lgcc flag is usually used with -nostdlib and -nodefaultlibs flags, which I do not 
use. In any case it didn't help. 




thahks 
again.
Stella 
Averbukh _ 







From: 
Andy Shellam 
[mailto:[EMAIL PROTECTED] Sent: Tuesday, May 30, 2006 9:35 
AMTo: Averbukh 
StellaCc: pgsql-admin@postgresql.orgSubject: RE: [ADMIN] Problem building 
initdb on sparc10
Should you need to add 
lgcc to the linker path? (e.g. L/usr/lib lgcc) or 
lgcc_s?

I had a similar thing 
with readline. Just a guess!

Andy






From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
On Behalf Of Averbukh 
StellaSent: 30 May 2006 2:22 
pmTo: pgsql-admin@postgresql.orgSubject: [ADMIN] Problem building initdb on 
sparc10

Hello, 
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 initdbUndefined first referencedsymbol in filesigmask 
../../../src/interfaces/libpq/libpq.sosigblock 
../../../src/interfaces/libpq/libpq.sold: fatal: Symbol referencing errors. 
No output written to initdbcollect2: ld returned 1 exit statusgmake[2]: 
*** [initdb] Error 1gmake[2]: Leaving directory 
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin/initdb'gmake[1]: *** 
[all] Error 2gmake[1]: Leaving directory 
`/export/home/usaver/postgres/postgresql-8.1.3/src/bin'gmake: *** [all] 
Error 2 
I 
ran ldd on libpq.so ldd 
interfaces/libpq/libpq.solibresolv.so.2 = 
/lib/libresolv.so.2libsocket.so.1 = /lib/libsocket.so.1libnsl.so.1 
= /lib/libnsl.so.1libgcc_s.so.1 = 
(file not found)libc.so.1 = /lib/libc.so.1libmp.so.2 
= /lib/libmp.so.2libmd5.so.1 = /lib/libmd5.so.1libscf.so.1 = 
/lib/libscf.so.1libdoor.so.1 = /lib/libdoor.so.1libuutil.so.1 = 
/lib/libuutil.so.1libm.so.2 = 
/lib/libm.so.2/platform/SUNW,Ultra-60/lib/libc_psr.so.1/platform/SUNW,Ultra-60/lib/libmd5_psr.so.1 
If you notice 
libgcc_s.so.1 was not found. But I found it using find (see 
bellow) 
# find / -name 
"libgcc_s.so.1"/usr/sfw/lib/sparcv9/libgcc_s.so.1/usr/sfw/lib/libgcc_s.so.1/usr/local/lib/sparcv9/libgcc_s.so.1/usr/local/lib/libgcc_s.so.1 
I added all librararies directories 
to Makefile. See compilation line bellow. Unfortunately, something is not 
linking. I searched internet for the similar problem on Sparc and could not find 
anything.
Did 
anybody see this error before and can suggest me a way to fix it? 

Thank you all. 


Stella 
Averbukh _ 
Senior Software Lead, 
Arbitron Inc. 

__This 
e-mail has been scanned by Arbitron's Email Content Service. 
__!DSPAM:14,447c500c34495121086930! 
__This 
e-mail has been scanned by Arbitron's Email Content Service. 
__


Re: [ADMIN] Problem building initdb on sparc10

2006-05-30 Thread Tom Lane
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

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [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 5: don't forget to increase your free space map settings