From mboxrd@z Thu Jan 1 00:00:00 1970 From: Catonano Subject: postgresql again Date: Sun, 10 Sep 2017 19:49:05 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="f403045c2a5429dec30558d96d48" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33878) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dr6M0-0003ye-Lk for guix-devel@gnu.org; Sun, 10 Sep 2017 13:49:09 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dr6Lz-0005KG-Tk for guix-devel@gnu.org; Sun, 10 Sep 2017 13:49:08 -0400 Received: from mail-wm0-x22a.google.com ([2a00:1450:400c:c09::22a]:45918) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dr6Lz-0005Jc-Lz for guix-devel@gnu.org; Sun, 10 Sep 2017 13:49:07 -0400 Received: by mail-wm0-x22a.google.com with SMTP id f199so26428638wme.0 for ; Sun, 10 Sep 2017 10:49:07 -0700 (PDT) List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: guix-devel --f403045c2a5429dec30558d96d48 Content-Type: text/plain; charset="UTF-8" I have a postgresql service in my config.scm file but I don't use it Today I needed it to figure out how postgres works (because of my attempt to create a service for Tryton) and I discovered that it's stopped ~$ sudo herd status ... Stopped: - postgres - user-homes and if I try to start it, it fails ~$ sudo herd start postgres Service postgres is currently disabled. herd: failed to start service postgres I can "enable" and then start it but that doeesn't resist a reboot This was discussed in the past and it had to do with postgres being updated BUT it was reported back then that there were messages in var/log/messages about how the data folder had been initializzed with a previous version of postgres and that was incompatible with the new one In my case nothing shhows up with sudo cat /var/log/mesages | grep postgresql and ~$ sudo cat /var/lib/postgresql/data/PG_VERSION 9.6 and $ pg_config ... VERSION = PostgreSQL 9.6.5 I reconfigured and updated my installation in August, before coming to the GHM could anyone here verify if they can run postgresql with a reasonably recent version of GuixSD ? Thanks in advance --f403045c2a5429dec30558d96d48 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have a post= gresql service in my config.scm file

but I don't use it
Today I needed it to figure out how postgres works (because of m= y attempt to create a service for Tryton) and I discovered that it's st= opped

~$ sudo herd status
...
Stopped:
=C2=A0- postgres
= =C2=A0- user-homes

and if I try to start it, it fails
~$ su= do herd start postgres
Service postgres is currently disabled.
herd: = failed to start service postgres

I can "enable" and = then start it but that doeesn't resist a reboot

This was d= iscussed in the past and it had to do with postgres being updated BUT it wa= s reported back then that there were messages in var/log/messages about how= the data folder had been initializzed with a previous version of postgres = and that was incompatible with the new one

In my case nothing = shhows up with

sudo cat /var/log/mesages | grep postgresql
=
and

~$ sudo cat /var/lib/postgresql/data/PG_VERSION
9.= 6

and

$ pg_config
...
VERSION =3D PostgreSQL 9.6.= 5

I reconfigured and u= pdated my installation in August, before coming to the GHM
could anyone here verify if they can run postgresql with a reasonabl= y recent version of GuixSD ?

Thanks in advance
<= /div>
--f403045c2a5429dec30558d96d48--