On 07/11/2012 08:58 PM, martin soethof wrote:
Hello
I have the following situation.
I used a postgres installer that can choose seperate paths for the normal postgres and the data folder.
I used this because i wanted to share a database on an external hard drive between 2 computers.
It'll work so long as both computers are running the same PostgreSQL major version (same x.y version) built with the same options and the same bitness (32- or 64-bit). I'd use replication instead if possible, but it should work so long as the HDD isn't connected to and mounted by both computers at the same time. If you're using USB that's impossible and you'll be fine, but it's something to watch out for using FireWire or SCSI/SAS.
The main thing is that you won't be able to use it as an auto-starting Windows service. You must either start and stop the service manually when the disk is added/removed, or use pg_ctl to start/stop the DB manually.
You will also have to watch out for permissions.
Personally, I'd use pg_ctl to start/stop the DB manually. See the PostgreSQL documentation. That way you don't have to wrangle the Windows service at all.
Tomorrow i will be sitting behind PC #2, how should i install it..
Check the command lines for the EnterpriseDB installer. I'd be surprised if it didn't have a binaries-only option that allowed you to skip database creation and creation of a Windows service entry, so you can then just use pg_ctl to start/stop the DB.
--
Craig Ringer
