The following bug has been logged online:

Bug reference: 2731
Logged by: Leonid Shlyapnikov
Email address: lshlyapnikov (AT) gmail (DOT) com
PostgreSQL version: 8.1.5-1
Operating system: Windows XP Media Center Edition Version 2002 Service
Pack 2
Description: Cannot install PostgreSQL server on WinXP Media Center
Edition
Details:

During the installation I have the following error:

--------------------------------------------------
Product: PostgreSQL 8.1 -- could not connect to server: Connection refused
(0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
--------------------------------------------------

After installation it is not possible to start the corresponding service.

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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

------=_Part_7999_18806412.1162599450549
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,


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



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

------=_Part_7999_18806412.1162599450549
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,<br><div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">S=
ystem Event Viewer has the follwoing entries:<br>1. The PostgreSQL Database=
Server=20
8.1 service was successfully sent a start<br>control.<br>2. The PostgreSQL =
Database Server 8.1 service entered the running state.<br>3. The PostgreSQL=
Database Server 8.1 service entered the stopped state.</blockquote><div>
<br>please look inside your PostgreSQL data directory. There should be a di=
rectory named pg_log<br><br>Within that directory there are log files. Plea=
se check them for information, post them to this list.<br><br>Harald<br>
<br>&nbsp;</div><br></div>-- <br>GHUM Harald Massa<br>persuadere et program=
mare<br>Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>70197 Stuttgart<br>=
0173/9409607<br>-<br>Python: the only language with more web frameworks tha=
n keywords.

------=_Part_7999_18806412.1162599450549--

------=_Part_9637_17977601.1162629794641
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,

It is strange but after I gave postmaster.exe process access to the Interne=
t
(standard) and listen for requests. So when your firewall forbids PostgreSQ=
L
to listen on Port 5433 for incoming requests, it may commit suicide, becaus=
e
it cannot do any usefull work anymore.

Best wishes,

Harald



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

------=_Part_9637_17977601.1162629794641
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,<br><br><div><blockquote class=3D"gmail_quote" style=3D"border-left:=
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex=
;">It is strange but after I gave postmaster.exe process access to the Inte=
rnet (changed my personal firewall settings), PostgreSQL service starts OK.=
Why does=20
postmaster.exe need access to the Internet?<br><span class=3D"sg"><br></spa=
n></blockquote></div>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 f=
orbids PostgreSQL to listen on Port 5433 for incoming requests, it may comm=
it suicide, because it cannot do any usefull work anymore.
<br><br>Best wishes,<br><br>Harald<br><br><br clear=3D"all"><br>-- <br>GHUM=
Harald Massa<br>persuadere et programmare<br>Harald Armin Massa<br>Reinsbu=
rgstra=DFe 202b<br>70197 Stuttgart<br>0173/9409607<br>-<br>Python: the only=
language with more web frameworks than keywords.

------=_Part_9637_17977601.1162629794641--

------=_Part_11005_33410636.1162645024804
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,

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 =3D 'stderr' # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.

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

# These are only used if redirect_stderr is on:
#log_directory =3D '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






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

------=_Part_11005_33410636.1162645024804
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Leonid,<br><div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I=
agree... but where is a descriptive message in the log.<br><br></blockquot=
e>
</div>a healthy data directory looks like this:<br>base<br>global<br>pg_c=
log<br>pg_hba.conf<br>pg_ident.conf<br>pg_log<br>p g_multixact<br>pg_subtran=
s<br>pg_tblspc<br>pg_twophase<br>PG_VERSION<br>pg_ xlog<br>postgresql.conf
<br>postmaster.opts<br>postmaster.pid<br><br>and within pg_log there are lo=
g files<br><br>I think that those lines:<br><br>#--------------------------=
-------------------------------------------------<br># ERROR REPORTING AND =
LOGGING
<br>#----------------------------------------------------------------------=
-----<br><br># - Where to Log -<br><br>log_destination =3D 'stderr'&nbsp;&n=
bsp;&nbsp; &nbsp;&nbsp;&nbsp; # Valid values are combinations of <br>&nbsp;=
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp=
;&nbsp;&nbsp; # stderr, syslog and eventlog,=20
<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&n=
bsp; &nbsp;&nbsp;&nbsp; # depending on platform.<br><br># This is used when=
logging to stderr:<br>redirect_stderr =3D on&nbsp;&nbsp;&nbsp; &nbsp;&nbsp=
;&nbsp; &nbsp;&nbsp;&nbsp; # Enable capturing of stderr into log <br>&nbsp;=
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp=
;&nbsp;&nbsp; # files<br><br># These are only used if redirect_stderr is on=
:
<br>#log_directory =3D 'pg_log'&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # Dire=
ctory where log files are written<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; # Can be absolute =
or relative to PGDATA<br><br><br>within my postgresql-config (last one is a=
default) are responsible for this. Did you change the logging directory?
<br><br>Best wishes,<br><br>Harald<br><br><br><br><br><br clear=3D"all"><br=
on: the only language with more web frameworks than keywords.

------=_Part_11005_33410636.1162645024804--

------=_Part_40618_2807648.1162603986239
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everyone!

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

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

On 11/3/06, Harald Armin Massa <haraldarminmassa (AT) gmail (DOT) com> wrote:
------=_Part_40618_2807648.1162603986239
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everyone!<br><br>Harald, my data\ directory does not contain pg_log\ dir=
ectory, here is my data\ dir content:<br><br>&gt; C:\Program Files\PostgreS=
QL\8.1\data&gt;dir /b<br>base<br>global<br>pg_clog<br>pg_hba.conf<br>p g_ide=
nt.conf
<br>pg_multixact<br>pg_subtrans<br>pg_tblspc<br>pg _twophase<br>PG_VERSION<b=
r>pg_xlog<br>postgresql.conf<br><br>Regards,<br>Le onid<br><br><div><span cl=
ass=3D"gmail_quote">On 11/3/06, <b class=3D"gmail_sendername">Harald Armin =
Massa
</b> &lt;<a href=3D"mailto:haraldarminmassa (AT) gmail (DOT) com">haraldarminmassa@gma=
il.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D"bord=
er-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-l=
eft: 1ex;">
Leonid,<br><div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">S=
ystem Event Viewer has the follwoing entries:<br>1. The PostgreSQL Database=
Server=20
8.1 service was successfully sent a start<br>control.<br>2. The PostgreSQL =
Database Server 8.1 service entered the running state.<br>3. The PostgreSQL=
Database Server 8.1 service entered the stopped state.</blockquote><div>

<br>please look inside your PostgreSQL data directory. There should be a di=
rectory named pg_log<br><br>Within that directory there are log files. Plea=
se check them for information, post them to this list.<br><br>Harald<br>

<br>&nbsp;</div><br></div>-- <br>GHUM Harald Massa<br>persuadere et program=
mare<br><span class=3D"sg">Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>=
70197 Stuttgart<br>0173/9409607<br>-<br>Python: the only language with more=
web frameworks than keywords.

</span></blockquote></div><br>

------=_Part_40618_2807648.1162603986239--

------=_Part_44629_5796952.1162642774677
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Harald,

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

Thanks,
Leonid

On 11/4/06, Harald Armin Massa <haraldarminmassa (AT) gmail (DOT) com> wrote:
------=_Part_44629_5796952.1162642774677
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Harald,<br><br>I agree... but where is a descriptive message in the log.<br=
haraldarminmassa (AT) gmail (DOT) com">
haraldarminmassa (AT) gmail (DOT) com</a>&gt; wrote:</span><blockquote class=3D"gmail_=
quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt =
0pt 0.8ex; padding-left: 1ex;">Leonid,<span class=3D"q"><br><br><div><block=
quote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 2=
04); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
It is strange but after I gave postmaster.exe process access to the Interne=
t (changed my personal firewall settings), PostgreSQL service starts OK. Wh=
y does=20
postmaster.exe need access to the Internet?<br><span><br></span></blockquot=
e></div></span>PostgreSQL / postmaster.exe do not need to connect to the In=
ternet. 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 sui=
cide, because it cannot do any usefull work anymore.
<br><br>Best wishes,<div><span class=3D"e" id=3D"q_10eb222cb833b932_3"><br>=
<br>Harald<br><br><br clear=3D"all"><br>-- <br>GHUM Harald Massa<br>persuad=
ere et programmare<br>Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>70197=
Stuttgart
<br>0173/9409607<br>-<br>Python: the only language with more web frameworks=
than keywords.

