This is a discussion on Re: Unregister Windows Service pg_ctl error within the Pgsql General forums, part of the PostgreSQL category; --> > > You need administrative privileges to unregister a service. > Can't run > > it as user postgres. ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > > You need administrative privileges to unregister a service. > Can't run > > it as user postgres. > > I did the same under "Administrator" but then I get an access > violation error like: > > Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC0000005: > Access violation reading location 0x00000000. > > What am I dong wrong? That's the bug I sent in a patch for just now,that Peter has applied. The workaround until the next release is out is to specify the data directory when you do unregister. E.g. pg_ctl -D ../data unregister You shouldn't need that, but due to the bug you get a crash if you don't... //Magnus ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
| ||||
| Thank you > -----Original Message----- > From: Magnus Hagander [mailto:mha@sollentuna.net] > Sent: Saturday, January 14, 2006 6:16 PM > To: Gevik > Cc: pgsql-general@postgresql.org > Subject: RE: [GENERAL] Unregister Windows Service pg_ctl error > > > > You need administrative privileges to unregister a service. > > Can't run > > > it as user postgres. > > > > I did the same under "Administrator" but then I get an access > > violation error like: > > > > Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC0000005: > > Access violation reading location 0x00000000. > > > > What am I dong wrong? > > That's the bug I sent in a patch for just now,that Peter has applied. > > The workaround until the next release is out is to specify the data > directory when you do unregister. E.g. > pg_ctl -D ../data unregister > > You shouldn't need that, but due to the bug you get a crash if you > don't... > > //Magnus ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |