Search Postgresql Archives

Re: broke postgres, how to fix??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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,


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux