Skip site navigation (1) Skip section navigation (2)

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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Cristian <cbittel(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5305: Postgres service stops when closing Windows session
Date: 2010-02-03 20:26:35
Message-ID: 603c8f071002031226w6fce0a71je2b0e2bab9e632fc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Joshua TolleyDate: 2010-02-03 21:06:17
Subject: Re: Making pg_config and pg_controldata output availablevia SQL
Previous:From: Robert HaasDate: 2010-02-03 19:53:00
Subject: Re: Add on_trusted_init and on_untrusted_init to plperl UPDATED [PATCH]

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2010-02-03 22:49:26
Subject: Re: BUG #5308: How to disable Case sensitivity on naming identifiers
Previous:From: Robert HaasDate: 2010-02-03 20:25:02
Subject: Re: BUG #5308: How to disable Case sensitivity on naming identifiers

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group