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