BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition

Leonid,

System Event Viewer has the follwoing entries:
1. The PostgreSQL Database Server 8.1 service was successfully sent a
start
control.
2. The PostgreSQL Database Server 8.1 service entered the running state.
3. The PostgreSQL Database Server 8.1 service entered the stopped state.

please look inside your PostgreSQL data directory. There should be a
directory named pg_log

Within that directory there are log files. Please check them for
information, post them to this list.

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

Hi everyone!

Harald, my data\ directory does not contain pg_log\ directory, here is my
data\ dir content:

C:\Program Files\PostgreSQL\8.1\data>dir /b

base
global
pg_clog
pg_hba.conf
pg_ident.conf
pg_multixact
pg_subtrans
pg_tblspc
pg_twophase
PG_VERSION
pg_xlog
postgresql.conf

Regards,
Leonid

Hi guys,

It is strange but after I gave postmaster.exe process access to the Internet
(changed my personal firewall settings), PostgreSQL service starts OK. Why
does postmaster.exe need access to the Internet?

Leonid

Leonid,

It is strange but after I gave postmaster.exe process access to the Internet

(changed my personal firewall settings), PostgreSQL service starts OK. Why
does postmaster.exe need access to the Internet?

PostgreSQL / postmaster.exe do not need to connect to the Internet. But

communication is done via TCP/IP; and PostgreSQL needs to open Port 5432
(standard) and listen for requests. So when your firewall forbids PostgreSQL
to listen on Port 5433 for incoming requests, it may commit suicide, because
it cannot do any usefull work anymore.

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

Harald,

I agree... but where is a descriptive message in the log.

Thanks,
Leonid

Leonid,

I agree... but where is a descriptive message in the log.

a healthy:) data directory looks like this:

base
global
pg_clog
pg_hba.conf
pg_ident.conf
pg_log
pg_multixact
pg_subtrans
pg_tblspc
pg_twophase
PG_VERSION
pg_xlog
postgresql.conf
postmaster.opts
postmaster.pid

and within pg_log there are log files

I think that those lines:

#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.

# This is used when logging to stderr:
redirect_stderr = on # Enable capturing of stderr into log
# files

# These are only used if redirect_stderr is on:
#log_directory = 'pg_log' # Directory where log files are written
# Can be absolute or relative to PGDATA

within my postgresql-config (last one is a default) are responsible for
this. Did you change the logging directory?

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

On Sat, 4 Nov 2006, Harald Armin Massa wrote:

Leonid,

It is strange but after I gave postmaster.exe process access to the Internet

(changed my personal firewall settings), PostgreSQL service starts OK. Why
does postmaster.exe need access to the Internet?

PostgreSQL / postmaster.exe do not need to connect to the Internet. But

communication is done via TCP/IP; and PostgreSQL needs to open Port 5432
(standard) and listen for requests. So when your firewall forbids PostgreSQL
to listen on Port 5433 for incoming requests, it may commit suicide, because
it cannot do any usefull work anymore.

Best wishes,

Harald

Windows has another bug; they don't include a proper loopback function
with the standard distribution _and_ they have some asenine view that if
there's no physical network connection available, they tear down the
network stack! This means that anything that connects with TCP/IP can't
work, even if it's to the local machine. I consider this idiocy, but,
there's windows for you in a nutshell...

However, you _can_ find a proper "loopback driver", I think they call it -
software, of course. Also, I carry in my laptop case a special HARDWARE
loopback connector! It's an RJ45 that has the wires crossed over. I use it
when I'm at a customer site or otherwise "away from home" and my customer
doesn't have the software loopback - plug my loopback connector into any
"twisted pair ethernet" socket and suddenly the TCP/IP software works
fine!

Oh the joys of dealing with Windows.

Richard

P.S. You can't get one of these RJ45 loopback connectors commercially, I
don't think, but I can send you directions - or make one for you if you
send me a tenner! -smile- RT

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/

Windows has another bug; they don't include a proper loopback function
with the standard distribution _and_ they have some asenine view that if
there's no physical network connection available, they tear down the
network stack! This means that anything that connects with TCP/IP can't
work, even if it's to the local machine. I consider this idiocy, but,
there's windows for you in a nutshell...

However, you _can_ find a proper "loopback driver", I think they call it -
software, of course. Also, I carry in my laptop case a special HARDWARE
loopback connector! It's an RJ45 that has the wires crossed over. I use it
when I'm at a customer site or otherwise "away from home" and my customer
doesn't have the software loopback - plug my loopback connector into any
"twisted pair ethernet" socket and suddenly the TCP/IP software works
fine!

there is a loopback driver shipped with windows xp / windows 2003. but you
have to add it manually ("add hardwar"e --> "add a new hardware device" -->
"select from a list" --> "show all devices" --> "microsoft" --> "Microsoft
Loopback Adapter")

cheers,
thomas