Thread: Troubles with beta2-dev3 on Windows XP

Hello!
I'm having troubles with postgreSQL beta2-dev3 on Windows XP.

1) During the installation, I've got some error/warning dialogs ....
see :
http://people.menelic.com/ahouans/pg/err.html

The first 4 screens are from the installation.
The last one is from pgAdmin III.


2)Windows task manager shows pg_ctl.exe,  postmaster.exe, and 2 postgres.exe processes
running (by user postgres). Also, the windows service manager shows that the pg server is running. So,
  a)  I've tried to connect from the command line:
<err>
C:\Program Files\PostgreSQL\8.0-beta2-dev3\bin>
C:\Program Files\PostgreSQL\8.0-beta2-dev3\bin>psql
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

C:\Program Files\PostgreSQL\8.0-beta2-dev3\bin>

</err>

 b) PgAdmin III failed too.


3) Note that the PC has no internet access.
In the log file in the pg_log/ directory, available at
http://people.menelic.com/ahouans/pg/postgresql-2004-09-16_065902.log.txt ,

there is :
<log>
2004-09-16 06:59:04 Central Europe Daylight Time LOG:  incomplete startup packet
2004-09-16 06:59:05 Central Europe Daylight Time LOG:  could not receive data from client: An operation was attempted
onsomething that is not a socket.  
</log>

Perhaps, it has something  to do with networking?
The server can be stopped and restarted through the windows XP service manager ,no problem, but, I cannot connect to
it.

My PC is a Pentium III @ 700Mhz, 512MB , WinXP pro, Service Pack 1.

Also, I'm concerned about the procedural lang not being installed, I need it :-(

Thanks for helping.

Arcadius

Arcadius A. wrote:

>
>
> 3) Note that the PC has no internet access.

I wonder if the PC has a workable loopback interface.
Does ping 127.0.0.1 on the command line work?

Regards,
Andreas

Arcadius,

sound like a knew version of a sad problem:

> 3) Note that the PC has no internet access.

I assume that TCP/IP has to be installed as a protocoll (use the loopback
device) to use PostgreSQL, because server-client communication even locally
is done via IP-Sockets.

IF TCP/IP is installed, it sounds as the usual problem with "Layerd Service
providers".

Please consult the extensive FAQ to the installer to find nearer information
and especially a link to a tool to especially check for this problem.

Harald

______________________________________________________________
> Od: Andreas Pflug <pgadmin@pse-consulting.de>
> Komu: "Arcadius A." <arcadius@centrum.cz>
> CC: pgsql-hackers-win32@postgresql.org
> Datum: Thu, 16 Sep 2004 09:22:44 +0000
> Předmět: Re: [pgsql-hackers-win32] Troubles with beta2-dev3 on Windows XP
>
> Arcadius A. wrote:
>
> >
> >
> > 3) Note that the PC has no internet access.
>
> I wonder if the PC has a workable loopback interface.
> Does ping 127.0.0.1 on the command line work?
>

Yes, ping 127.0.0.1 does work .
(even apache is on that machine and both localhost and 127.0.0.1 work in the browser.)

Thanks.
Arcadius.