Re: [Fwd: PostgreSQL 8.0.0-beta4 Windows 2000

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/

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(at)rediffmail(dot)com>

> X-Account-Key: account1
> Delivery-date: Mon, 08 Nov 2004 02:16:50 +0100
> Envelope-to: ru(at)x-ray(dot)at
> Date: 1 Nov 2004 19:54:41 -0000
> Reply-To: yuvaraj duraisamy <durai_yuvaraj(at)rediffmail(dot)com>
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] PostgreSQL 8.0.0-beta4 Windows 2000 Installation
> X-Inode-Forwarded: rurban(at)x-ray(dot)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 creating a database in the console; I could connect the database once with the php. After that no log nothing. After reinstallation also I got the same result. After wasting about 10 hours I got a clue and reinstalled after uninstalling the Norton 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(at)candle(dot)pha(dot)pa(dot)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(at)rediffmail(dot)com>
>
>>X-Account-Key: account1
>>Delivery-date: Mon, 08 Nov 2004 02:16:50 +0100
>>Envelope-to: ru(at)x-ray(dot)at
>>Date: 1 Nov 2004 19:54:41 -0000
>>Reply-To: yuvaraj duraisamy <durai_yuvaraj(at)rediffmail(dot)com>
>>To: pgsql-cygwin(at)postgresql(dot)org
>>Subject: [CYGWIN] PostgreSQL 8.0.0-beta4 Windows 2000 Installation
>>X-Inode-Forwarded: rurban(at)x-ray(dot)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 creating a database in the console; I could connect the database once with the php. After that no log nothing. After reinstallation also I got the same result. After wasting about 10 hours I got a clue and reinstalled after uninstalling the Norton 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(dot)hessdoerfer(at)sea-gmbh(dot)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