pg_upgradecluster: Port old postgres.conf file before starting data migration
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-common (Ubuntu) |
Triaged
|
Low
|
Unassigned |
Bug Description
This is more an enhancement request than a bug report.
Background: I was upgrading from postgres 8.4 (Ubuntu 11.04) to 9.1 (Ubuntu 11.10) using the steps in README.Debian and noticed it taking unusually long. I checked the log for the new version, and I noticed that it was checkpointing quite often (once every few seconds). I checked /etc/postgresql
Example logs: "checkpoints are occurring too frequently (10 seconds apart)" / 'Consider increasing the configuration parameter "checkpoint_
I worked around this by adding 'system(
I'm not sure what a general approach would be, but I figure logging this here will at least help guide someone who notices it in the future.
If it's too risky to port the whole config before data transfer, perhaps pg_upgradecluster could transfer performance-
I guess you can break upgrades either way, but I'll think about porting the config before starting the upgrade, and then just (temporarily) resetting some particular settings (port, etc.).