Re: Forgot to dump old data before re-installing machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Forgot to dump old data before re-installing machine
Date: 2008-01-18 21:14:51
Message-ID: 12814.1200690891@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> The usual advice, telling them to replicate the binaries used to create it
> in the first place, isn't always the easiest to follow. It seems to me
> that including a "environment at cluster creation" note in $PGDATA like
> Dave suggests would be helpful for these cases; PG_VERSION just isn't
> enough information. I'd also throw in the locale information used for the
> cluster, as that seems like something it would be nice to have in simple
> text form as well there and is also a spot people are confused about.

pg_controldata already provides this information, no? At least barring
the case of wrong-time_t-size, which we already know we want to fix.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2008-01-18 21:16:41 Re: 7.4.6 to 8.2.5 - ' changes to $_$
Previous Message Tom Lane 2008-01-18 21:12:20 Re: [GENERAL] Forgot to dump old data before re-installing machine

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Smith 2008-01-18 21:45:54 Re: Forgot to dump old data before re-installing machine
Previous Message Tom Lane 2008-01-18 21:12:20 Re: [GENERAL] Forgot to dump old data before re-installing machine