win32 8.1 pgadmin dll issues

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of
Merlin Moncure
Sent: 10 November 2005 14:56
To: pgadmin-hackers@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: [HACKERS] win32 8.1 pgadmin dll issues

My dev box was running 8.1rc1 and I thought it was time to put 8.1 on
it. I downloaded the 8.1 binaries-only dist off of postgresql.org (bt
version), did a binary swap on my server and nothing ran...it
turns out
all the binaries like initdb.exe, postgres.exe have a dll
dependency on
various pgAdmin dlls like comerr32.dll and several others.
pgAdmin was
not installed on my server so nothing worked. I copied the .dlls from
the pgAdmin folder on my workstation and postgres starts up.

Normally I roll my own so this may or may not be an
issue...but when did
initdb.exe acquire a pgAdmin dependency?

It doesn't - they're all libpq dependencies, not pgAdmin ones (though
pgAdmin does need them because it uses libpq of course).

Commerr32 & brb5_32 are Kerberos.
Libiconv-2.dll & libintl-2.dll are Gettext.
Libeay32.dll and ssleay32.dll are Open SSL

Regards, Dave.

My dev box was running 8.1rc1 and I thought it was time to put 8.1

on

it. I downloaded the 8.1 binaries-only dist off of postgresql.org

(bt

version), did a binary swap on my server and nothing ran...it
turns out
all the binaries like initdb.exe, postgres.exe have a dll
dependency on
various pgAdmin dlls like comerr32.dll and several others.
pgAdmin was
not installed on my server so nothing worked. I copied the .dlls

from

the pgAdmin folder on my workstation and postgres starts up.

Normally I roll my own so this may or may not be an
issue...but when did
initdb.exe acquire a pgAdmin dependency?

It doesn't - they're all libpq dependencies, not pgAdmin ones (though
pgAdmin does need them because it uses libpq of course).

hm that makes sense...however those dlls are not provided in the binary
only installation but are required because it is compiled with ssl, etc.
The bt page doesn't state if ssl is required or not. I just assumed
pgAdmin because that was the only place I could find a copy of the
libraries.

Merlin

My dev box was running 8.1rc1 and I thought it was time to
put 8.1 on it. I downloaded the 8.1 binaries-only dist off
of postgresql.org (bt version), did a binary swap on my
server and nothing ran...it turns out all the binaries like
initdb.exe, postgres.exe have a dll dependency on various
pgAdmin dlls like comerr32.dll and several others. pgAdmin
was not installed on my server so nothing worked. I copied
the .dlls from the pgAdmin folder on my workstation and
postgres starts up.

Exactly what DLLs are those?
comerr32.dll is a Kerberos DLL and not a pgAdmin DLL..

Normally I roll my own so this may or may not be an
issue...but when did initdb.exe acquire a pgAdmin dependency?

It really shouldn't.

//Magnus

On Thu, Nov 10, 2005 at 04:24:46PM +0100, Magnus Hagander wrote:

My dev box was running 8.1rc1 and I thought it was time to
put 8.1 on it. I downloaded the 8.1 binaries-only dist off
of postgresql.org (bt version), did a binary swap on my
server and nothing ran...it turns out all the binaries like
initdb.exe, postgres.exe have a dll dependency on various
pgAdmin dlls like comerr32.dll and several others. pgAdmin
was not installed on my server so nothing worked. I copied
the .dlls from the pgAdmin folder on my workstation and
postgres starts up.

Exactly what DLLs are those?
comerr32.dll is a Kerberos DLL and not a pgAdmin DLL..

I wonder if this is an artifact of the "link everything into every
binary even if we don't use it" procedure. Hence the postmaster can
depend on readline even though it doesn't use it.

With gcc we're proposing --as-needed to resolve this, but how would
that work for a windows platform? Can you examine a binary to see what
it depends on?

Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of
Martijn van Oosterhout
Sent: 10 November 2005 15:42
To: Magnus Hagander
Cc: Merlin Moncure; pgadmin-hackers@postgresql.org;
pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] win32 8.1 pgadmin dll issues

On Thu, Nov 10, 2005 at 04:24:46PM +0100, Magnus Hagander wrote:

My dev box was running 8.1rc1 and I thought it was time to
put 8.1 on it. I downloaded the 8.1 binaries-only dist off
of postgresql.org (bt version), did a binary swap on my
server and nothing ran...it turns out all the binaries like
initdb.exe, postgres.exe have a dll dependency on various
pgAdmin dlls like comerr32.dll and several others. pgAdmin
was not installed on my server so nothing worked. I copied
the .dlls from the pgAdmin folder on my workstation and
postgres starts up.

Exactly what DLLs are those?
comerr32.dll is a Kerberos DLL and not a pgAdmin DLL..

I wonder if this is an artifact of the "link everything into every
binary even if we don't use it" procedure. Hence the postmaster can
depend on readline even though it doesn't use it.

With gcc we're proposing --as-needed to resolve this, but how would
that work for a windows platform? Can you examine a binary to see what
it depends on?

Those are the only dependencies, and are all intentional.

Regards, Dave