Re: Several problems with installation on FreeBSD - how to reinstall without loosing data - Mailing list pgsql-novice

From Jon Theil Nielsen
Subject Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Date
Msg-id CABL6qKd04ajqWJNdZN8NpD1JTUwkYwhj8eVkSZpC_1q_Zt69CA@mail.gmail.com
Whole thread Raw
In response to Re: Several problems with installation on FreeBSD - how to reinstall without loosing data  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-novice

On Wed, Sep 18, 2013 at 11:12 AM, Jon Theil Nielsen <jontheil@gmail.com> 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

pgsql-novice by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Several problems with installation on FreeBSD - how to reinstall without loosing data
Next
From: Tjibbe R
Date:
Subject: JSON row_to_json_array