Jonel, I have initialized a new cluster in the installation (you did not), but that should not have mattered, should it? Best Regards, Otto 2006/1/15, Jonel Rienton <jonel@xxxxxxxxxxxxxxxx>: > Hi, > > I was just doing the same thing this morning, well somewhat the same; > anyways, what I did was > > 1. uninstall Postgres, and run the installation again(don't use the > upgrade.bat), same major version. > 2. on the initial installation window, choose a new data directory by > clicking on browse, point to your new location of data directory (the > directory where you moved the data) > 3. make sure you enable the run as service > 4. don't initialize cluster db, uncheck it. > 5. continue with installation. > 6. you should be able to start the service from the services msc. > > Regards, > > > Jonel Rienton > > -- > I know not english well, but I know 9 computer languages. > Pinoy Ako! > > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ottó Havasvölgyi > Sent: Saturday, January 14, 2006 7:38 AM > To: Magnus Hagander > Cc: Pg - General > Subject: Re: [GENERAL] Moving PostgreSQL data directory on Windows > > Hello, > > Ok. I did not set any security on the machine. Only I have access to it. Now > I have done this: > > 0. Registry is modified (yesterday) > 1. Restart today > 2. Modify registry to the old value > 3. Start PostgreSQL -> pg_ctl and postmaster are running (they are in the > task list), but no postgres 4. "pg_ctl status" says that neither postmaster > nor postgres are running. No new entry in event log. > 5. Stop with "pg_ctl stop" -> it says "Could not send stop signal (PID > 3624): no such process". There is really no such PID. > 6. Restart Windows -> the same as before 7. Stop PostgreSQL from the Sart > menu -> it took a half minute, and now only postmaster is running. > 8. pg_ctl unregister -N "pgsql-8.0" -> seems it succeeded 9. Register on the > new location 10. Start with "net start "pgsql-8.0"" -> The service could not > be started, no event log entry. Perhaps because a postmaster isrunning. > 11. Kill postmaster, I cannot stop it in other way. > 12. Start from Start menu and "net start", but nothing happens. The same > message as in step 10. > 13. Start from Control panel - Services -> Message: "The service started > then stopped." > > Now I really don't know how to start this. > Perhaps reinstaling Postgres is easier. > > 14. Modified all this with the installer, but PostgreSQL does not start. > 15. Backup data directory > 16. Uninstall PostgreSQL > 17. Install PostgreSQL 8.0.6 (this was installed before), as service, set > the same passwords. > 18. Stop PostgreSQL > 19. Move the backuped data directory to the location PostgreSQL uses. > 20. Start PostgreSQL now, but it does not start this way. :( > > What can be done to use my old data? It's not that critical, only tests. > > Thanks, > Otto > > > > > 2006/1/14, Magnus Hagander <mha@xxxxxxxxxxxxxx>: > > Ok, two things: > > > > First, when using this method, yo uhave to reboot after editing the > registry. If you didn't do that, then that's your problem. Sorry, forgot to > mention that. If not, then looking at permissions as Rodrigo suggested is > the next step. > > > > Second, there is of course a nicer way of doing this than editing the > registry, that I compleetley forgot about. It's still not as nice as you > would want, but it should work. You use pg_ctl unregister to remove the > service, and then pg_ctl register to register a new one with the new data > directory Doing this you won't hvae to reboot.. > > > > > > Perhaps this is something we should add to pg_ctl for 8.2? "pg_ctl > reconfigure" or something like that? What do others think? > > > > //Magnus > > > > > -----Original Message----- > > > From: Ottó Havasvölgyi [mailto:havasvolgyi.otto@xxxxxxxxx] > > > Subject: Re: [GENERAL] Moving PostgreSQL data directory on Windows > > > > > > Magnus, > > > > > > It's a service, and it is 8.0.6. I have fixed the registry to this > > > value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" > > > runservice -N "pgsql-8.0" -D "E:\PostgreSQL\data\" > > > > > > The service does not start. > > > This new directory definetely exists. But now there is no Event log > > > entry about the error. The log file says nothing because it is in > > > the data/pg_log directory. > > > > > > Thanks, > > > Otto > > > > > > > > > > > > 2006/1/13, Magnus Hagander <mha@xxxxxxxxxxxxxx>: > > > > > Hello, > > > > > > > > > > I would like to move the data directory to another location. > > > > > I have done this: > > > > > 1. Stop PostgreSQL > > > > > 2. Move data directory > > > > > 3. Create a PGDATA env. variable to the new location 4. Start > > > > > PostgreSQL > > > > > > > > > > And it cannot start, because it cannot find postgresql.conf. > > > > > (in Event log) What should I do now? > > > > > > > > Are you running it as a service:? If so you need to reconfigure > > > > the service. Unfortunatly,the only way to do this is using > > > regedit. Go to > > > > HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.1 > > > > > > > > Open the value "ImagePath" and change the data directory. > > > > > > > > //Magnus > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.17/228 - Release Date: 1/12/2006 > > >
