Re: [GENERAL] Broken after upgrade

2016-07-11 Thread Kris Deugau
Adrian Klaver wrote: > There is still the issue of the 9.4 binaries and which version of > Postgres you are running commands from at any given time. I would > suggest using full paths to the commands until this is resolved. It reads to me as if the OP's Fedora 23 -> Fedora 24 upgrade didn't instal

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 12:09 PM, arnaud gaboury wrote: % dnf info postgresql Last metadata expiration check: 2 days, 20:46:44 ago on Wed Jul 6 23:17:54 2016. Installed Packages Name: postgresql Arch: x86_64 Epoch : 0 Version : 9.5.3 Release : 1.fc24 Have you installe

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 8:45 PM, Adrian Klaver wrote: > On 07/09/2016 11:40 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: >

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 11:40 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote: On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am to

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote: > On 07/09/2016 11:06 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 08:08 AM, arnaud gaboury wrote: > > I understand you are confused, as I am too and tried too many thin

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 11:06 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: On 07/09/2016 08:08 AM, arnaud gaboury wrote: I understand you are confused, as I am too and tried too many things with no success. I have postgresql 9.5.3 installed, and the upgrade was from

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote: > On 07/09/2016 08:08 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote:

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 08:08 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 1:00 AM,

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 08:59 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, a

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote: > On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver > wrote: >> On 07/09/2016 03:09 AM, arnaud gaboury wrote: >>> >>> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury >>> wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrot

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote: > On 07/09/2016 03:09 AM, arnaud gaboury wrote: >> >> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury >> wrote: >>> >>> On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury >>> wrote: On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jimén

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread Adrian Klaver
On 07/09/2016 03:09 AM, arnaud gaboury wrote: On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez wrote: El 7/7/16 a las 0:14, Devrim Gündüz escribió: Hi, Fedora packages ha

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury wrote: > On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury > wrote: >> On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez >> wrote: >>> El 7/7/16 a las 0:14, Devrim Gündüz escribió: >>> Hi, Fedora packages have an executable (not

Re: [GENERAL] Broken after upgrade

2016-07-09 Thread arnaud gaboury
On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury wrote: > On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez > wrote: >> El 7/7/16 a las 0:14, Devrim Gündüz escribió: >> >>> Hi, >>> >>> Fedora packages have an executable (not sure about its name, but check a >>> package called postgresql-upg

Re: [GENERAL] Broken after upgrade

2016-07-07 Thread arnaud gaboury
On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez wrote: > El 7/7/16 a las 0:14, Devrim Gündüz escribió: > >> Hi, >> >> Fedora packages have an executable (not sure about its name, but check a >> package called postgresql-upgrade or so). That will help you to finish the >> upgrade process.

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread José María Terry Jiménez
El 7/7/16 a las 0:14, Devrim Gündüz escribió: Hi, Fedora packages have an executable (not sure about its name, but check a package called postgresql-upgrade or so). That will help you to finish the upgrade process. Regards, Devrim Hello Yes, the package is called postgresql-upgrade, and

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread Devrim Gündüz
Hi, Fedora packages have an executable (not sure about its name, but check a package called postgresql-upgrade or so). That will help you to finish the upgrade process. Regards, Devrim On July 6, 2016 9:13:50 PM GMT+03:00, arnaud gaboury wrote: >I am left today, after an upgrade I think (Fed

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread Adrian Klaver
On 07/06/2016 02:13 PM, arnaud gaboury wrote: On Wed, Jul 6, 2016 at 8:56 PM, John R Pierce wrote: On 7/6/2016 11:27 AM, Adrian Klaver wrote: First, if possible copy your data dir and conf files somewhere for safety. +1 !!! must be first step. It is the first thing I did From the

[GENERAL] Broken after upgrade

2016-07-06 Thread Jerry LeVan
> I am left today, after an upgrade I think (Fedora 23 --> 24) with a > broken postgresql. > > It used to work very well. The service is started with the systemd > unit file. I have now this error: > > - > postgres@thetradinghall 筐、筐、 systemd/system % > /usr/libexec/postgresql-ctl

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread John R Pierce
On 7/6/2016 2:13 PM, arnaud gaboury wrote: pretty much whatever you do, you'll need to install the 9.4 database server >software temporarily in a separate directory, and you'll need to do the >upgrade. So the idea is to downgrade first to 9.4.8 ? I will try this way no, not downgrade, you need

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread arnaud gaboury
On Wed, Jul 6, 2016 at 8:56 PM, John R Pierce wrote: > On 7/6/2016 11:27 AM, Adrian Klaver wrote: >> >> >> First, if possible copy your data dir and conf files somewhere for safety. > > > +1 !!! must be first step. It is the first thing I did > >> >> From the looks of it Fedora upgraded your Po

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread John R Pierce
On 7/6/2016 11:27 AM, Adrian Klaver wrote: First, if possible copy your data dir and conf files somewhere for safety. +1 !!! must be first step. From the looks of it Fedora upgraded your Postgres from 9.4.x to 9.5.3. That constitutes a major upgrade and as the error says the data direc

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread Adrian Klaver
On 07/06/2016 11:13 AM, arnaud gaboury wrote: I am left today, after an upgrade I think (Fedora 23 --> 24) with a broken postgresql. It used to work very well. The service is started with the systemd unit file. I have now this error: - postgres@thetradinghall ➤➤ systemd/system %

[GENERAL] Broken after upgrade

2016-07-06 Thread arnaud gaboury
I am left today, after an upgrade I think (Fedora 23 --> 24) with a broken postgresql. It used to work very well. The service is started with the systemd unit file. I have now this error: - postgres@thetradinghall ➤➤ systemd/system % /usr/libexec/postgresql-ctl start -D /db/pgsql/