pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
To: pgsql-admin@postgresql.org
Subject: Read Postgres Log remotely
Date: Wed, 11 Jun 2014 15:34:01 -0300
Message-ID: <982D5F2869644B77AB1A5A5FCBF449CD@P01157228> (raw)
In-Reply-To: <1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com>
References: <1402507690.19836.YahooMailNeo@web122306.mail.ne1.yahoo.com>
	<26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC>
	<1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

view thread (2+ messages)  latest in thread

Message-ID: <982D5F2869644B77AB1A5A5FCBF449CD@P01157228>
Permalink:  ../982D5F2869644B77AB1A5A5FCBF449CD@P01157228/
Also on:    postgresql.org/message-id/982D5F2869644B77AB1A5A5FCBF449CD@P01157228

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: eduardoreis@pjf.mg.gov.br
  Subject: Re: Read Postgres Log remotely
  In-Reply-To: <982D5F2869644B77AB1A5A5FCBF449CD@P01157228>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox