Read Postgres Log remotely

From: Eduardo Sá dos Reis <eduardoreis(at)pjf(dot)mg(dot)gov(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Read Postgres Log remotely
Date: 2014-06-11 18:39:45
Message-ID: 80882A6B373D4F42B38B6A3407EE5BCD@P01157228
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I need to read files postgres log remotely.
I'm using the command:

select pg_read_file('pg_log/postgresql-2014-06-11_000000.log' , 0 ,
10000000);

The result is just the first line of the file.

How do I read every line of the file?

Grateful.
Eduardo Reis

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message liuyuanyuan 2014-06-12 06:03:57 How to use pg_setting.csv ?
Previous Message Eduardo Sá dos Reis 2014-06-11 18:34:01 Read Postgres Log remotely