Creating a new database on a new hard drive
Results 1 to 4 of 4
  1. #1
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default Creating a new database on a new hard drive

    I have postgres9.2\data and HM2-parent with all current databases on D:\
    I want a new database with HM2-parent on S:\

    The tutorial for moving databases all assume, that I will copy over \data\, which I can't (it's bigger than the target drive). With just a fresh new \data\ and changing the postgres imagepath in registry, the postgres service won't start again.

    How can I point postgres to a fresh \data\ path without copying over the old database?

    Once I have \data\ on S:\, I assume I can choose the HM2-parent on S:\ when creating a new database.

    Thanks.

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    You would need to install another version of Postgres to have the data folder on different locations, or just delete everything and start again.

    Yes, you can choose the parent folder when creating a database.
    Regards udbrky (Chris)

  3. #3
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    How does this work, having two different postgreses installed?

    When I install a new postgres, how do I reactivate the old? I of course want to be able to use the old database.

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

    Default

    By default Postgres is installed to work with port 5432 - and your current installation is set exactly so.
    But you can (manually) install another Postgres on port 5433
    Theoretically they both can work simultaneously - but this will complicate a life for your PC (more resources will be used).
    So in case of two Postgres installations the best way is to have running only one (or another). This is managed via Control panel - Administrative tools - Services - Stop\start service

Similar Threads

  1. Replies: 5
    Last Post: 11-28-2014, 10:38 PM
  2. Creating New Database in New SSD Hard Drive
    By GorillaMath in forum Manager General
    Replies: 3
    Last Post: 01-05-2013, 09:52 PM
  3. Moving HM database to new hard-drive
    By smokedog1878 in forum Manager General
    Replies: 5
    Last Post: 07-09-2011, 02:24 PM

Posting Permissions

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