Re: Several problems with installation on FreeBSD - how to reinstall without loosing data

From: "Christofer C(dot) Bell" <christofer(dot)c(dot)bell(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Date: 2013-09-17 06:16:06
Message-ID: CAOEVnYvgYD8AFvXiH_F61=u4dYk+K-pfCtAi_1CnLtmL5TApNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Sep 16, 2013 at 1:10 PM, Jon Theil Nielsen <jontheil(at)gmail(dot)com>wrote:

>
> I think that the best solution would be to reinstall pgsql. But it would
> be very inconvenient to loose at least one of the databases (I use it as
> part of at calendar server). Can I reinstall following a tutorial like this
> one<http://jasonk2600.wordpress.com/2010/01/11/installing-postgresql-on-freebsd/>and get the vital databases back?
>

If it comes to that, you still don't have to lose your data. Since you
have the starting (even if it's not working correctly) you should be able
to pg_dump your calendar database and then restore it after
reinstalling/reinitializing PostgreSQL.

I am not suggesting this at this point (others on the list are still
helping you) but don't think you need to panic over data loss just yet,
even if you end up having to reinitialize PostgreSQL.

Good luck!

--
Chris

"If you wish to make an apple pie from scratch, you must first invent the
Universe." -- Carl Sagan

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Albe Laurenz 2013-09-17 07:24:12 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Previous Message Jon Theil Nielsen 2013-09-16 22:46:48 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data