Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkp7e-0001o7-7p for pgsql-admin@arkaria.postgresql.org; Wed, 01 Aug 2018 11:16:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fkp7c-0004v8-Mw for pgsql-admin@arkaria.postgresql.org; Wed, 01 Aug 2018 11:16:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkp7b-0004v1-Qx for pgsql-admin@lists.postgresql.org; Wed, 01 Aug 2018 11:16:52 +0000 Received: from sonic317-3.consmr.mail.ne1.yahoo.com ([66.163.184.230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fkp7Y-00031t-GV for pgsql-admin@lists.postgresql.org; Wed, 01 Aug 2018 11:16:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1533122204; bh=n5HXVqhoCfXEyAHBZsN+d+YIpmMLKnCTfm116MrxOWo=; h=Date:From:To:Subject:References:From:Subject; b=Q/MBdYWeMa6Ilvv9hGrBpZta8oSvkUXDesy2KFzTA5sNL/SbErwiqPXTjHORJV4GZMX9BjY6gL32RIl9IjDpa9MhbMPiGXm8EDfwxoTn4GfWL187Ueeokv7kZvc6ItuOIRPjL4K1V0950iniH6oh3fYjAuzmDqEJ/WQQ9dw+wcHIvWkTyzocssOhzrNl10N59HGPOisvzhDhHxGpQYUNuoYSjslZAjigvLqErm4x5BnY1iWMo0tdRKYBp/i+lQYuuK7OKH1H2Um0SiFAbEkTDfQFQhKDH0H3/kfJj+sumC/UPA1Z+oSiaH8JjqwYLtXJOFGPdcPsZ231nEa8Kv63yA== X-YMail-OSG: G8a.CwAVM1k4kJ27V4wj31tmLfwqLwb00oPcAABmoK0MCjGcfyy.Zpx3Ek1Clj3 2Px808KxqB.ui1eRjKE8eUsj3PXGRoKMleitYRmjhG_BpQu0K4YyGtheeh9e2QNJLZ_xSFfiZyj7 l8c08eRXFtmrTWQudFlKwa6ZKmz7qPVTYPf9FXBnVABl0Ma77u_AwAQ6SbFiSF0OVKp8oebpMsqp 6SAzI3_FjgfoQkN3jBX9x5.NWg6yF0Z8oBnGXJy_2OBi0BNsR09v5IdQZAuU2W.MQy1H3xjHB.Vh KZrcMQPMlSnm5LTMF.TtkSEGGXOqT.gmmrx7wl0bH3OiZu37Wu.O3LCXqTOJh9N0ww8K6nQChALM NVywGnCH6tqCEgPuI_i4B_PfGnQsyKE2zXnc8Q4koSfD5v5hlbpaVNundht5pNKmNDUoPkWQchfI vNjZoO3wyJmdh3PSdTHFYE1gPsPIAS_d6k6TAP05WbENm3Y.tgbCxcC5novnCm9gYKQZ8FKUpbhX CArFOYkOcnZNvTGiErSR0Rcc1rhXyyzgU.O8B0pK2T21mYhZCWyvnP06MuZ5VyNOeGyjRr_yNiLY rnXvckPJMqPDTvd0LQuKLzaMsxY4wkwuNAU0.NP8DIJA.GJRNJuYVJgZ30HoTQJnfavK2Jx27MTI cuBRbNrXgvbQPMgJLWDXdXnzBskav12Sj6VqIni4Zo9YcQXR3Aglwtdkus4S0129XpuabScCvLfH gtyeX7SaoRC1oS9fTvl5btVt.VuoyOXv6RhD77QcE06ndt8cfylr434GrFKeWapfWTspMcE5XfaA NS1Z4LtO.jNDUDw6ZdUZ6jltomGkpC75mItI0pZJcomFS_XkvC4DVjfLG3Ek2YuTSnmFgD0S4H.y 9IlaluBAeknfZuMa1UaOsYl_GbH.1B65RCXbRbVvH1zc_d_BR3.FWFvg88wSJ Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Wed, 1 Aug 2018 11:16:44 +0000 Date: Wed, 1 Aug 2018 11:12:41 +0000 (UTC) From: Nelson Gonzaga To: "pgsql-admin@lists.postgresql.org" Message-ID: <1160328940.343057.1533121961953@mail.yahoo.com> Subject: Grant on lo_export() MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_343056_310951558.1533121961951" References: <1160328940.343057.1533121961953.ref@mail.yahoo.com> X-Mailer: WebService/1.1.12206 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36 Content-Length: 2097 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_343056_310951558.1533121961951 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi all,I'm trying to use lo_import / lo_export and apparently I have permission denied: command:select lo_export(oid_imagem, '/tmp2/erro_export1.png') fromimagem where nome_imagem = 'erro'; ERROR: mustbe superuser to use server-side lo_export()SQL state:42501Hint:Anyone can use the client-side lo_export() provided by libpq. It's okay when I enter the data as superuser like this:insert into image (image_name, oid_picture) values ('error1', lo_import ('/ tmp2 / erro.png')); and the table:create table image (image_name varchar (20), oid_image oid); I Use Linux Debian 7 and Postgresql 9.4 Any idea? ------=_Part_343056_310951558.1533121961951 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hi all,
I'm trying to use lo_import / lo_export and apparently I have permission denied:

command:
select lo_export(oid_imagem, '/tmp2/erro_export1.png') from imagem where nome_imagem = 'erro';

ERROR: must be superuser to use server-side lo_export()
SQL state: 42501
Hint: Anyone can use the client-side lo_export() provided by libpq.


It's okay when I enter the data as superuser like this:
insert into image (image_name, oid_picture) values ('error1', lo_import ('/ tmp2 / erro.png'));

and the table:
create table image (image_name varchar (20), oid_image oid);

I Use Linux Debian 7 and Postgresql 9.4

Any idea?



------=_Part_343056_310951558.1533121961951--