Re: pg_version is missing

was there an explicit definition of $PGDATA variable pointing to the
data_old location?

rgds,
dotyet

On Fri, Apr 25, 2008 at 8:47 AM, Roberts, Jon <Jon(dot)Roberts(at)asurion(dot)com>
wrote:

> I had a problem with a database yesterday on a Windows server. The
> service was described as executing "C:\Program
> Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D
> "E:\PostgreSQL\data\". I also had an old backup of the data directory
> from 8.2. It was located on E:\PostgreSQL\data_old\.
>
> I didn't really need to keep the old 8.2 data directory but I did. To
> upgrade from 8.2 to 8.3, I had performed an export, un-install 8.2,
> install 8.3, and then import.
>
> So during some cleanup yesterday, I removed the data_old directory and
> my database crashed. It complained that it couldn't find pg_version. I
> also tried initdb but it wouldn't work. It gave me an error of "the
> program 'postgres' is needed by initdb but was not found".
>
> Any idea on how my new install of 8.3 somehow got linked to the data_old
> directory? I'm not asking how to fix the problem because I had a good
> backup and I was able to restore. I'm trying to understand why and how
> it happened so I can prevent it in the future.
>
> Maybe this is a Windows problem? We are moving to Solaris by the end of
> May which I'm really excited about. PostgreSQL flys on 64 bit Solaris.
>
> Jon
> Author of fn_ugly() :)
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>