Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WunRY-0003ac-O4 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2014 18:40:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WunRX-00018L-Tz for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jun 2014 18:40:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WunRX-000174-73 for pgsql-admin@postgresql.org; Wed, 11 Jun 2014 18:40:15 +0000 Received: from webshield02.pjf.mg.gov.br ([187.72.160.222]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WunRP-00025s-8p for pgsql-admin@postgresql.org; Wed, 11 Jun 2014 18:40:11 +0000 Received: from email.pjf.mg.gov.br (unknown [192.168.254.25]) by webshield02.pjf.mg.gov.br with smtp id 3e3b_11c7_499626bf_7311_4eb7_b218_92b7085a164b; Wed, 11 Jun 2014 15:39:50 -0300 Received: from localhost (localhost.localdomain [127.0.0.1]) by email.pjf.mg.gov.br (Postfix) with ESMTP id D96881FD167F for ; Wed, 11 Jun 2014 15:39:50 -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 UPconpWGCcFH for ; Wed, 11 Jun 2014 15:39:50 -0300 (BRT) Received: from P01157228 (unknown [10.0.12.49]) by email.pjf.mg.gov.br (Postfix) with ESMTPSA id 8D13E1FD167F for ; Wed, 11 Jun 2014 15:39:46 -0300 (BRT) Message-ID: <80882A6B373D4F42B38B6A3407EE5BCD@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> <982D5F2869644B77AB1A5A5FCBF449CD@P01157228> In-Reply-To: <982D5F2869644B77AB1A5A5FCBF449CD@P01157228> Subject: Read Postgres Log remotely Date: Wed, 11 Jun 2014 15:39:45 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response 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 <1210291> : uri <1778072> X-Pg-Spam-Score: -0.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: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin