Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
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 Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Leonid,I agree... but where is a descriptive message in the log. a healthy:) data directory looks like this:baseglobalpg_clogpg_hba.confpg_ident.confpg_logpg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.conf postmaster.optspostmaster.pidand within pg_log there are log filesI 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 PGDATAwithin my postgresql-config (last one is a default) are responsible for this. Did you change the logging directory? Best wishes,Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP
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 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP
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 hardware -- add a new hardware device -- select from a list -- show all devices -- microsoft -- Microsoft Loopback Adapter) cheers, thomas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Hi everyone!Harald, my data\ directory does not contain pg_log\ directory, here is my data\ dir content: C:\Program Files\PostgreSQL\8.1\datadir /bbaseglobalpg_clogpg_hba.confpg_ident.conf pg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.confRegards,LeonidOn 11/3/06, Harald Armin Massa [EMAIL PROTECTED] wrote: Leonid,System Event Viewer has the follwoing entries:1. The PostgreSQL Database Server 8.1 service was successfully sent a startcontrol.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_logWithin that directory there are log files. Please check them for information, post them to this list.Harald -- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
Harald,I agree... but where is a descriptive message in the log.Thanks,LeonidOn 11/4/06, Harald Armin Massa [EMAIL PROTECTED] 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-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart 0173/9409607-Python: the only language with more web frameworks than keywords.
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition
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? LeonidOn 11/3/06, Leonid Shlyapnikov [EMAIL PROTECTED] 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\datadir /bbaseglobalpg_clogpg_hba.confpg_ident.conf pg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.confRegards,Leonid On 11/3/06, Harald Armin Massa [EMAIL PROTECTED] wrote: Leonid,System Event Viewer has the follwoing entries:1. The PostgreSQL Database Server 8.1 service was successfully sent a startcontrol.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_logWithin that directory there are log files. Please check them for information, post them to this list.Harald -- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.
[BUGS] 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: [EMAIL PROTECTED] 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 (0x274D/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
Re: [BUGS] 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 startcontrol.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_logWithin that directory there are log files. Please check them for information, post them to this list.Harald -- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-Python: the only language with more web frameworks than keywords.