Re: Finding my database

On 17/08/2007 05:44, apitt@tech2u.com.au 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@iol.ie
---------------------------------------------------------------