Re: BUG #5305: Postgres service stops when closing Windows session

On Mon, Feb 1, 2010 at 11:28 AM, Cristian <cbittel(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5305
> Logged by:          Cristian
> Email address:      cbittel(at)gmail(dot)com
> PostgreSQL version: 8.3.9
> Operating system:   Windows 2003 Server Standard x64
> Description:        Postgres service stops when closing Windows session
> Details:
>
> We connect to Windows server using the Terminal Services Clients (mstsc),
> and performs maintenance task with pgAdmin 3.
>
> PostgreSQL service crashes when the user close session on Windows, and the
> following error is recorded in the pg_log files:
>
>
>
> LOG:  server process (PID 5200) exited with exit code 128
>
> LOG:  terminating any other active server processes
>
> WARNING:  terminating connection because of crash of another server process
>
> DETAIL:  The postmaster has commanded this server process to roll back the
> current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.
>
> HINT:  In a moment you should be able to reconnect to the database and
> repeat your command. ..
>
>
>
> The server has the following specs:
>
> Windows 2003 SP2 Standard 64-bit, 4GB, NOT joined to a domain.
>
> PostgreSQL 8.3.9
>
> pgAdmin 3
>
> We connect without the /console parameter.
>
>
> Any ideas?

So you're saying that if pgadmin is open when you close the terminal
services session, the SERVER crashes?

Did you somehow start the server in that same session, or is the
server running as a service?

...Robert