Обсуждение: Question about postgresql-8.1.2-1-binaries-no-installer.zip(win32)

Поиск
Список
Период
Сортировка

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

От
Tony Caduto
Дата:
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?

Thanks,

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


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

От
"Magnus Hagander"
Дата:
> 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


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

От
Tony Caduto
Дата:
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


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

От
"Alexey Gousev"
Дата:
> 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.



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

От
"Magnus Hagander"
Дата:
> > 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


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

От
Andrew Dunstan
Дата:

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