Обсуждение: working with blobs in a two-server setup

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!

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?