Thread: 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?