launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

Hi.

If you haven't already, all developers will need to switch to
PostgreSQL 8.4 for Launchpad work. You need to do this before the next
time you regenerate any sample data.

The process should be:

1) Install the packages::

    apt-get install postgresql-8.4 postgresql-contrib-8.4
postgresql-plpython-8.4 postgresql-doc-8.4

2) Shutdown both running versions of PostgreSQL::

    sudo pg_ctlcluster 8.3 main stop; sudo pg_ctlcluster 8.4 main stop

3) Edit /etc/postgresql/8.3/main/postgresql.conf, changing 'port=5432'
to 'port=5433'

4) Edit /etc/postgresql/8.4/main/postgresql.conf, changing 'port=5433'
to 'port=5432'

5) Uninstall postgresql 8.3 packages if you want. You can also just
disable it on startup by editing /etc/postgresql/8.3/main/start.conf
to specify 'manual' instead of 'auto'

6) Startup postgresql-8.4::

    sudo pg_ctlcluster 8.4 main start

7) Run launchpad-database-setup per https://dev.launchpad.net/DatabaseSetup


staging, production & the ec2 and buildbot environments are all still
running PostgreSQL 8.3. I'd like to get everything over to PostgreSQL
8.4 and Lucid next cycle.


-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/