PostgreSQL 15 service

PostgreSQL 15 service

[Mauritz Stenek]

Hello,

On a full Guix system, I added the postgres service type like 
this:

```
(service postgresql-service-type
  (postgresql-configuration (postgresql postgresql-15)))
```

only upgrading to postgresql-15 from the default config (pg-10).

However, I get this error (verbatim):

```
# herd start postgres
Service user-homes has been started.
herd: error: exception caught while executing 'start' on service 
'postgres':
Throw to key `%exception' with args `("#<&invoke-error program: 
\"/gnu/store/m7dwq55l600g12bzm245zd9ha8v1zvn1-pg_ctl-wrapper\" 
arguments: (\"start\") exit-status: 1 term-signal: #f stop-signal: 
#f>")'.
```

Any ideas on how to fix this?

Thanks.

-- 
Mauritz Stenek <mstenek@disroot.org>

Re: PostgreSQL 15 service

[Giovanni Biscuolo]

[-- Attachment #1: Type: text/plain, Size: 840 bytes --]

Hi Mauritz,

Mauritz Stenek <mstenek@disroot.org> writes:

[...]

> However, I get this error (verbatim):
>
> ```
> # herd start postgres
> Service user-homes has been started.
> herd: error: exception caught while executing 'start' on service 
> 'postgres':
> Throw to key `%exception' with args `("#<&invoke-error program: 
> \"/gnu/store/m7dwq55l600g12bzm245zd9ha8v1zvn1-pg_ctl-wrapper\" 
> arguments: (\"start\") exit-status: 1 term-signal: #f stop-signal: 
> #f>")'.
> ```
>
> Any ideas on how to fix this?

AFAIU the above error is just saying trat the exit status of
pg_ctl-wrapper is 1 (meaning it failed)

Can you have a look at the logs, they sould be in syslog (by default,
having not defined a specific log-destination configuration)

HTH! Gio'

-- 
Giovanni Biscuolo

Xelera IT Infrastructures

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 849 bytes --]

Re: PostgreSQL 15 service

[Mauritz Stenek]

Hi Gio',


On 2024-02-26 at 06:09, Giovanni Biscuolo <g@xelera.eu> wrote:

> AFAIU the above error is just saying trat the exit status of
> pg_ctl-wrapper is 1 (meaning it failed)
>
> Can you have a look at the logs, they sould be in syslog (by 
> default,
> having not defined a specific log-destination configuration)
>
> HTH! Gio'

The log reads:

> ...
> FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 
> 10, which is not compatible with this version 15.4.

Very enlightening!

Well I deleted that directory and -- voilà! -- now it works!

Thanks a lot for your help. Grazie mille!

-- 
Mauritz Stenek <mstenek@disroot.org>

Re: PostgreSQL 15 service

[Felix Lechner via]

Hi Mauritz,

On Sun, Feb 25 2024, Mauritz Stenek wrote:

> I added the postgres service

I use that service, too [1] 

> exception caught while executing 'start' on service 'postgres':

but I do not get that message upon 'restart'. I was also not able to
find anything like that in my logs.

Maybe it's a permission issue?

Kind regards
Felix

[1] https://codeberg.org/lechner/system-config/src/branch/history/host/wallace-server/operating-system.scm#L877-L895

Re: PostgreSQL 15 service

[Mauritz Stenek]

Hello Felix,

I fixed it by deleting and the incompatible data directory creted 
by a previous postgres version.

In any case, thanks!

On 2024-02-26 at 11:42, Felix Lechner <felix.lechner@lease-up.com> 
wrote:

> Hi Mauritz,
>
> On Sun, Feb 25 2024, Mauritz Stenek wrote:
>
>> I added the postgres service
>
> I use that service, too [1] 
>
>> exception caught while executing 'start' on service 'postgres':
>
> but I do not get that message upon 'restart'. I was also not 
> able to
> find anything like that in my logs.
>
> Maybe it's a permission issue?
>
> Kind regards
> Felix
>
> [1] 
> https://codeberg.org/lechner/system-config/src/branch/history/host/wallace-server/operating-system.scm#L877-L895


-- 
Mauritz Stenek <mstenek@disroot.org>