Re: Upgrade 7.4.1 to 7.4.3 not working

Hi,

What made cygserver work for me was, next time I ran the cygwin installer, select 'for all users' instead of 'for this
useronly'. Before I did that, the cygserver didn't want to start. 

regards,

--Tim

-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of mike g
Sent: donderdag 1 juli 2004 5:45
To: Mark Lubratt
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Upgrade 7.4.1 to 7.4.3 not working


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 www.cygwin.com 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@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)