Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5F0649FA4D1 for ; Wed, 31 Jan 2007 08:18:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 98535-07 for ; Wed, 31 Jan 2007 08:18:13 -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.175]) by postgresql.org (Postfix) with ESMTP id 217D69FA315 for ; Wed, 31 Jan 2007 08:18:28 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so136471ugf for ; Wed, 31 Jan 2007 04:18:27 -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:content-transfer-encoding:content-disposition:references; b=Qfd+Ag/1ezsuWESbOfG5Ku7aGoMJ3hl/Xv55m11wDFV2/dns5GZrqwEn/VCUbzHR5sHP4j5RDqz0J+f8nATIe63THLPkHc/qU2BfGw7LPZAxUy/9C1Ynz/kfzw3x9vIXC3n+KR7SHii+hnL9dUrJCCY1WGLy1vzUFd5Mkv5sfUk= Received: by 10.82.184.2 with SMTP id h2mr139631buf.1170245907209; Wed, 31 Jan 2007 04:18:27 -0800 (PST) Received: by 10.82.183.4 with HTTP; Wed, 31 Jan 2007 04:18:27 -0800 (PST) Message-ID: <1f30b80c0701310418l711fd82dm957fa7f51d8d0e1@mail.gmail.com> Date: Wed, 31 Jan 2007 17:18:27 +0500 From: imad To: "Ezequias Rodrigues da Rocha" Subject: Re: Log, Logs and more Logs Cc: "Shoaib Mir" , "Andrew Sullivan" , pgsql-sql@postgresql.org In-Reply-To: <55c095e90701310404q64c9e33cgc821268cb8723ac@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <20070130172651.GD32170@phlogiston.dyndns.org> <55c095e90701301041u68c5acc7i99517994724aa6d4@mail.gmail.com> <20070130213304.GA561@phlogiston.dyndns.org> <55c095e90701310335x12d824a4q8798638503e45388@mail.gmail.com> <55c095e90701310404q64c9e33cgc821268cb8723ac@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/173 X-Sequence-Number: 27325 Change it in the postgresql.conf file only if you want to make it permanent= . Otherwise just set the variable for your current session without a server restart. --Imad www.EnterpriseDB.com On 1/31/07, Ezequias Rodrigues da Rocha wrote: > It was commented. Thank you Shoaib Mir > > I must restart my server ? > > Ezequias > > 2007/1/31, Shoaib Mir < shoaibmir@gmail.com>: > > Check for log_directory setting in your postgresql.conf file... > > > > ------------- > > Shoaib Mir > > EnterpriseDB (www.enterprisedb.com) > > > > > > > > On 1/31/07, Ezequias Rodrigues da Rocha wrot= e: > > > 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.o= ld > > > -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 Roc= ha > 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 g= et > > > > > the error messages and their statements OK?. > > > > > > > > Yes, but you need to signal the postmaster to reload its config fil= e. > > > > 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 appropriat= e > > > > subscribe-nomail command to majordomo@postgresql.org so that > your > > > > 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 > > > 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/ > > > > > > > > > > > -- > =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/