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

Поиск
Список
Период
Сортировка
От 类延良
Тема PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576
Дата
Msg-id 7eb12667.554a.180a91ba17c.Coremail.msdnchina@163.com
обсуждение исходный текст
Ответы Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576  (John Wiencek <jwiencek3@comcast.net>)
Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Nikhil Shetty
Дата:
Сообщение: Re: Postgres Stale Statistics
Следующее
От: John Wiencek
Дата:
Сообщение: Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576