Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576 - Mailing list pgsql-admin

From 类延良
Subject PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576
Date
Msg-id 7eb12667.554a.180a91ba17c.Coremail.msdnchina@163.com
Whole thread Raw
Responses Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576
Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576
List pgsql-admin
Tree view
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 ？


 

pgsql-admin by date:

Previous
From: Nikhil Shetty
Date:
Subject: Re: Postgres Stale Statistics
Next
From: John Wiencek
Date:
Subject: Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576