Upgrade 7.4.1 to 7.4.3 not working
От | Mark Lubratt |
---|---|
Тема | Upgrade 7.4.1 to 7.4.3 not working |
Дата | |
Msg-id | 3B3928A0-C79C-11D8-AE76-000A9579AF50@indeq.com обсуждение исходный текст |
Ответы |
Re: Upgrade 7.4.1 to 7.4.3 not working
|
Список | pgsql-cygwin |
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
В списке pgsql-cygwin по дате отправления: