Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9760D9FB3B9 for ; Wed, 31 Jan 2007 07:35:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 21780-01 for ; Wed, 31 Jan 2007 07:35:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id B59299FB312 for ; Wed, 31 Jan 2007 07:35:05 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so128797ugf for ; Wed, 31 Jan 2007 03:35:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=cYinCXrZBrvhxmIZQDmS6DcoB+n9DiKm7e1CTpAtgRw+huPHMfr1t8GiOy88LhwFt9161hTD5sOk3Fw7OijufY1w8AgKLHAzaLsN2M/tzcqI1cRJj+O46ZZlmL+YMyVJkA+74VeGEgGLIQaRvK3v4Pp1TJb4TJJOizUhjIpID60= Received: by 10.66.252.4 with SMTP id z4mr865683ugh.1170243303891; Wed, 31 Jan 2007 03:35:03 -0800 (PST) Received: by 10.66.217.13 with HTTP; Wed, 31 Jan 2007 03:35:03 -0800 (PST) Message-ID: <55c095e90701310335x12d824a4q8798638503e45388@mail.gmail.com> Date: Wed, 31 Jan 2007 09:35:03 -0200 From: "Ezequias Rodrigues da Rocha" To: "Andrew Sullivan" Subject: Re: Log, Logs and more Logs Cc: pgsql-sql@postgresql.org In-Reply-To: <20070130213304.GA561@phlogiston.dyndns.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1165_20633777.1170243303471" References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <20070130172651.GD32170@phlogiston.dyndns.org> <55c095e90701301041u68c5acc7i99517994724aa6d4@mail.gmail.com> <20070130213304.GA561@phlogiston.dyndns.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/169 X-Sequence-Number: 27321 ------=_Part_1165_20633777.1170243303471 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I noticed today morning that my pg.log doesn't exist in my server. Why it occurs ? My /var/lib/pgsql/data is like that: [root@linux1 data]# ls -la total 92 drwx------ 10 postgres postgres 4096 Jan 31 08:35 . drwx------ 4 postgres postgres 4096 Jul 26 2006 .. drwx------ 7 postgres postgres 4096 Jan 30 12:29 base drwx------ 2 postgres postgres 4096 Jan 31 08:44 global drwx------ 2 postgres postgres 4096 Feb 17 2006 pg_clog -rw------- 1 postgres postgres 3513 Sep 14 15:28 pg_hba.conf -rw------- 1 postgres postgres 1460 Feb 17 2006 pg_ident.conf drwx------ 4 postgres postgres 4096 Feb 17 2006 pg_multixact drwx------ 2 postgres postgres 4096 Jan 28 16:00 pg_subtrans drwx------ 2 postgres postgres 4096 Feb 17 2006 pg_tblspc drwx------ 2 postgres postgres 4096 Feb 17 2006 pg_twophase -rw------- 1 postgres postgres 4 Feb 17 2006 PG_VERSION drwx------ 3 postgres postgres 4096 Jan 30 13:14 pg_xlog -rw------- 1 postgres postgres 14079 Jan 30 14:42 postgresql.conf -rw-r--r-- 1 root root 13652 Mar 17 2006 postgresql.conf.old -rw------- 1 postgres postgres 49 Jan 31 08:36 postmaster.opts -rw------- 1 postgres postgres 45 Jan 31 08:36 postmaster.pid [root@linux1 data]# Can someone tell me how to solve this kind of problem ? Ezequias 2007/1/30, Andrew Sullivan : > On Tue, Jan 30, 2007 at 04:41:13PM -0200, Ezequias Rodrigues da Rocha wrote: > > So you are tell me that it is impossible to retrieve it ok ? > > No. > > > Just by changing this values (what I did now) it is possible to get > > the error messages and their statements OK?. > > Yes, but you need to signal the postmaster to reload its config file. > Either kill -SIGHUP or restart the postmaster. After that, you > should see the statement that caused your error. Note that if the > UPDATE itself doesn't cause the error, but say a later COMMIT (you > can get this in serializable mode easily), you'll see the COMMIT as > the thing that caused the error. > > A > > -- > Andrew Sullivan | ajs@crankycanuck.ca > Unfortunately reformatting the Internet is a little more painful > than reformatting your hard drive when it gets out of whack. > --Scott Morris > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_1165_20633777.1170243303471 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I noticed today morning that my pg.log doesn't exist in my server.
=
Why it occurs ?

My /var/lib/p= gsql/data is like that:

[root@linux1 data]# ls -la
total 9= 2
drwx------  10 postgres postgres  4096 Jan 31 08:35= .
drwx------   4 postgres postgres  4096 Jul 26&nbs= p; 2006 ..
drwx------   7 postgres postgres  40= 96 Jan 30 12:29 base
drwx------   2 postgres postgres &nb= sp;4096 Jan 31 08:44 global
drwx------   2 postgres postgres  4096 Feb 17 =  2006 pg_clog
-rw-------   1 postgres postgres  = ;3513 Sep 14 15:28 pg_hba.conf
-rw-------   1 postgres postgre= s  1460 Feb 17  2006 pg_ident.conf
drwx------ &= nbsp; 4 postgres postgres  4096 Feb 17  2006 pg_multixa= ct
drwx------   2 postgres postgres  4096 Jan 28 16:00= pg_subtrans
drwx------   2 postgres postgres  4096 = Feb 17  2006 pg_tblspc
drwx------   2 postgres postg= res  4096 Feb 17  2006 pg_twophase
-rw------- &= nbsp; 1 postgres postgres     4 Feb 17  2006 = PG_VERSION
drwx------   3 postgres postgres  4096 Jan 30 13:14= pg_xlog
-rw-------   1 postgres postgres 14079 Jan 30 14:42 p= ostgresql.conf
-rw-r--r--   1 root     roo= t     13652 Mar 17  2006 postgresql.conf.old<= br>-rw-------   1 postgres postgres    49 Jan= 31 08:36=20 postmaster.opts
-rw-------   1 postgres postgres  &n= bsp; 45 Jan 31 08:36 postmaster.pid
[root@linux1 data]#

Can = someone tell me how to solve this kind of problem ?


Ezequias
2007/1/30, Andrew Sullivan <ajs@crankycanuck.ca>:
> On Tue, Jan 30, 2007 at 04:41:13= PM -0200, Ezequias Rodrigues da Rocha wrote:
> > So you are tell m= e that it is impossible to retrieve it ok ?
>
> No.
>
> > Just by changing this values (w= hat I did now) it is possible to get
> > the error messages and th= eir statements OK?.
>
> Yes, but you need to signal the postma= ster to reload its config file.
> Either kill -SIGHUP or restart the postmaster.  After th= at, you
> should see the statement that caused your error.  = ;Note that if the
> UPDATE itself doesn't cause the error, but sa= y a later COMMIT (you
> can get this in serializable mode easily), you'll see the COMM= IT as
> the thing that caused the error.
>
> A
> <= br>> --
> Andrew Sullivan  | ajs@crankycanuck.ca
> Unfortunately reformatting the Internet is = a little more painful
> than reformatting your hard drive when it get= s out of whack.
>        &nbs= p;        --Scott Morris
>
>= ; ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropria= te
>        subscribe-nomail = command to majordomo@postgresql= .org so that your
>       &nbs= p;message can get through to the mailing list cleanly
>


--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D
          = ;            &n= bsp;           Atenc= iosamente (Sincerely)
        &n= bsp;            = ;   Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditadurasThe worst of democracies is still better than the better of dictatorships=
http://ezequiasrocha.blo= gspot.com/
------=_Part_1165_20633777.1170243303471--