Thread: Upgrade 7.4.1 to 7.4.3 not working
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
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
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)
On Jun 30, 2004, at 10:44 PM, mike g wrote: > Can you read cygserver.log? > Yes. > 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. > Yes, it started. > 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? > The cygserver.log permissions are 644 and the owner/group is SYSTEM/root. The directory permissions are 777 and the owner permission is postgres/Users. I installed everything using the same account. > 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? > I did an upgrade, then I tried a fresh install. Neither worked. Regards, Mark
My directory permissions for /var/log are 776 and the owner permission is my NT domain\username with the group mkgroup-(undefined I believe). Did you issue initdb -D /var/postgresql/data before trying to start the postmaster? On Fri, 2004-07-02 at 20:18, Mark Lubratt wrote: > On Jun 30, 2004, at 10:44 PM, mike g wrote: > > > Can you read cygserver.log? > > > > Yes. > > > 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. > > > > Yes, it started. > > > > 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? > > > > The cygserver.log permissions are 644 and the owner/group is > SYSTEM/root. The directory permissions are 777 and the owner > permission is postgres/Users. > > I installed everything using the same account. > > > 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? > > > > I did an upgrade, then I tried a fresh install. Neither worked. > > Regards, > Mark > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend