X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ECB123A458B for ; Wed, 27 Oct 2004 08:50:19 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33321-10 for ; Wed, 27 Oct 2004 07:50:13 +0000 (GMT) Received: from candice.isogo.co.za (outsmtp.isogo.co.za [196.15.191.4]) by svr1.postgresql.org (Postfix) with ESMTP id 4DE4D3A3D0B for ; Wed, 27 Oct 2004 08:50:10 +0100 (BST) Received: (qmail 17745 invoked by uid 1035); 27 Oct 2004 07:50:06 -0000 Received: from justin@isogo.co.za by mail by uid 89 with qmail-scanner-1.20rc3 (clamscan: 0.60. spamassassin: 2.60. Clear:RC:1:. Processed in 0.308313 secs); 27 Oct 2004 07:50:06 -0000 Received: from host29.isogo.co.za (HELO ?10.5.200.29?) (justin@isogo.co.za@196.15.191.29) by candice.echelon.z with SMTP; 27 Oct 2004 07:50:04 -0000 Message-ID: <417F532B.2030400@isogo.co.za> Date: Wed, 27 Oct 2004 09:50:03 +0200 From: Justin Wyer User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joolz , pgsql-php@postgresql.org Subject: Re: working with blobs in a two-server setup References: <34529.10.0.4.254.1098862954.squirrel@webmail.arbodienst-limburg.nl> In-Reply-To: <34529.10.0.4.254.1098862954.squirrel@webmail.arbodienst-limburg.nl> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/9 X-Sequence-Number: 2942 Joolz wrote: >Hi everyone, > >I have a two server setup (both debian stable) with apache and the >PHP engine on server1 and postgresql on server2. My application >should be able to store BLOBs in the database. In a test environment >where everything was running on a single server it was OK (I used >the ADBOdb lo functions there) but now I get into all sorts of >trouble: the database can't find the uploaded file, which makes >sense: it's in /tmp on server1! :-( > >Does anyone know how I can handle this or have a pointer to a howto? > >Thanks! > > > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > move the file to a location on server2?