[GENERAL] config file question between versions 7.4 - 9.1

2012-05-09 Thread Randy Johnson
Hello, in the config file for 7.4 we have an entry: shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each in 9.1 the default is: shared_buffers = 32MB max connections is the default 100 Do I need to make any adjustments or can I leave it at the default? The machine is dedicat

[GENERAL] Simultaneous Installations 7.4 9.x

2012-05-07 Thread Randy Johnson
Hello, I have a redhat E5 installation with PostgreSQL 7.4 installation. I have been tasked with upgrading it to 9.x I have read that I can install both versions at the same time via YUM and edit the config file on the new installation to use a different port until go live time. Can anyone con