Thread: Hello, how should I fix it?

Hello, how should I fix it?

From
吴 其键
Date:
service postgresql start
Starting PostgreSQL 16 database server: mainError: /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl start -D /var/lib/postgresql/16/main -l /var/log/postgresql/postgresql-16-main.log -s -o  -c config_file="/etc/postgresql/16/main/postgresql.conf"  exited with status 1:
2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared memory segment: Function not implemented
2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was shmget(key=6644951, size=56, 03600).
2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
pg_ctl: could not start server
Examine the log output. ... failed!
 failed!

Re: Hello, how should I fix it?

From
Adrian Klaver
Date:
On 10/13/24 05:57, 吴 其键 wrote:
> service postgresql start
> Starting PostgreSQL 16 database server: mainError: 
> /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl 
> start -D /var/lib/postgresql/16/main -l 
> /var/log/postgresql/postgresql-16-main.log -s -o  -c 
> config_file="/etc/postgresql/16/main/postgresql.conf"  exited with status 1:
> 2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared 
> memory segment: Function not implemented
> 2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was 
> shmget(key=6644951, size=56, 03600).
> 2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
> pg_ctl: could not start server
> Examine the log output. ... failed!
>   failed!
> 

Need more information:

1) Exact Postgres version, so 16.x.

2) OS and version.

3) Where did you get the Postgres package from?

> 获取Outlook for Android <https://aka.ms/AAb9ysg>

-- 
Adrian Klaver
adrian.klaver@aklaver.com




Re: Hello, how should I fix it?

From
Erik Wienhold
Date:
On 2024-10-13 18:04 +0200, Adrian Klaver wrote:
> On 10/13/24 05:57, 吴 其键 wrote:
> > service postgresql start
> > Starting PostgreSQL 16 database server: mainError:
> > /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl
> > start -D /var/lib/postgresql/16/main -l
> > /var/log/postgresql/postgresql-16-main.log -s -o  -c
> > config_file="/etc/postgresql/16/main/postgresql.conf"  exited with
> > status 1:
> > 2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared
> > memory segment: Function not implemented
> > 2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was
> > shmget(key=6644951, size=56, 03600).
> > 2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
> > pg_ctl: could not start server
> > Examine the log output. ... failed!
> >   failed!
> > 
> 
> Need more information:
> 
> 1) Exact Postgres version, so 16.x.
> 
> 2) OS and version.

Also good to know if this is running in a virtualized environment that
does not allow or support SysV IPC.

> 3) Where did you get the Postgres package from?

-- 
Erik



Re: Hello, how should I fix it?

From
吴 其键
Date:
I am running in Kali NetHunter chroot, using the official Kali apt repository to install PostgreSQL 16.4.


From: Erik Wienhold <ewie@ewie.name>
Sent: Monday, October 14, 2024 12:27:45 AM
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: 吴 其键 <wqj0@outlook.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Hello, how should I fix it?
 
On 2024-10-13 18:04 +0200, Adrian Klaver wrote:
> On 10/13/24 05:57, 吴 其键 wrote:
> > service postgresql start
> > Starting PostgreSQL 16 database server: mainError:
> > /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl
> > start -D /var/lib/postgresql/16/main -l
> > /var/log/postgresql/postgresql-16-main.log -s -o  -c
> > config_file="/etc/postgresql/16/main/postgresql.conf"  exited with
> > status 1:
> > 2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared
> > memory segment: Function not implemented
> > 2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was
> > shmget(key=6644951, size=56, 03600).
> > 2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
> > pg_ctl: could not start server
> > Examine the log output. ... failed!
> >   failed!
> >
>
> Need more information:
>
> 1) Exact Postgres version, so 16.x.
>
> 2) OS and version.

Also good to know if this is running in a virtualized environment that
does not allow or support SysV IPC.

> 3) Where did you get the Postgres package from?

--
Erik

Re: Hello, how should I fix it?

From
Erik Wienhold
Date:
Please do not top post.  Inline or bottom posting is preferred here.
https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics

