Thread: Sharing Postgres Files

Sharing Postgres Files

From
"Sean Weissensee"
Date:
We have 2 Web Servers running,
 
what I like to do is have the postgres DB on a file server so that both Web Servers can
access this information,
 
1). Do I copy the /var/lib/pgsql tree to the file server ?
     Is this all I need to copy.
 
2) The file server is a Samba server, is this going to have any
    affect accessing the DB?
 
 
 
Sean
 
ION Solutions.
 

Re: Sharing Postgres Files

From
Matt Beauregard
Date:
On Mon, Nov 06, 2000 at 04:14:51PM +1000, Sean Weissensee wrote:
> We have 2 Web Servers running,
>
> what I like to do is have the postgres DB on a file server so that
both Web Servers can access this information,

I'm pretty sure that this won't work.  You would be better to run one
database server on the machine of your choice, with local datafiles,
and have both web servers connect to the database server using
internet sockets.


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633