Open Side Menu Go to the Top

07-28-2008 , 04:55 PM
On my old computer I installed PostgreSQL on my external hard drive. Now I have a new computer, but the same external hard drive. What do I have to do to "install" PostgreSQL onto the new computer so that the databases remain intact?
PostgreSQL on external drive Quote
PostgreSQL on external drive
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
PostgreSQL on external drive
07-28-2008 , 05:56 PM
depends how you installed postgresql on the external drive... the whole thing, just the $pg_data or even just a tablespace?
PostgreSQL on external drive Quote
07-28-2008 , 06:03 PM
I installed the whole thing on the external.
PostgreSQL on external drive Quote
07-28-2008 , 06:10 PM
then really all you need do is create the limited user account "postgres" on the new machine, and start the server as that user - not that I know how to do that on windows, nor add the startup command to autorun as a service I think you can see the startup / shutdown commands by looking at the start menu shortcuts on a system where postgresql is installed already.

do you remember what version you installed? if so, I'd likely just install it to the same location on the external HDD (and untcheck the option to "initiate the database cluster") - that will take care of account / service creation I believe, and it should just start using the existing $pg_data folder.
PostgreSQL on external drive Quote
07-28-2008 , 06:17 PM
i'd probably copy/paste the whole folder / rename from the external drive, just in case something goes horribly wrong
PostgreSQL on external drive Quote
07-28-2008 , 11:42 PM
Running the installer without the "initiate the database cluster" worked. It actually checked if the folder was empty and asked me if I was sure, when I wasn't paying enough attention and tried to hit next when it was checked.
PostgreSQL on external drive Quote
PostgreSQL on external drive
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards ? Splash Pots ? CoinRaces
PostgreSQL on external drive

      
m