Search Postgresql Archives

Re: Database Failure on Windows XP Pro psql (PostgreSQL)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Try a 180-day Win2k3 trial to see if the issue persists.  Realistically,
though, if you can't afford the proprietary software don't develop with
it.

If it's a Windows XP bug (or "feature") then it's not anything we can
help with since PG is working correctly.

--
Brandon Aiken
CS/IT Systems Engineer

-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Oisin Glynn
Sent: Monday, January 08, 2007 3:54 PM
To: Shelby Cain
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Database Failure on Windows XP Pro psql
(PostgreSQL)

I have exceptions in the FW for postgresql.
I know XP Pro is not a server OS but it is a $$ question (I know *nix is

cheaper but it is not an option without a major rewrite). The Server is 
really more like a network appliance it is not expecting to have extra 
connections all over. In fact the DB is only accessible on 127.0.0.1

I have been checking for XP limits coming into play but the kicker is 
that there are no errors appearing (which other people are reporting 
lots of with SP2)
The 3 limits I am aware of are
a) There is a new limit on numbers of outbound connections being created

per second (people using e mule and torrents etc are having issues) We 
are not creating masses of outbound requests per second (at least AFAIK 
unless something in PG or something else is? without us noticing)
b)  There is a max open TCP/IP connections which is not physically 
enforced but may legally be inforced......(according to MS)
c) There is a hard limit on NAMED_PIPE and file shares that is allegedly

at 10. It is unclear exactly what is being counted here as I had 
NAMED_PIPES and 5 file shares from different PC's open earlier trying to

cause a failure.

We have run netstat to check for odd looking connections on each 
occurrence but never seen any?
Are there pieces of logging I should turn on in my .conf that would be 
helpful?

Oisin


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux