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

The following bug has been logged online:

Bug reference:      2731
Logged by:          Leonid Shlyapnikov
Email address:      lshlyapnikov@gmail.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.

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



--=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.

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



--=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.

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 =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.

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

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

On 11/3/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
>
> 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=DFe 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

On 11/4/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
>
> Leonid,
>
> It is strange but after I gave postmaster.exe process access to the
> > Internet (changed my personal firewall settings), PostgreSQL service st=
arts
> > 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 Postgre=
SQL
> to listen on Port 5433 for incoming requests, it may commit suicide, beca=
use
> it cannot do any usefull work anymore.
>
> Best wishes,
>
> Harald
>
>
>
> --
> 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.
>

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


On 11/3/06, Leonid Shlyapnikov <lshlyapnikov@gmail.com> wrote:
>
> 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
>
> On 11/3/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
> >
> > 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=DFe 202b
> > 70197 Stuttgart
> > 0173/9409607
> > -
> > Python: the only language with more web frameworks than keywords.
>
>
>