Re: Row values

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Juan Jose Costello Levien <jcostello(at)datafull(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Row values
Date: 2004-07-02 23:07:10
Message-ID: 20040702230710.GB2709@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 02, 2004 at 09:56:43AM -0300, Juan Jose Costello Levien wrote:
> Alvaro,
>
> Sorry, but, where are the log file and core you mentioned? I tried
> /var/log/postgresql but is in 0 file size.

Your server may be misconfigured (most linux distros are). Make sure
your init script does not redirect postmaster's (or pg_ctl's)
stdout/stderr to /dev/null. Also make sure that if you are using
syslog, the syslog server is configured to save the messages somewhere
useful, by checking the facility Postgres uses (configurable) and where
does syslog save messages from this facility.

The core file, on the other hand, should be somewhere in
/var/lib/pgsql/data/base (if you haven't changed PGDATA), _unless_ the
server runs under a core 0-byte limit (under bash, ulimit -c will tell
you).

Hope this helps,

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Java is clearly an example of a money oriented programming" (A. Stepanov)

In response to

  • Re: Row values at 2004-07-02 12:56:43 from Juan Jose Costello Levien

Browse pgsql-general by date

  From Date Subject
Next Message Andy B 2004-07-02 23:42:34 Re: Enough RAM for entire Database.. cost aside, is this
Previous Message Stephan Szabo 2004-07-02 22:23:55 Re: Interpreting query plan