The following bug has been logged online:

Bug reference: 2092
Logged by:
Email address: dirk (AT) pirschel (DOT) de
PostgreSQL version: ...
Operating system: ...
Description: No answer to bug reports 1975 and 2055
Details:

No answer to bug reports 1975 and 2055 yet. Are you going to fix these
issues, or is AIX currently unsupportet?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

"" <dirk (AT) pirschel (DOT) de> writes:
You seem to have a problem with missing SSL in the link, but I don't see
why that should be; ecpg certainly tries to link to ssl. You'll need to
dig into it a little bit for yourself. You haven't provided enough
context to let anyone else reproduce the problem, even if they had AIX
which most of us don't --- for example, what configure arguments did you
use?

regards, tom lane

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

http://archives.postgresql.org

Dirk Pirschel <dirk (AT) pirschel (DOT) de> writes:
Well, *something* in your link is trying to pull in OpenSSL.

What exactly is in /client/lib ... could it be that there is an existing
SSL-dependent installation of libpq in there? In theory the link should
find the libpq in ../../../../src/interfaces/libpq not the one in
/client/lib, but we've seen bizarre linker search behavior before ...

regards, tom lane

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

http://archives.postgresql.org

I wrote:
Actually, not so bizarre as all that: looking at your command again, the
-L/client/lib is in there twice:

gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wendif-labels
-fno-strict-aliasing -L../../../../src/port -L/client/lib -Wl,-bnoentry
-Wl,-H512 -Wl,-bM:SRE -o libecpg.so libecpg.a -Wl,-bE:libecpg.exp
-L../pgtypeslib -L../../../../src/interfaces/libpq -L../../../../src/port
-L/client/lib -lpgtypes -lpq -lm

Assuming there is a libpq in /client/lib, I bet this patch will help.

regards, tom lane

*** src/Makefile.shlib.orig Fri Oct 28 13:32:22 2005
--- src/Makefile.shlib Sat Dec 3 14:58:32 2005
***************
*** 76,81 ****
--- 76,84 ----
# Insert -L from LDFLAGS after any -L already present in SHLIB_LINK
SHLIB_LINK := $(filter -L%, $(SHLIB_LINK)) $(filter -L%, $(LDFLAGS)) $(filter-out -L%, $(SHLIB_LINK))

+ # Need a -L-free version of LDFLAGS to use in combination with SHLIB_LINK
+ LDFLAGS_NO_L := $(filter-out -L%, $(LDFLAGS))
+
# Default shlib naming convention used by the majority of platforms
shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MIN OR_VERSION)
shlib_major = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
***************
*** 154,160 ****
ifeq ($(PORTNAME), hpux)
shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
ifeq ($(with_gnu_ld), yes)
! LINK.shared = $(CC) $(LDFLAGS) -shared -Wl,-h -Wl,$(soname)
else
# can't use the CC-syntax rpath pattern here
rpath =
--- 157,163 ----
ifeq ($(PORTNAME), hpux)
shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
ifeq ($(with_gnu_ld), yes)
! LINK.shared = $(CC) $(LDFLAGS_NO_L) -shared -Wl,-h -Wl,$(soname)
else
# can't use the CC-syntax rpath pattern here
rpath =
***************
*** 309,315 ****
# AIX case
$(shlib): lib$(NAME).a
$(MKLDEXPORT) lib$(NAME).a > lib$(NAME)$(EXPSUFF)
! $(COMPILER) $(LDFLAGS) $(LDFLAGS_SL) -o $@ $< -Wl,-bE:lib$(NAME)$(EXPSUFF) $(SHLIB_LINK)

endif # PORTNAME == aix

--- 312,318 ----
# AIX case
$(shlib): lib$(NAME).a
$(MKLDEXPORT) lib$(NAME).a > lib$(NAME)$(EXPSUFF)
! $(COMPILER) $(LDFLAGS_NO_L) $(LDFLAGS_SL) -o $@ $< -Wl,-bE:lib$(NAME)$(EXPSUFF) $(SHLIB_LINK)

endif # PORTNAME == aix


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--jI8keyz6grp/JLjh
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Tom,

* Tom Lane wrote on Sat, 03 Dec 2005 at 13:11 -0500:
The first time, i have posted all configure and make output. I received
a "message size too large" from the mailing list server. Unfortunately,
the www bug reporting form did not complain about message size, only the
mail server does later. The second time i have truncated the output to
the compiler errors.

Nothing relevant.

=2E/configure --prefix=3D$HOME/software --with-includes=3D/client/include -=
-with-libs=3D/client/lib
[...]
checking whether to build with OpenSSL support... no

Any hints where to investigate?

-Dirk

--=20
Windoze is bootiful

--jI8keyz6grp/JLjh
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFDke/RxJ5Dfiog8/YRAr2AAJ941IVF0lObA06xb29aXNIGR62gJwCeLNaY
Hmi5jfsnxAWqhjpJaXfJwSc=
=ivkL
-----END PGP SIGNATURE-----

--jI8keyz6grp/JLjh--

--xo44VMWPx7vlQ2+2
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Tom,

* Tom Lane wrote on Sat, 03 Dec 2005 at 15:02 -0500:
=20
$ cd postgresql-8.1.0
$ patch -i ~/patch src/Makefile.shlib
$ ./configure --prefix=3D$HOME/software --with-includes=3D/client/include -=
-with-libs=3D/client/lib
$ make
[...]
All of PostgreSQL successfully made. Ready to install.
$ make install
[...]
PostgreSQL installation complete.


Your patch works fine :-) Thanks!

Regards,
-Dirk

--=20
"If Microsoft can change and compete on quality, I've won." - Linus Torvalds

--xo44VMWPx7vlQ2+2
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD4DBQFDkg0TxJ5Dfiog8/YRArqmAJi54dduJjV+ffjI6w8Tl9ncUXXHAJ9qGoUm
lot7f281HO4fwLFk3eTDag==
=M3+4
-----END PGP SIGNATURE-----

--xo44VMWPx7vlQ2+2--

--ZoaI/ZTpAVc4A5k6
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Tom,

* Tom Lane wrote on Sat, 03 Dec 2005 at 14:34 -0500:

$ cd /client/lib
$ ls -l *libpq*
lrwxrwxrwx 1 root system 41 Nov 18 2004 libpq.a -> /sw/rs_=
aix52/postgresql-7.4.6/lib/libpq.a
lrwxrwxrwx 1 root system 42 Nov 18 2004 libpq.so -> /sw/rs=
_aix52/postgresql-7.4.6/lib/libpq.so
lrwxrwxrwx 1 root system 44 Nov 18 2004 libpq.so.3 -> /sw/=
rs_aix52/postgresql-7.4.6/lib/libpq.so.3

Regards,
-Dirk

--=20
Close the windows - the penguin is freezing

--ZoaI/ZTpAVc4A5k6
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFDkfrExJ5Dfiog8/YRAtaIAJ9QpsXUWqR2u5yCM0/XWDLChCmzbgCfZKsc
PNlZvFq92Eskw2jZjBWGtU0=
=S79Q
-----END PGP SIGNATURE-----

--ZoaI/ZTpAVc4A5k6--