Question about postgresql-8.1.2-1-binaries-no-installer.zip(win32)

Hi,
I noticed that when I install via the msi setup there is a
extra DLL in the bin directory called pthreadGC2.dll. (Posix
thread library for windows)

This dll is not in the
postgresql-8.1.2-1-binaries-no-installer.zip file.

Postgresql seems to run fine without out when I do a manual
install using the zip file.

If this is not used for the server what is it used for?

It's used for ecpg, IIRC, when compiled in thread-safe mode.

//Magnus

Magnus Hagander wrote:

It's used for ecpg, IIRC, when compiled in thread-safe mode.

//Magnus

Thanks Magnus,
Here is another question for you.
Is it documented anywhere or does someone know what is the bare minimum
requirements to run the server on a production box?

I want to create the litest possible setup for use in my IM server
(Lightning Messenger), and eliminate any unneeded files so I can have
the smallest setup I can get.

I already have a complete working setup built with Inno setup(it's 4.8
mb), now I just need to get it as lite as posssible.

Thanks,

--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com

I already have a complete working setup built with Inno setup(it's 4.8
mb), now I just need to get it as lite as posssible.

Tony, try Agentix Installer (http://www.aginstaller.com) to built the
litest setup for your IM server. It has very low (50Kb only) overhead.
It is very impressive indeed, doing almost everything Inno Setup does,
but producing setup files 250-290Kb smaller.

It's used for ecpg, IIRC, when compiled in thread-safe mode.

//Magnus

Thanks Magnus,
Here is another question for you.
Is it documented anywhere or does someone know what is the
bare minimum requirements to run the server on a production box?

No, I don't think so :-)

I want to create the litest possible setup for use in my IM
server (Lightning Messenger), and eliminate any unneeded
files so I can have the smallest setup I can get.

I already have a complete working setup built with Inno
setup(it's 4.8 mb), now I just need to get it as lite as posssible.

Well, for starters, build from source. Don't enable things like SSL,
NLS, PLs etc. That'll give you smaller binaries.
You can skip a bunch of conversions if you're never going to need them.
ANd of course, you don't need things like libpostgres.a.
As for the actual binaries, you need postgres and postmaster. All the
rest are optional (though you're probably goping to want initdb). The
only DLL needed should be libpq.dll - assuming you didn't put in support
for ssl, kerberos, nls etc.

//Magnus

Magnus Hagander wrote:

I want to create the litest possible setup for use in my IM
server (Lightning Messenger), and eliminate any unneeded
files so I can have the smallest setup I can get.

I already have a complete working setup built with Inno
setup(it's 4.8 mb), now I just need to get it as lite as posssible.

Well, for starters, build from source. Don't enable things like SSL,
NLS, PLs etc. That'll give you smaller binaries.
You can skip a bunch of conversions if you're never going to need them.
ANd of course, you don't need things like libpostgres.a.
As for the actual binaries, you need postgres and postmaster. All the
rest are optional (though you're probably goping to want initdb). The
only DLL needed should be libpq.dll - assuming you didn't put in support
for ssl, kerberos, nls etc.

you also probably want pg_ctl. It's pretty light, though.

cheers

andrew