RE: Where is the Database log file ?

Поиск
Список
Период
Сортировка
От Ed Bras
Тема RE: Where is the Database log file ?
Дата
Msg-id 003001bf65fa$4742c210$e875adc1@pietjepuik
обсуждение исходный текст
Ответ на Where is the Database log file ?  ("Ed Bras" <e.bras@hccnet.nl>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Writing C functions
Следующее
От: Alexey Vyskubov
Дата:
Сообщение: Re: [GENERAL] Writing C functions