Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576

On 5/9/22 08:56, 类延良 wrote:

My rhel 7.9 enabled 1GB hugepagesize,and in this rhel7.9,there is a postgresql 14.2 (from compile installation).

[root@localhost ~]# cat /proc/meminfo |grep -i hugep

AnonHugePages:      8192 kB

HugePages_Total:       0

HugePages_Free:        0

HugePages_Rsvd:        0

HugePages_Surp:        0

Hugepagesize:    1048576 kB

[root@localhost ~]# hugeadm --pool-list

      Size  Minimum  Current  Maximum  Default

1073741824        0        0        0        *

[root@localhost ~]# 

after I change pg parameter huge_page_size to 1048576， I can not start PostgreSQL 14.2 . the following is the error,

[pg142@localhost data]$ grep huge postgresql.conf

#huge_pages = try # on, off, or try

huge_page_size = 1048576 # zero for system default

[pg142@localhost data]$ pg_ctl start

waiting for server to start....2022-05-09 04:36:58.220 GMT [1719] LOG:  invalid value for parameter "huge_page_size": 1048576

2022-05-09 04:36:58.220 GMT [1719] DETAIL:  huge_page_size must be 0 on this platform.

2022-05-09 12:36:58.220 CST [1719] FATAL:  configuration file "/home/pg142/data/postgresql.conf" contains errors

 stopped waiting

pg_ctl: could not start server

Examine the log output.

[pg142@localhost data]$ 

I want to know why ？

The DETAIL message says " huge_page_size must be 0", but you did not set huge_page_size to 0. 

That may be the problem.