Friday, March 28th, 2008
Prepare for postgres migration.
Moodle forum post on migration: the idea is to let moodle create an empty pg database and then upload the mysql data (which is edited with some grep to overcome differences).
Continued from this post.
Have to setup a new dedicated server for a client. Decided to go with ...
Posted in BrnDmp | No Comments »
Friday, March 28th, 2008
set up server for client. Setup postgres environment:
create dbuser (as user postgres): createuser -s P
edit postgresql.conf (listen to address and port)
edit pg_hba.conf (allowed access for maintenance host -> NOTE! first comment all default settings and start with a clean sheet, only allow specific hosts to connect)
Later optimize postgres settings
Posted in BrnDmp | No Comments »
