can't start PostgreSQL service after moving data to second hard drive
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Oct 2011
    Posts
    23

    Question can't start PostgreSQL service after moving data to second hard drive

    My C drive filled up [edit: actually my D drive], so I carefully followed the instructions here to move my PostgreSQL data folder (all 18 Gig of it) to a second hard disk.

    PostgreSQL is installed in "D:\Program Files (x86)\PostgreSQL\8.3\"
    And now my data folder is "P:\Program Files (x86)\PostgreSQL\8.3\data"

    I did everything in the instructions, including changing the ImagePath registry entry to:
    Code:
    "D:\Program Files (x86)\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "P:\Program Files (x86)\PostgreSQL\8.3\data\"
    I also checked the permissions for the newly created data folder. Full Control is granted to everyone.

    But having done all this (and rebooted) I now can't get the database service to start up.

    When I 'Start service', the command-prompt window pops up as usual, but the service never starts:
    Code:
    The PostgreSQL Database Server 8.3 service is starting..........................
    How can I find out what's going wrong?
    Last edited by Russelldust; 10-22-2011 at 11:48 AM.

  2. #2
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,519

    Default

    set Windows to show all files including hidden and system
    How to see hidden files in Windows
    - It should look like this: http://rvgsoftware.fileburst.com/images/hidden.jpg

    delete the ...\data\postmaster.pid file, if you see it.
    and postmaster.opts
    Do not delete any other files
    Then reboot PC

  3. #3
    Junior Member
    Join Date
    Oct 2011
    Posts
    23

    Default

    Thanks for the suggestion - didn't make any difference though.

    I've noticed that nothing is being written to the pg_log folder.
    I've check that it's not a firewall issue (and besides, everything worked just fine before I moved the data folder).

    Any other ideas?

  4. #4
    Junior Member
    Join Date
    Oct 2011
    Posts
    23

    Default

    Ok I think it was a file permissions thing after all. I re-applied the access permissions so that literally everyone can access the new Program Files folder and everything beneath, and now the service works fine.

    Sorry for my oversight, and thanks for the advice.

Similar Threads

  1. Moving HM database to new hard-drive
    By smokedog1878 in forum Manager General
    Replies: 5
    Last Post: 07-09-2011, 02:24 PM
  2. Moving database to hard drive & then to new computer
    By Nebulae in forum Manager General
    Replies: 1
    Last Post: 04-07-2011, 11:23 AM
  3. Moving data base to an external hard drive
    By gring000h in forum Manager General
    Replies: 11
    Last Post: 11-27-2009, 12:32 PM
  4. Stop Service/Start Service: PostgreSQL
    By LowWater in forum Manager General
    Replies: 2
    Last Post: 06-10-2009, 10:12 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •