unofficial mirror of help-guix@gnu.org 
 help / color / mirror / Atom feed
* PostgreSQL 15 service
@ 2024-02-26  4:49 Mauritz Stenek
  2024-02-26 12:09 ` Giovanni Biscuolo
  2024-02-26 17:42 ` Felix Lechner via
  0 siblings, 2 replies; 5+ messages in thread
From: Mauritz Stenek @ 2024-02-26  4:49 UTC (permalink / raw)
  To: help-guix

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>


^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: PostgreSQL 15 service
  2024-02-26  4:49 PostgreSQL 15 service Mauritz Stenek
@ 2024-02-26 12:09 ` Giovanni Biscuolo
  2024-02-27 18:51   ` Mauritz Stenek
  2024-02-26 17:42 ` Felix Lechner via
  1 sibling, 1 reply; 5+ messages in thread
From: Giovanni Biscuolo @ 2024-02-26 12:09 UTC (permalink / raw)
  To: Mauritz Stenek, help-guix

[-- 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 --]

^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: PostgreSQL 15 service
  2024-02-26  4:49 PostgreSQL 15 service Mauritz Stenek
  2024-02-26 12:09 ` Giovanni Biscuolo
@ 2024-02-26 17:42 ` Felix Lechner via
  2024-02-27 18:58   ` Mauritz Stenek
  1 sibling, 1 reply; 5+ messages in thread
From: Felix Lechner via @ 2024-02-26 17:42 UTC (permalink / raw)
  To: Mauritz Stenek, help-guix

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


^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: PostgreSQL 15 service
  2024-02-26 12:09 ` Giovanni Biscuolo
@ 2024-02-27 18:51   ` Mauritz Stenek
  0 siblings, 0 replies; 5+ messages in thread
From: Mauritz Stenek @ 2024-02-27 18:51 UTC (permalink / raw)
  To: Giovanni Biscuolo; +Cc: help-guix

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>


^ permalink raw reply	[flat|nested] 5+ messages in thread

* Re: PostgreSQL 15 service
  2024-02-26 17:42 ` Felix Lechner via
@ 2024-02-27 18:58   ` Mauritz Stenek
  0 siblings, 0 replies; 5+ messages in thread
From: Mauritz Stenek @ 2024-02-27 18:58 UTC (permalink / raw)
  To: Felix Lechner; +Cc: help-guix

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>


^ permalink raw reply	[flat|nested] 5+ messages in thread

end of thread, other threads:[~2024-02-27 19:00 UTC | newest]

Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2024-02-26  4:49 PostgreSQL 15 service Mauritz Stenek
2024-02-26 12:09 ` Giovanni Biscuolo
2024-02-27 18:51   ` Mauritz Stenek
2024-02-26 17:42 ` Felix Lechner via
2024-02-27 18:58   ` Mauritz Stenek

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).