sharing postgres DB

[fortysixandtwo at metashadow.com]

>> On Sunnudagur 27 apríl 2008, fortysixandtwo at metashadow.com wrote:
>>> yes, they are.  i have all the mp3s on a file server, which i mount on
>>> the
>>> same dir on all boxes.  is there a way i can perhaps but the sqlite dir
>>> on
>>> an NFS share and have them all use it?
>>
>> Have you tried using mysql?  I have used it successfully to share the
>> database.  You simply point all computers to use the same database and
>> it
>> works, provided that the paths are the same.  There should also be an
>> howto
>> somewhere on transferring the data from sqlite to mysql, but I am to
>> lazy
>> to
>> look it up.
>>
>
> in the original thread, i was trying to use postgres.  since i am already
> using postgres for other purposes, i would like to use postgres for this
> also.  is there any reason why it would work with mysql and with postgres.
>
>

sorry, cat stepped on the keyboard and the message get sent before i was
finished...

what i was wondering if there is any reason why it would with mysql and
not with postgres?  using sqlite on a shared resource was just a plan b if
i couldn't get postgres to work.

thanks,
-=- adam grossman