Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
postgresqlconnectionbitnamipostgresql9.3syslog
1 Odgovori
17394 Prikazi
Avatar
Sam path

Hi All,

I have installed a bitnami Odoo in Amazon EC2 m4.10xlarge  instance which has 40 vCPU, 160GB RAM and 500GB hard disk

By default PostgreSQL has a max_connections of 150 and I would need it to be increased to 100000(1Lakh connections)

May I know what changes do I have to do in postgresql.conf and sysctl.conf?

Thanks,

Sampath

Avatar
Opusti
Avatar
Axel Mendoza
Best Answer

You need to increase the max_connections settings in postgresql.conf according to this guide:

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

Normally you need to change: max_connections, shared_buffers and work_mem settings

but read it carefully for your environment, also I suggest you to use a connection pooling like pgbouncer according to this guide

https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

Use the connection pooling to reach your number of max_connections instead of config postgresql to that insane value, read more about that here: http://www.cybertec.at/2014/03/max_connections-performance-impacts/

This are just a few tips, hope this helps


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Unable to run the PostgreSQL service Solved
postgresql postgresql9.3
Avatar
Avatar
Avatar
Avatar
Avatar
6
dec. 23
45569
How do I mend a failed upgrade to Postgresql 9.3
postgresql postgresql9.3
Avatar
1
mar. 15
10169
[V9]postgresql connection error
error postgresql connection v9.0
Avatar
Avatar
Avatar
Avatar
4
dec. 22
12364
Docker: Odoo 15 failed connecting to Postgres DB
postgresql connection Docker v15
Avatar
Avatar
1
nov. 22
8712
How to represent Postgresql interval in Openerp 7 ?
postgresql python2.7 openerp7 postgresql9.3
Avatar
0
okt. 18
4101