问题描述
我一直在通过PostgreSQL服务器进行密集的模式删除和创建,
I've been performing kind of intensive schema dropping and creating over a PostgreSQL server,
提示:您可能需要增加max_locks_per_transaction.
HINT: You might need to increase max_locks_per_transaction.
我需要增加max_locks_per_transaction,但如何在 MAC OSX
I need to increase max_locks_per_transaction but how can i increase it in MAC OSX
推荐答案
您可能会找到../data/postgresql.conf文件,然后使用记事本进行编辑,设置max_locks_per_transaction = 1024如果它看起来像#max_locks_per_transaction ...,则必须删除#.
you might find ../data/postgresql.conf file, then edit with notepad, set max_locks_per_transaction = 1024if it looks like # max_locks_per_transaction... you must remove #.
它必须看起来像这样:max_locks_per_transaction = 1024#分钟10
it must look like that:max_locks_per_transaction = 1024 # min 10
然后保存并重新启动postgresql
than save it and restart postgresql
这篇关于如何增加max_locks_per_transaction的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!