Thread: [Fwd: PostgreSQL 8.0.0-beta4 Windows 2000 Installation]
forwarding a doc request from cygwin. (Note: You might have to disable Norton Antivirus of you experience problems.) -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/ Hi I am new Postgresql. I downloaded and installed postgresql-8.0.0-beta4 on windows 2000 everything went smooth, after creatinga database in the console; I could connect the database once with the php. After that no log nothing. After reinstallationalso I got the same result. After wasting about 10 hours I got a clue and reinstalled after uninstalling theNorton Antivirus I am running successfully. Providing such a silly information will encourage help new users. Thanks for the OSS community With regards yuvaraj
Magnus is working on something that will print a better failure message when the virus protection blocks PostgreSQL. --------------------------------------------------------------------------- Reini Urban wrote: > forwarding a doc request from cygwin. > > (Note: You might have to disable Norton Antivirus of you experience > problems.) > -- > Reini Urban > http://xarch.tu-graz.ac.at/home/rurban/ -- Start of included mail From: yuvaraj duraisamy <durai_yuvaraj@rediffmail.com> > X-Account-Key: account1 > Delivery-date: Mon, 08 Nov 2004 02:16:50 +0100 > Envelope-to: ru@x-ray.at > Date: 1 Nov 2004 19:54:41 -0000 > Reply-To: yuvaraj duraisamy <durai_yuvaraj@rediffmail.com> > To: pgsql-cygwin@postgresql.org > Subject: [CYGWIN] PostgreSQL 8.0.0-beta4 Windows 2000 Installation > X-Inode-Forwarded: rurban@x-ray.at > X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *1CQy9I-00031T-00*oVU2FDtWBJ.* > X-Inode-SpamScore: 1.7 > ?Hi > I am new Postgresql. I downloaded and installed postgresql-8.0.0-beta4 on windows 2000 everything went smooth, after creatinga database in the console; I could connect the database once with the php. After that no log nothing. After reinstallationalso I got the same result. After wasting about 10 hours I got a clue and reinstalled after uninstalling theNorton Antivirus I am running successfully. > Providing such a silly information will encourage help new users. > Thanks for the OSS community > > With regards > yuvaraj > > > -- End of included mail. > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian schrieb:
> Magnus is working on something that will print a better failure message
> when the virus protection blocks PostgreSQL.
Ah, good.
Note that cygwin setup.exe blocks McAfee Shield "AvSynMgr" also to be
able to download our packages after an UI dialog.
I don't know yet if just changing some settings might help.
Blocking is kinda unfriendly but the only solution.
That's the detection routine: (from our setup AntiVirus.cc)
SCM = OpenSCManager (NULL, NULL, SC_MANAGER_ALL_ACCESS);
McAfeeService = OpenService (SCM, "AvSynMgr",
SERVICE_QUERY_STATUS| SERVICE_STOP| SERVICE_START);
if (!McAfeeService) {
log (LOG_PLAIN, String("Could not open service McShield for query,
start and stop. McAfee may not be installed, or we don't have access.\n"));
CloseServiceHandle(SCM);
return;
}
SERVICE_STATUS status;
if (!QueryServiceStatus (McAfeeService, &status))
{
CloseServiceHandle(SCM);
CloseServiceHandle(McAfeeService);
log (LOG_PLAIN, String("Couldn't determine status of McAfee service.\n"));
return;
}
if (status.dwCurrentState == SERVICE_STOPPED ||
status.dwCurrentState == SERVICE_STOP_PENDING)
{
CloseServiceHandle(SCM);
CloseServiceHandle(McAfeeService);
log (LOG_PLAIN, "Mcafee is already stopped, nothing to see here\n");
}
... and so on
> ---------------------------------------------------------------------------
>
> Reini Urban wrote:
>
>>forwarding a doc request from cygwin.
>>
>>(Note: You might have to disable Norton Antivirus of you experience
>>problems.)
>
> -- Start of included mail From: yuvaraj duraisamy <durai_yuvaraj@rediffmail.com>
>
>>X-Account-Key: account1
>>Delivery-date: Mon, 08 Nov 2004 02:16:50 +0100
>>Envelope-to: ru@x-ray.at
>>Date: 1 Nov 2004 19:54:41 -0000
>>Reply-To: yuvaraj duraisamy <durai_yuvaraj@rediffmail.com>
>>To: pgsql-cygwin@postgresql.org
>>Subject: [CYGWIN] PostgreSQL 8.0.0-beta4 Windows 2000 Installation
>>X-Inode-Forwarded: rurban@x-ray.at
>>X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *1CQy9I-00031T-00*oVU2FDtWBJ.*
>>X-Inode-SpamScore: 1.7
>
>> ?Hi
>>I am new Postgresql. I downloaded and installed postgresql-8.0.0-beta4 on windows 2000 everything went smooth, after
creatinga database in the console; I could connect the database once with the php. After that no log nothing. After
reinstallationalso I got the same result. After wasting about 10 hours I got a clue and reinstalled after uninstalling
theNorton Antivirus I am running successfully.
>>Providing such a silly information will encourage help new users.
>>Thanks for the OSS community
Hi, just a quick question: I've installed test-drives of the PostgreSQL 8.0 beta installers (all versions, up to and including beta4), on win2k, XP Pro and XP home, they all worked fine starting the postmaster as service under user postgres. I just realized, though, that I had a problem upgrading one machine from beta2 to beta3, though. The service didn't start, because an initdb was required. But I didn't see any eventlog messages (that's where a windows user would look first, naturally). After more careful scrutiny, I did not find *ANY* server log messages. Where does the installer set logging to? Is logging to eventlog even implemented? How to configure it? Thanks for pointers, Jörg -- Leading SW developer - S.E.A GmbH Mail: joerg.hessdoerfer@sea-gmbh.com WWW: http://www.sea-gmbh.com
Joerg, Updating from beta to beta really has no production quality strategies :) (I also do not think that we could expect that ) You can use the standard-MSI Commandline-Parameters to log information concerning the install: msiexec /l* c:/temp/nasenbaer.log /i postgres-8.0.0-beta3.msi When the installation succeeds at least partially, there is a directory named pg_log within the PostgreSQL Data directory where the postmaster puts his logging. Harald