From 2000info@netsite.com.br Wed May  4 14:08:59 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D523153861
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  4 May 2005 11:08:59 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 62068-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  4 May 2005 14:08:50 +0000 (GMT)
Received: from smtp1.netsite.com.br (smtp.netsite.com.br [200.187.175.54])
	by svr1.postgresql.org (Postfix) with ESMTP id 2101A52A43
	for <pgsql-sql@postgresql.org>; Wed,  4 May 2005 11:08:49 -0300 (ADT)
Received: from lap2000 (unknown [200.168.172.253])
	by smtp1.netsite.com.br (Postfix) with SMTP id 1E6BE6D84A
	for <pgsql-sql@postgresql.org>; Wed,  4 May 2005 11:04:46 -0300 (BRT)
Message-ID: <001101c550b2$cbba4470$240000c0@lap2000>
From: "2000 Informatica" <2000info@netsite.com.br>
To: "PGSQL" <pgsql-sql@postgresql.org>
Subject: all server processes terminated; reinitializing
Date: Wed, 4 May 2005 11:08:34 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0009_01C55099.9CE4B5E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.057 tagged_above=0 required=5 tests=HTML_30_40,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200505/37
X-Sequence-Number: 21350

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C55099.9CE4B5E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2.

Esta =E9 a messagem gravada no meu "serverlog":

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.

LOG: all server processes terminated; reinitializing

LOG: database system was interrupted at 2005-05-04 11:39:53 BRT

LOG: checkpoint record is at 0/6CE514D8

LOG: redo record is at 0/6CE514D8; undo record is at 0/0; shutdown TRUE

LOG: next transaction ID: 1229401; next OID: 2226116

LOG: database system was not properly shut down; automatic recovery in =
progress

LOG: redo starts at 0/6CE51514

LOG: unexpected pageaddr 0/65E5E000 in log file 0, segment 108, offset =
15065088

LOG: redo done at 0/6CE5DD24

LOG: database system is ready



Como devo proceder?



------=_NextPart_000_0009_01C55099.9CE4B5E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT size=3D2>
<P>Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2.</P>
<P>Esta =E9 a messagem gravada no meu "serverlog":</P>
<P>WARNING: terminating connection because of crash of another server=20
process</P>
<P>DETAIL: The postmaster has commanded this server process to roll back =
the=20
current transaction and exit, because another server process exited =
abnormally=20
and possibly corrupted shared memory.</P>
<P>HINT: In a moment you should be able to reconnect to the database and =
repeat=20
your command.</P>
<P>LOG: all server processes terminated; reinitializing</P>
<P>LOG: database system was interrupted at 2005-05-04 11:39:53 BRT</P>
<P>LOG: checkpoint record is at 0/6CE514D8</P>
<P>LOG: redo record is at 0/6CE514D8; undo record is at 0/0; shutdown =
TRUE</P>
<P>LOG: next transaction ID: 1229401; next OID: 2226116</P>
<P>LOG: database system was not properly shut down; automatic recovery =
in=20
progress</P>
<P>LOG: redo starts at 0/6CE51514</P>
<P>LOG: unexpected pageaddr 0/65E5E000 in log file 0, segment 108, =
offset=20
15065088</P>
<P>LOG: redo done at 0/6CE5DD24</P>
<P>LOG: database system is ready</P>
<P>&nbsp;</P>
<P>Como devo proceder?</P>
<P>&nbsp;</P></FONT></FONT></DIV></BODY></HTML>

------=_NextPart_000_0009_01C55099.9CE4B5E0--




From schabi@logix-tt.com Wed May  4 14:21:16 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D15115484C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  4 May 2005 11:21:16 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64504-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  4 May 2005 14:21:07 +0000 (GMT)
Received: from mail.logix-tt.com (wallaby.dingens.org [212.75.36.180])
	by svr1.postgresql.org (Postfix) with ESMTP id BA5035487B
	for <pgsql-sql@postgresql.org>; Wed,  4 May 2005 11:21:05 -0300 (ADT)
Received: from kingfisher.intern.logi-track.com (pD95DD6C8.dip0.t-ipconnect.de
	[217.93.214.200])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id C3669A86C4;
	Wed,  4 May 2005 16:21:10 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logi-track.com (Postfix) with ESMTP id D6C6BAB0DC;
	Wed,  4 May 2005 16:19:04 +0200 (CEST)
Message-ID: <4278D9D6.40602@logix-tt.com>
Date: Wed, 04 May 2005 16:19:02 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.2 (X11/20050331)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: 2000 Informatica <2000info@netsite.com.br>
Cc: PGSQL <pgsql-sql@postgresql.org>
Subject: Re: all server processes terminated; reinitializing
References: <001101c550b2$cbba4470$240000c0@lap2000>
In-Reply-To: <001101c550b2$cbba4470$240000c0@lap2000>
X-Enigmail-Version: 0.91.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200505/38
X-Sequence-Number: 21351

Hallo, 2000 Informatica,

2000 Informatica wrote:
> Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2.
> 
> Esta é a messagem gravada no meu "serverlog":
> 
> 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.

Diese Fehlermeldungen bedeuten, dass ein anderer Prozess des Servers
(also eine andere Verbindung) als die, die diese Logmeldungen
geschrieben hat, abgestürzt ist.

PostgreSQL startet in so einem Fall sicherheitshalber alle Backends neu.

Hoffe, das Hilft,
Schabi