still no log

Existe un archivo llamado postmaster.init en el directorio de postgres, en ese
directorio le especificas si quieres que use o no los logs. Ya revisaste ese
archivo?

"Martin A. Marques" wrote:

"Martin A. Marques" wrote:

Sorry for the insistence, but after looking and looking again, I can't find
out why the postgres logs are empty. The postgres database is up and working

great, but nothing is getting logged.
I'm on a RedHat Linux (6.0 with lot of upgrades)
postgres 7.0.3 from rpm (downoaded from the postgres ftp server)

Any ideas?

If postmaster is started with -S, nothing gets logged. Is that your problem?

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Be patient therefore, brethren, unto the coming of the
Lord...Be patient; strengthen your hearts, for
the coming of the Lord draweth nigh."
James 5:7,8

El Mi� 10 Ene 2001 21:07, escribiste:

"Martin A. Marques" wrote:

Sorry for the insistence, but after looking and looking again, I can't
find out why the postgres logs are empty. The postgres database is up
and working

great, but nothing is getting logged.
I'm on a RedHat Linux (6.0 with lot of upgrades)
postgres 7.0.3 from rpm (downoaded from the postgres ftp server)

Any ideas?

If postmaster is started with -S, nothing gets logged. Is that your
problem?

Well, I'm not sure. I can't recall checking that in the startup script, but I
think it's not there. Any way, why would the instalation make the entries in
the logroutate config files and then have a startup script that won't do
logging? I'm using the normal startup script in /etc/rc.d/init.d/.

Saludos... :-)

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

I just jumped in on this thread so I'm not sure where you're looking for the
logging, but postgreSQL has the following option when building (from
'./configure --help'):

--enable-syslog enable logging to syslog

I saw that you're installing from RPM's so this won't help and I'm not even
sure that this is the logging about which you're talking, but thought I'd
post just in case!

Cheers,
Craig

-----Original Message-----
From: Martin A. Marques [mailto:martin@math.unl.edu.ar]
Sent: Wednesday, January 10, 2001 6:19 PM
To: Oliver Elphick
Cc: pgsql-general; pgsql-hackers@postgresql.org
Subject: [HACKERS] Re: still no log

El Mi� 10 Ene 2001 21:07, escribiste:

"Martin A. Marques" wrote:

Sorry for the insistence, but after looking and looking again, I can't
find out why the postgres logs are empty. The postgres database is up
and working

great, but nothing is getting logged.
I'm on a RedHat Linux (6.0 with lot of upgrades)
postgres 7.0.3 from rpm (downoaded from the postgres ftp server)

Any ideas?

If postmaster is started with -S, nothing gets logged. Is that your
problem?

Well, I'm not sure. I can't recall checking that in the startup script, but
I
think it's not there. Any way, why would the instalation make the entries in

the logroutate config files and then have a startup script that won't do
logging? I'm using the normal startup script in /etc/rc.d/init.d/.

Saludos... :-)

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

You need to edit /etc/rc.d/init.d/postgresql

change the line that looks like this:

su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start

/dev/null 2>&1"

to:

su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start

/var/log/postgres 2>&1"

Notice the appended redirection (>>) and the file name (/var/log/postgres)

I'm pretty sure the logrotate entries are disabled by default. They cannot
rotate the logs unless the postmaster is stopped/restarted at the time of
rotate and you may not want your posmaster going down unexpectedly in a 24x7
application.

As to why RPM's install this way, I have no idea. I'm just grateful they
exist.

--rob

----- Original Message -----
From: "Craig L. Ching" <cching@mqsoftware.com>
To: "'Martin A. Marques'" <martin@math.unl.edu.ar>; "Oliver Elphick"
<olly@lfix.co.uk>
Cc: "pgsql-general" <pgsql-general@postgresql.org>;
<pgsql-hackers@postgresql.org>
Sent: Wednesday, January 10, 2001 7:49 PM
Subject: RE: [HACKERS] Re: still no log

I just jumped in on this thread so I'm not sure where you're looking for

the

logging, but postgreSQL has the following option when building (from
'./configure --help'):

--enable-syslog enable logging to syslog

I saw that you're installing from RPM's so this won't help and I'm not

even

sure that this is the logging about which you're talking, but thought I'd
post just in case!

Cheers,
Craig

-----Original Message-----
From: Martin A. Marques [mailto:martin@math.unl.edu.ar]
Sent: Wednesday, January 10, 2001 6:19 PM
To: Oliver Elphick
Cc: pgsql-general; pgsql-hackers@postgresql.org
Subject: [HACKERS] Re: still no log

El Mi� 10 Ene 2001 21:07, escribiste:

"Martin A. Marques" wrote:

Sorry for the insistence, but after looking and looking again, I

can't

find out why the postgres logs are empty. The postgres database is

up

and working

great, but nothing is getting logged.
I'm on a RedHat Linux (6.0 with lot of upgrades)
postgres 7.0.3 from rpm (downoaded from the postgres ftp server)

Any ideas?

If postmaster is started with -S, nothing gets logged. Is that your
problem?

Well, I'm not sure. I can't recall checking that in the startup script,

but

I
think it's not there. Any way, why would the instalation make the entries

in

El Mi� 10 Ene 2001 20:55, Alfonso Peniche escribi�:

Existe un archivo llamado postmaster.init en el directorio de postgres, en
ese directorio le especificas si quieres que use o no los logs. Ya
revisaste ese archivo?

No existe tal archivo, pero ya lo sulocione.
Gracias de todas formas. ;-)

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Mart�n Marqu�s email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------