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:34:01
Message-ID: 982D5F2869644B77AB1A5A5FCBF449CD@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:

pg_read_file select ('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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Eduardo Sá dos Reis 2014-06-11 18:39:45 Read Postgres Log remotely
Previous Message Tom Lane 2014-06-11 18:27:17 Re: Question re privileges on extensions