Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WunLw-0003QE-Fc for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2014 18:34:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WunLv-0005DT-W4 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2014 18:34:28 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WunLv-0005DJ-4h for pgsql-admin@postgresql.org; Wed, 11 Jun 2014 18:34:27 +0000 Received: from webshield02.pjf.mg.gov.br ([187.72.160.222]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WunLq-0003rj-0b for pgsql-admin@postgresql.org; Wed, 11 Jun 2014 18:34:25 +0000 Received: from email.pjf.mg.gov.br (unknown [192.168.254.25]) by webshield02.pjf.mg.gov.br with smtp id 3e3b_1183_b08781f7_0d5b_49ea_9d69_df768db46417; Wed, 11 Jun 2014 15:34:05 -0300 Received: from localhost (localhost.localdomain [127.0.0.1]) by email.pjf.mg.gov.br (Postfix) with ESMTP id 00D732261802 for ; Wed, 11 Jun 2014 15:34:06 -0300 (BRT) X-Virus-Scanned: amavisd-new at pjf.mg.gov.br Received: from email.pjf.mg.gov.br ([127.0.0.1]) by localhost (email.pjf.mg.gov.br [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id ofC-_yIVzoNV for ; Wed, 11 Jun 2014 15:34:05 -0300 (BRT) Received: from P01157228 (unknown [10.0.12.49]) by email.pjf.mg.gov.br (Postfix) with ESMTPSA id 6C5D922617EF for ; Wed, 11 Jun 2014 15:34:02 -0300 (BRT) Message-ID: <982D5F2869644B77AB1A5A5FCBF449CD@P01157228> From: =?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= To: References: <1402507690.19836.YahooMailNeo@web122306.mail.ne1.yahoo.com> <26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC> <1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com> In-Reply-To: <1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com> Subject: Read Postgres Log remotely Date: Wed, 11 Jun 2014 15:34:01 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Mailer: Microsoft Windows Live Mail 16.4.3528.331 X-MimeOLE: Produced By Microsoft MimeOLE V16.4.3528.331 X-NAI-Spam-Flag: NO X-NAI-Spam-Level: X-NAI-Spam-Threshold: 2 X-NAI-Spam-Score: 0.3 X-NAI-Spam-Rules: 3 Rules triggered FROM_NAME=0.2, BODY_START_GREETING=0.1, RV4970=0 X-NAI-Spam-Version: 2.3.0.9378 : core <4970> : inlines <983> : streams <1210289> : uri <1778070> X-Pg-Spam-Score: 1.6 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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