RE: Where is the Database log file ? - Mailing list pgsql-general

From Ed Bras
Subject RE: Where is the Database log file ?
Date
Msg-id 003001bf65fa$4742c210$e875adc1@pietjepuik
Whole thread Raw
In response to Where is the Database log file ?  ("Ed Bras" <e.bras@hccnet.nl>)
List pgsql-general
> In th documentation thay talk about a database log file which is used in
for example RAISE NOTICE.
> Where can I find this (the log file) ? and how can I see this kind of
information in the system tables ?
>
> Postmaster writes its messages to stdout (stderr?).

> So we start it in /etc/init.d/postgres with:

> su - postgres -c "source /usr/dblocal/pgsql/.login;
/usr/dblocal/pgsql/bin/postmaster -i -o -e >>&
/usr/dblocal/pgsql/server.log&"

> and the output will be in /usr/dblocal/pgsql/server.log.

Howwww, I am sorry but you are going a bit too fast I think.
I don't really understand which part is responsible for the logging ? Please
give a bit more info ?
The only thing I have in /etc/rc.d/init.d/postgres is (the starting of the
postmaster:

  su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'

and nothing about some logging commands (neither does server.log excits) !!

Regards,
Ed Bras








pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Writing C functions
Next
From: Alexey Vyskubov
Date:
Subject: Re: [GENERAL] Writing C functions