Upgrading 8.1.1 to 8.1.2 in Windows - Mailing list pgsql-general

From Jonel Rienton
Subject Upgrading 8.1.1 to 8.1.2 in Windows
Date
Msg-id 000401c61941$3e1db220$0302a8c0@aspire
Whole thread Raw
List pgsql-general
I think I've hit a bug here when upgrading my Windows installation from
version 8.1.1 to 8.1.2 using the upgrade.bat file included in the
installation kit. When it comes to the part of registering the service, it
keeps on saying can't register because I don't have enough permission, I'm
an admistrator in this box.

1. So I check my services, I remember I changed the account used to start
the service to "postgresql" from "postgres". So I changed it back to
postgres and try the upgrade again, this time it worked. (if only the error
message could have been more specific, like hey, change the account name
back to postgres or something)

2. After the upgrade, I tried starting the service from the Services msc. No
go, I checked my task manager, it seems like the postgres.exe task(a few of
them) is cycling through starting and stopping. I check the logs in my Event
Viewer, a bunch of:

FATAL:  could not reattach to shared memory (key=5432001, addr=01C30000):
Invalid argument

3. I checked the logs in the PGDATA dir, I got a bunch of this

2006-01-14 13:17:43 LOG:  all server processes terminated; reinitializing
2006-01-14 13:17:44 LOG:  background writer process (PID 9856) exited with
exit code 0
2006-01-14 13:17:44 LOG:  terminating any other active server processes
2006-01-14 13:17:44 LOG:  all server processes terminated; reinitializing
2006-01-14 13:17:44 LOG:  background writer process (PID 9972) exited with
exit code 0
2006-01-14 13:17:44 LOG:  terminating any other active server processes
2006-01-14 13:17:44 LOG:  all server processes terminated; reinitializing
2006-01-14 13:17:44 LOG:  background writer process (PID 9988) exited with
exit code 0
2006-01-14 13:17:44 LOG:  terminating any other active server processes
2006-01-14 13:17:44 LOG:  all server processes terminated; reinitializing
2006-01-14 13:17:44 LOG:  background writer process (PID 10028) exited with
exit code 0


4. Here's the interesting part, if I go start the command prompt in the
Postgres program group, start the database with:

runas /user:postgresql pg_ctl -D D:\PgData81 start

It actually starts. Is there a way to fix the service way of starting the
database? I even tried running the same command in the service from the
command line and I'm getting the windows dialog box saying an internal error
occurred in pg_ctl.exe.


Regards,

Jonel Rienton

--
I know not english well, but I know 9 computer languages.


pgsql-general by date:

Previous
From: "Gevik babakhani"
Date:
Subject: Re: Unregister Windows Service pg_ctl error
Next
From: Robert Paulsen
Date:
Subject: sort character data in arbitrary order?