Skip site navigation (1) Skip section navigation (2)

Re: Upgrade 7.4.1 to 7.4.3 not working

From: mike g <mike(at)thegodshalls(dot)com>
To: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Upgrade 7.4.1 to 7.4.3 not working
Date: 2004-07-01 03:44:35
Message-ID: 1088653475.20010.16.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-cygwin
Can you read cygserver.log?

Did the cygserver service start successfully anyway?  That normally runs
under a local system account rather than the account you installed it
under.  If it is not running the postmaster will not start.

Files can have different permissions than the directories themselves. 
Did you check those?  By chance did you install cygserver under a
different user account then the one you are trying to run the configure
script in?

Did you also upgrade the cygwin dll from 1.5.9 to 1.5.10 / install using
the latest setup.exe from and not a previous setup.exe
from the 7.4.1 install?

On Sat, 2004-06-26 at 13:11, Mark Lubratt wrote:
> Hello!
> I just upgraded from 7.4.1 to 7.4.3 last night on a Windows 2000 Server 
> machine.  Now, I can't get postgresql to work.  I had a working 
> implementation on version 7.4.1; complete with automatic services.  So, 
> I know the postgres user is setup properly (all the permissions, logon 
> as service, etc.).
> I uninstalled all the services (postmaster, ipc-daemon2, 
> pg_autovacuum), and started installing all the new services.  I have 
> followed the recent postings from Frank Seesink and Patrick Erley.  
> I've also checked all the permission settings that are frequently 
> mentioned by Jason Tishler.  I've also created the new data directory 
> at /var/postgresql/data (I've done a pg_dumpall and plan to do the 
> restore).  I've also added CYGWIN=server to the global environment 
> variables and rebooted (I even saw a post mentioning CYGSERVER=server, 
> so I added that as well).
> When I run cygserver-config, I do get one error message stating:
> touch: creating '/var/log/cygserver.log': Permission denied
> However, I check all the permissions for /var and /var/log and they are 
> all world writeable from within cygwin and the corresponding 
> directories from the W2000 Server explorer grant full write permission 
> to everyone.  Also, despite the error message, cygserver.log is created 
> in the /var/log directory.  So, I plow forward and create the 
> postmaster service and then try to start it.  It fails.
> /var/log/postmaster.log reads:
> FATAL:  shmat(id=0) failed: Bad file descriptor
> LOG:  shmctl(0,4096,0) failed: Invalid argument
> If I look at the Error in the Event viewer under the application log, 
> it says:
> PID 2732: starting service 'postmaster' failed: execv: 1, Operation not 
> permitted.
> I'm almost at my wit's end.  Can someone point out the error of my ways?
> Thanks!
> Mark
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to


pgsql-cygwin by date

Next:From: mike gDate: 2004-07-01 03:54:38
Subject: Re: initdb fails with invalid argument to shmat
Previous:From: mike gDate: 2004-07-01 03:32:23
Subject: Re: Signal 12

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group