| From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
|---|---|
| To: | JD Wong <jdmswong(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: broke postgres, how to fix?? |
| Date: | 2013-02-26 23:32:34 |
| Message-ID: | CAP=oouEDiWrwQKJ55pFAxLcPXn2ka-e2w_R4YRuWAH2mg4OR5Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JD Wong | 2013-02-27 00:02:08 | Re: broke postgres, how to fix?? |
| Previous Message | Adrian Klaver | 2013-02-26 23:32:31 | Re: broke postgres, how to fix?? |