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

From: Jon Theil Nielsen <jontheil(at)gmail(dot)com>
To: Luca Ferrari <fluca1978(at)infinito(dot)it>
Cc: "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-18 15:42:57
Message-ID: CABL6qKd04ajqWJNdZN8NpD1JTUwkYwhj8eVkSZpC_1q_Zt69CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> On Wed, Sep 18, 2013 at 11:12 AM, Jon Theil Nielsen <jontheil(at)gmail(dot)com<javascript:;>>
> wrote:
>
> > I am not quite sure if files in /usr/local/etc/periodic/ are run, but I
> > guess so. The command grep -ir sql . in this directory shows:
>
>
> Have you checked the root crontab? Periodic scripts are supposed to
> work out of the box, so I don't believe the problem is there.
>
> Luca
>
I believe it does not run (from periodic.conf).
I made a full backup of all databases and one extra copy of the most
crucial one - by pg_dump.
Then I deleted the data directory and made a fresh install of PostgreSQL
9.3.
I will try to figure out the right configuration and restore at least the
single database.
If this turns out to give problems, I might start a new thread here or at
the other friends at FreeBSD.
Thank you so far.

Regards
Jon

--
*Jon Theil Nielsen*
Ægirsgade 12 2 th
2200 København N
Mobil 22 27 07 20 · Fastnet 35 83 05 01

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tjibbe R 2013-09-21 20:26:19 JSON row_to_json_array
Previous Message Luca Ferrari 2013-09-18 15:31:51 Re: Several problems with installation on FreeBSD - how to reinstall without loosing data