starting log problems 
Author Message
 starting log problems

Hi.

I've got compiled a postgresql-7.1.3 into a Debian Sid box (linux). All
works fine, but sometimes, when I go to look the log, this is set to
"zero", is empty. The postgresql don't write anything into it file.
I don't know if it occurs when stop-start postgres, or has any problem,
or... well, i don't know.
In the syslog, messages, or any sistem-log, don't show any problem... ??

Anybody can help me, please?
Excuse me my bad english... :(

Have a nice day ;-)
TooManySecrets

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sun, 25 Jul 2004 19:24:10 GMT
 starting log problems

This is a multi-part message in MIME format.

------=_NextPart_000_0042_01C1AF12.D6C79240
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

My postmaster is started with :
su -l postgres -s /bin/sh -c "/usr/local/pgsql/bin/pg_ctl -D $PGDATA -o "-i=
" -p /usr/local/pgsql/bin/postmaster start  >> /var/log/pgsql 2>&1" < /dev/=
null
This is an excerpt from my data/postgresql.conf file, that sets (some) logg=
ing parameters :
##       Debug display##silent_mode =3D false
log_connections =3D truelog_timestamp =3D true#log_pid =3D false
#debug_level =3D 0 # range 0-16
debug_print_query =3D true#debug_print_parse =3D false#debug_print_rewritte=
n =3D false#debug_print_plan =3D falsedebug_pretty_print =3D true

Quote:
> Hi.> > I've got compiled a postgresql-7.1.3 into a Debian Sid box (linux)=

. All> works fine, but sometimes, when I go to look the log, this is set to=
Quote:
> "zero", is empty. The postgresql don't write anything into it file.> I do=

n't know if it occurs when stop-start postgres, or has any problem,> or... =
well, i don't know.> In the syslog, messages, or any sistem-log, don't show=
 any problem... =BF?> > Anybody can help me, please?> Excuse me my bad engl=
ish... :(> > Have a nice day ;-)> TooManySecrets> > > > -------------------=
--------(end of broadcast)---------------------------> TIP 6: Have you sear=
ched our list archives?> > http://archives.postgresql.org

------=_NextPart_000_0042_01C1AF12.D6C79240
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.2479.6" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>My postmaster is started with :</FONT></DI=
V><PRE>su -l postgres -s /bin/sh -c "/usr/local/pgsql/bin/pg_ctl -D $PGDATA=
 -o "-i" -p /usr/local/pgsql/bin/postmaster start&nbsp; &gt;&gt; /var/log/p=
gsql 2&gt;&amp;1" &lt; /dev/null</PRE>
<DIV><FONT face=3DArial size=3D2>This is an excerpt&nbsp;from my=20
data/postgresql.conf file, that sets (some) logging parameters :</FONT></DI=
V><PRE>#<BR>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Debug display<BR>#<BR>#si=
lent_mode =3D false</PRE><PRE>log_connections =3D true<BR>log_timestamp =3D=
 true<BR>#log_pid =3D false</PRE><PRE>#debug_level =3D 0 # range 0-16</PRE>=
<PRE>debug_print_query =3D true<BR>#debug_print_parse =3D false<BR>#debug_p=
rint_rewritten =3D false<BR>#debug_print_plan =3D false<BR>debug_pretty_pri=
nt =3D true<BR><FONT face=3DArial size=3D2><BR><BR></FONT></PRE><PRE><FONT =
face=3DArial size=3D2>&gt; Hi.<BR>&gt; <BR>&gt; I've got compiled a postgre=
sql-7.1.3 into a Debian Sid box (linux). All<BR>&gt; works fine, but someti=
mes, when I go to look the log, this is set to<BR>&gt; "zero", is empty. Th=
e postgresql don't write anything into it file.<BR>&gt; I don't know if it =
occurs when stop-start postgres, or has any problem,<BR>&gt; or... well, i =
don't know.<BR>&gt; In the syslog, messages, or any sistem-log, don't show =
any problem... =BF?<BR>&gt; <BR>&gt; Anybody can help me, please?<BR>&gt; E=
xcuse me my bad english... :(<BR>&gt; <BR>&gt; Have a nice day ;-)<BR>&gt; =
TooManySecrets<BR>&gt; <BR>&gt; <BR>&gt; <BR>&gt; -------------------------=
--(end of broadcast)---------------------------<BR>&gt; TIP 6: Have you sea=
rched our list archives?<BR>&gt; <BR>&gt; </FONT><A href=3D"http://archives=
.postgresql.org"><FONT face=3DArial size=3D2>http://archives.postgresql.org=
</FONT></A></PRE></BODY></HTML>

------=_NextPart_000_0042_01C1AF12.D6C79240--



Sun, 25 Jul 2004 19:41:03 GMT
 starting log problems

Quote:

> I've got compiled a postgresql-7.1.3 into a Debian Sid box (linux). All
> works fine, but sometimes, when I go to look the log, this is set to
> "zero", is empty. The postgresql don't write anything into it file.

Bit of a stretch, but: is it possible you have things configured to send
log output to syslog, instead of stderr?

Do you ever get any log output, or does it only fail some of the time?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 25 Jul 2004 23:51:22 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Problems starting in ARCHIVE LOG mode...

2. URGENT:start IOL5 without log.logs?

3. Auto Start Mail Client problem, works fine when started manually

4. Negative Log device size and problem in restoring DB by applying Log

5. Log. logs problem

6. Log Miner : Performance problem querying archived logs

7. Negative Log device size and problem in restoring DB by applying Log

8. Log reader agent won't start !!!

9. SQL Server will not start, due to Log in failure

10. transaction log start/end times??

11. HELP - SQL Srvr won't start - logs full

12. MSDTC fails to start, log file full


 
Powered by phpBB® Forum Software