Re: question about installation

Craig Ringer <ringerc@xxxxxxxxxxxxx> · Thu, 12 Jul 2012 08:27:29 +0800



    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