I'm a researcher and a Windows desktop application developer.
I'm exploring a potential migration to PostgreSQL from Firebird
and would appreciate some help in understanding some of the
differences in their basic setup and function.
I use ZoneAlarm Pro and one feature it provides it to identify
which applications are active. While Firebird is listed in ZA's
program control, it is never identified as active even when an
application is using it, even though the service is set to automatic
and fbserver.exe starts on boot up.
In contrast, after my intitial install of PG 8.3, and reboot,
PostgreSQL is listed as an active application in ZoneAlarm Pro's
Program Control.
What is it running, if anything?
Further examination in Windows TaskManager reveals that I have
six postgres.exe processes running, five of which use an average
of 4,750K, and one uses 8,096K.
To the best of my knowledge, Firebird never runs more than one
process.
Since I am only running desktop applications, I doubt that I will
need six instances of the PostgreSQL process. I assume that this
might be managed in a config file, but I can't find any indication
of this in the PostgreSQL 8.3 help file.
I'd be grateful for any answers about why PG wants internet access,
and any help about the PG running active when nothing is apparently
using it, and any help about configuring the number of active
processes, particularly a reference in the help so that I can be
better acclimated to the PG terminology and culture.
--
George Newton


|