</span></div></blockquote></div><br>

------=_Part_44629_5796952.1162642774677--

------=_Part_40927_6444635.1162607085114
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi guys,

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

Leonid


On 11/3/06, Leonid Shlyapnikov <lshlyapnikov (AT) gmail (DOT) com> wrote:
------=_Part_40927_6444635.1162607085114
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi guys,<br><br>It is strange but after I gave postmaster.exe process acces=
s to the Internet (changed my personal firewall settings), PostgreSQL servi=
ce starts OK. Why does postmaster.exe need access to the Internet?<br><br>
Leonid<br><br><br><div><span class=3D"gmail_quote">On 11/3/06, <b class=3D"=
gmail_sendername">Leonid Shlyapnikov</b> &lt;<a href=3D"mailto:lshlyapnikov=
@gmail.com">lshlyapnikov (AT) gmail (DOT) com</a>&gt; wrote:</span><blockquote class=
=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin=
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi everyone!<br><br>Harald, my data\ directory does not contain pg_log\ dir=
ectory, here is my data\ dir content:<br><br>&gt; C:\Program Files\PostgreS=
QL\8.1\data&gt;dir /b<br>base<br>global<br>pg_clog<br>pg_hba.conf<br>p g_ide=
nt.conf
<br>pg_multixact<br>pg_subtrans<br>pg_tblspc<br>pg _twophase<br>PG_VERSION<b=
r>pg_xlog<br>postgresql.conf<br><br>Regards,<br><s pan class=3D"sg">Leonid</=
span><div><span class=3D"e" id=3D"q_10eb098fd93253b4_2"><br><br><div><span =
class=3D"gmail_quote">
On 11/3/06, <b class=3D"gmail_sendername">Harald Armin Massa
</b> &lt;<a href=3D"mailto:haraldarminmassa (AT) gmail (DOT) com" target=3D"_blank" on=
click=3D"return top.js.OpenExtLink(window,event,this)">haraldarmin massa@gma=
il.com</a>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D"bord=
er-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-l=
eft: 1ex;">

Leonid,<br><div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px=
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">S=
ystem Event Viewer has the follwoing entries:<br>1. The PostgreSQL Database=
Server=20
8.1 service was successfully sent a start<br>control.<br>2. The PostgreSQL =
Database Server 8.1 service entered the running state.<br>3. The PostgreSQL=
Database Server 8.1 service entered the stopped state.</blockquote><div>


<br>please look inside your PostgreSQL data directory. There should be a di=
rectory named pg_log<br><br>Within that directory there are log files. Plea=
se check them for information, post them to this list.<br><br>Harald<br>


<br>&nbsp;</div><br></div>-- <br>GHUM Harald Massa<br>persuadere et program=
mare<br><span>Harald Armin Massa<br>Reinsburgstra=DFe 202b<br>70197 Stuttga=
rt<br>0173/9409607<br>-<br>Python: the only language with more web framewor=
ks than keywords.

</span></blockquote></div><br>

</span></div></blockquote></div><br>

------=_Part_40927_6444635.1162607085114--