Re: Log, Logs and more Logs - Mailing list pgsql-sql

I noticed today morning that my pg.log doesn't exist in my server. <br /><br />Why it occurs ?<br /><br />My <span
style="font-weight:bold;">/var/lib/pgsql/data</span> is like that:<br /><br />[root@linux1 data]# ls -la<br />total 92
<br/>drwx------  10 postgres postgres  4096 Jan 31 08:35 .<br />drwx------   4 postgres postgres  4096 Jul 26  2006
..<br/>drwx------   7 postgres postgres  4096 Jan 30 12:29 base<br />drwx------   2 postgres postgres  4096 Jan 31
08:44global <br />drwx------   2 postgres postgres  4096 Feb 17  2006 pg_clog<br />-rw-------   1 postgres
postgres  3513Sep 14 15:28 pg_hba.conf<br />-rw-------   1 postgres postgres  1460 Feb 17  2006 pg_ident.conf<br
/>drwx------  4 postgres postgres  4096 Feb 17  2006 pg_multixact <br />drwx------   2 postgres postgres  4096 Jan 28
16:00pg_subtrans<br />drwx------   2 postgres postgres  4096 Feb 17  2006 pg_tblspc<br />drwx------   2 postgres
postgres  4096Feb 17  2006 pg_twophase<br />-rw-------   1 postgres postgres     4 Feb 17  2006 PG_VERSION <br
/>drwx------  3 postgres postgres  4096 Jan 30 13:14 pg_xlog<br />-rw-------   1 postgres postgres 14079 Jan 30 14:42
postgresql.conf<br/>-rw-r--r--   1 root     root     13652 Mar 17  2006 postgresql.conf.old<br />-rw-------   1
postgrespostgres    49 Jan 31 08:36 postmaster.opts<br />-rw-------   1 postgres postgres    45 Jan 31 08:36
postmaster.pid<br/>[root@linux1 data]#<br /><br />Can someone tell me how to solve this kind of problem ?<br /><br
/><br/><span style="font-weight: bold;">Ezequias </span><br />2007/1/30, Andrew Sullivan <<a
href="mailto:ajs@crankycanuck.ca">ajs@crankycanuck.ca</a>>:<br/>> On Tue, Jan 30, 2007 at 04:41:13PM -0200,
EzequiasRodrigues da Rocha wrote:<br />> > So you are tell me that it is impossible to retrieve it ok ? <br
/>><br />> No.<br />> <br />> > Just by changing this values (what I did now) it is possible to get<br
/>>> the error messages and their statements OK?.<br />> <br />> Yes, but you need to signal the postmaster
toreload its config file. <br />> Either kill -SIGHUP or restart the postmaster.  After that, you<br />> should
seethe statement that caused your error.  Note that if the<br />> UPDATE itself doesn't cause the error, but say a
laterCOMMIT (you <br />> can get this in serializable mode easily), you'll see the COMMIT as<br />> the thing
thatcaused the error.<br />> <br />> A<br />> <br />> --<br />> Andrew Sullivan  | <a
href="mailto:ajs@crankycanuck.ca">ajs@crankycanuck.ca</a><br />> Unfortunately reformatting the Internet is a little
morepainful<br />> than reformatting your hard drive when it gets out of whack.<br />>                 --Scott
Morris<br/>> <br />> ---------------------------(end of broadcast)--------------------------- <br />> TIP 1:
ifposting/reading through Usenet, please send an appropriate<br />>        subscribe-nomail command to <a
href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a>so that your<br />>        message can get
throughto the mailing list cleanly <br />> <br /><br /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br/>                                  Atenciosamente
(Sincerely)<br/>                        Ezequias Rodrigues da Rocha<br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhor do
quea melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br /><a
href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a><br />