Re: broke postgres, how to fix??

Hi Adrian, yes I completely copied the config-file and data directories
over.

Lonnie, I don't remember. I might not have shut down the "old" postgres,
yes I set PGDATA accordingly.

To sum things up, I created a situation where I would use the service to
start "old" postgres and pg_ctl to start the "new" one.

Thanks!
-JD

On Tue, Feb 26, 2013 at 6:32 PM, Lonni J Friedman <netllama(at)gmail(dot)com>wrote:

> Did you shut down the 'old' postgres before copying these files?
> Did you (re)configure the 'new' postgres to set its $PGDATA directory
> to the location of the 'new' files?
>
> On Fri, Feb 22, 2013 at 3:46 PM, JD Wong <jdmswong(at)gmail(dot)com> wrote:
> > I tried copying postgres over to a new directory. it was working until I
> > deleted a bunch of databases from the "old" postgres. Lo and behold this
> > somehow broke the "new" copy too.
> >
> > Now when I start with pg_ctl
> > 2013-02-22 18:36:13 EST DETAIL: The database subdirectory
> "base/1066060" is
> > missing.
> > 2013-02-22 18:36:25 EST FATAL: database "wormmine" does not exist
> > 2013-02-22 18:36:25 EST DETAIL: The database subdirectory
> "base/1027296" is
> > missing.
> > 2013-02-22 18:37:13 EST FATAL: database "wormmine-dev" does not exist
> >
> > and it won't start...
> >
> > How can I fix this? re-creating these databases with the old postgres
> > didn't work...
> >
> > Also, why did this happen? I created a new data directory for the new
> > postgres, this should be impossible....
> >
> > I have no ideas left, can anyone help?
> >
> > Thanks in advance,
>