On 2024-10-14 06:21 +0200, 吴 其键 wrote:
> I am running in Kali NetHunter chroot, using the official Kali apt
> repository to install PostgreSQL 16.4.

I'm not familiar with Kali or NetHunter.  It looks like you need to
build a custom kernel.  The NetHunter docs explicitly mention setting
CONFIG_SYSVIPC=y:
https://www.kali.org/docs/nethunter/nethunter-kernel-2-config-1/#general

Android did not support SysV IPC in the past.  Don't know if that's
still the case for newer versions.

> From: Erik Wienhold <ewie@ewie.name>
> On 2024-10-13 18:04 +0200, Adrian Klaver wrote:
> > On 10/13/24 05:57, 吴 其键 wrote:
> > > service postgresql start
> > > Starting PostgreSQL 16 database server: mainError:
> > > /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl
> > > start -D /var/lib/postgresql/16/main -l
> > > /var/log/postgresql/postgresql-16-main.log -s -o  -c
> > > config_file="/etc/postgresql/16/main/postgresql.conf"  exited with
> > > status 1:
> > > 2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared
> > > memory segment: Function not implemented
> > > 2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was
> > > shmget(key=6644951, size=56, 03600).
> > > 2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
> > > pg_ctl: could not start server
> > > Examine the log output. ... failed!
> > >   failed!
> > >
> >
> > Need more information:
> >
> > 1) Exact Postgres version, so 16.x.
> >
> > 2) OS and version.
> 
> Also good to know if this is running in a virtualized environment that
> does not allow or support SysV IPC.
> 
> > 3) Where did you get the Postgres package from?

-- 
Erik



Re: Hello, how should I fix it?

From
Bruce Momjian
Date:
On Mon, Oct 14, 2024 at 04:21:11AM +0000, 吴 其键 wrote:
> I am running in Kali NetHunter chroot, using the official Kali apt repository
> to install PostgreSQL 16.4.

The error is pretty clear that that configuation, either the operating
system or chroot, does not support shared memory.

---------------------------------------------------------------------------

> 
> 获取Outlook for Android
> ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
> From: Erik Wienhold <ewie@ewie.name>
> Sent: Monday, October 14, 2024 12:27:45 AM
> To: Adrian Klaver <adrian.klaver@aklaver.com>
> Cc: 吴其键 <wqj0@outlook.com>; pgsql-general@lists.postgresql.org
> <pgsql-general@lists.postgresql.org>
> Subject: Re: Hello, how should I fix it?
>  
> On 2024-10-13 18:04 +0200, Adrian Klaver wrote:
> > On 10/13/24 05:57, 吴其键 wrote:
> > > service postgresql start
> > > Starting PostgreSQL 16 database server: mainError:
> > > /usr/lib/postgresql/16/bin/pg_ctl /usr/lib/postgresql/16/bin/pg_ctl
> > > start -D /var/lib/postgresql/16/main -l
> > > /var/log/postgresql/postgresql-16-main.log -s -o  -c
> > > config_file="/etc/postgresql/16/main/postgresql.conf"  exited with
> > > status 1:
> > > 2024-10-13 12:55:21.553 UTC [16727] FATAL:  could not create shared
> > > memory segment: Function not implemented
> > > 2024-10-13 12:55:21.553 UTC [16727] DETAIL:  Failed system call was
> > > shmget(key=6644951, size=56, 03600).
> > > 2024-10-13 12:55:21.553 UTC [16727] LOG:  database system is shut down
> > > pg_ctl: could not start server
> > > Examine the log output. ... failed!
> > >   failed!
> > >
> >
> > Need more information:
> >
> > 1) Exact Postgres version, so 16.x.
> >
> > 2) OS and version.
> 
> Also good to know if this is running in a virtualized environment that
> does not allow or support SysV IPC.
> 
> > 3) Where did you get the Postgres package from?
> 
> --
> Erik

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  When a patient asks the doctor, "Am I going to die?", he means 
  "Am I going to die soon?"