Re: Uninstalled working db by mistake - Mailing list pgsql-general

From David Wilson
Subject Re: Uninstalled working db by mistake
Date
Msg-id 20160324175216.GC1844@k3
Whole thread Raw
In response to Re: Uninstalled working db by mistake  (Howard News <howardnews@selestial.com>)
Responses Re: Uninstalled working db by mistake
List pgsql-general
On Thu, Mar 24, 2016 at 05:44:27PM +0000, Howard News wrote:
> Thanks David,
>
> Unfortunately my cluster wont start - I am not entirely sure on the state of
> postgresql-9.0, this is the output from dpkd --list
>
>
>
> rc  postgresql-9.0 9.0.4-1~lucid1 object-relational SQL database, version
> 9.0

Per the heading printed by dpkg --list, this means the package is in the
removed state, but it's config files are still present. "apt-get install
postgresql-9.0" should be all required.


David


> ii  postgresql-9.1 9.1.20-1.pgdg1 object-relational SQL database, version
> 9.1
> ii  postgresql-9.2 9.2.15-1.pgdg1 object-relational SQL database, version
> 9.2
>
> Does this mean it is removed?
>
> On 24/03/2016 17:34, David Wilson wrote:
> >Hi Howard,
> >
> >So long as you haven't touched anything else, simply reinstalling the
> >package should restore your cluster. Debian packages only do
> >initialization if the data directories are missing.
> >
> >
> >David
> >
> >On Thu, Mar 24, 2016 at 05:29:23PM +0000, Howard News wrote:
> >>Hi,
> >>
> >>I uninstalled the wrong version of postgres on Ubuntu using apt-get remove
> >>postgresql-9.0, convinced that this was an old unused version. You guess the
> >>rest...
> >>
> >>The data files still appear to be there, all 485GB of them. Can these be
> >>restored?
> >>
> >>Thanks.
> >
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Howard News
Date:
Subject: Re: Uninstalled working db by mistake
Next
From: Alvaro Herrera
Date:
Subject: Re: Multixacts wraparound monitoring