Re: [ADMIN] pg recovery

2008-01-02 Thread Bernhard D Rohrer
Bernhard D Rohrer wrote: Tom Lane wrote: exactly - I am currently installing a 32bit dapper on a VM in order to do the migration thanks muchly :) Bernhard ok, done. worked like a charm. thanks! Bernhard -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery h

Re: [ADMIN] pg recovery

2008-01-02 Thread Bernhard D Rohrer
Tom Lane wrote: Hmmm ... but it sure looks like the values are offset a few fields from where they belong ... [ meditates awhile... ] Ah, I've sussed it: the pg_controldata output you showed can be explained exactly by the assumption that this copy of pg_controldata thinks time_t is 64 bits wid

Re: [ADMIN] pg recovery

2008-01-02 Thread Tom Lane
Bernhard D Rohrer <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think you've got a cross-version problem, as in the database is really >> PG 8.0 or earlier but you're trying to run 8.1 against it. What is in >> the PG_VERSION file? Have you done "pg_resetxlog -f", and if so do you >> have th

Re: [ADMIN] pg recovery

2008-01-02 Thread Bernhard D Rohrer
Tom Lane wrote: Bernhard D Rohrer <[EMAIL PROTECTED]> writes: I have a broken database and not much clue about postgres, sorry for the n00b questions :( I think you've got a cross-version problem, as in the database is really PG 8.0 or earlier but you're trying to run 8.1 against it. What is

Re: [ADMIN] pg recovery

2007-12-31 Thread Tom Lane
Bernhard D Rohrer <[EMAIL PROTECTED]> writes: > I have a broken database and not much clue about postgres, sorry for the > n00b questions :( I think you've got a cross-version problem, as in the database is really PG 8.0 or earlier but you're trying to run 8.1 against it. What is in the PG_VERSI

[ADMIN] pg recovery

2007-12-31 Thread Bernhard D Rohrer
Hi folks I have a broken database and not much clue about postgres, sorry for the n00b questions :( I have my old raid drive which contains the databases but backup did not work, so we don't have one ... looking at the old database directory I get this: [EMAIL PROTECTED]:/var/lib/postgresq