postgresql-embedded icon indicating copy to clipboard operation
postgresql-embedded copied to clipboard

increase max_connections and other postgresql.conf options

Open cobbzilla opened this issue 6 years ago • 3 comments

I'd like to increase the max_connections setting in the postgresql.conf file. I understand that on a first-run, this file will be created by initdb. Is there a way to adjust the config settings when (or after) the file is written, or in any case before starting the server process?

cobbzilla avatar Mar 10 '18 00:03 cobbzilla

@cobbzilla : I have added a new feature on pull request #146 that enables the postgres executable configurations.

attila-kiss-it avatar Oct 19 '18 11:10 attila-kiss-it

hi, why do you expose parameters as list, it is so confusing. I have to guess whether this should be asList("param", "value", "param2", "value2") or asList("param=value", "param2=value2").

cannot it be just a Map/Properties that will be transformed internally to something else???

pawel-kaminski-krk avatar Dec 27 '18 10:12 pawel-kaminski-krk

anyway I have hard time setting

max_replication_slot
max_wal_senders

looking at AbstractPostgresConfig.java it should be something like asList("-c", "max_replication_slots=1", "-c", "max_wal_senders=1", "-c", "wal_level=logical")

pawel-kaminski-krk avatar Dec 27 '18 11:12 pawel-kaminski-krk