I have put v8.0 back on as you suggested, but so far it has made no difference. I am still unable to get the service restarted. When installing I changed the install to drive D, and also changed the data reference to the directory where I moved the data to. I unchecked the initialize database cluster and it seemed to install fine and did not create the usual data directory within the SQL folder. But for some perplexing reason, even though it all was working fine on drive C, I can't for the life of me work out what has gone wrong. I cannot export any data if it's not finding the data. And if I was able to export it then I wouldn't need to be going through all the hassle I am. Any further suggestions that I might be able to try to get the SQL service running. What other possible reasons would there be for it not seeing my database? -----Original Message----- From: Raymond O'Donnell [mailto:rod@xxxxxx] Sent: Friday, 17 August 2007 10:33 PM To: apitt@xxxxxxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Finding my database On 17/08/2007 05:44, apitt@xxxxxxxxxxxxx wrote: > needed to move it to the D Drive. After completely messing everything up, I > am now unable to get it working. I have uninstalled everything and now have > v8.2 installed on the D drive, and I put the data directory back within that I know it's not a lot of help to you at this point, but the recommended way to backup and restore a database is using pg_dump, and if you're moving from one major version to another it's the only way. Was the previous installation of Postgres also 8.2? If not - if it was an earlier version - I'd put the old version back, point it at the data directory, then use pg_dump to export the data if you want to upgrade at that point. Have a look at the following, and in particular the examples towards the bottom: http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html HTH, Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx --------------------------------------------------------------- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.0/957 - Release Date: 16/08/2007 1:46 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.0/959 - Release Date: 17/08/2007 5:43 PM ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
