launchpad-dev team mailing list archive

[William Grant <william.grant@xxxxxxxxxxxxx>]

On 29/05/12 20:06, Jonathan Lange wrote:
> On Sun, May 6, 2012 at 11:16 AM, Stuart Bishop
> <stuart.bishop@xxxxxxxxxxxxx> wrote:
>> Hi.
>>
>> Devs will need to switch over to PostgreSQL 9.1  - our first landing
>> is happening with sampledata generated from PG 9.1. As usual,
>> sampledata diffs are huge when generated by different PostgreSQL
>> versions so to avoid unnecessary huge commits (>1MB) we all need to be
>> running the same version from now on.
>>
>> You need to make the switch before the next time you regenerate the
>> sampledata as part of a DB patch landing. The various setup scripts
>> are all believed to work with PG 9.1, so the upgrade process should be
>> simple enough - uninstall PostgreSQL 8.4, install PostgreSQL 9.1,
>> confirm it is listening on port 5432 (check
>> /etc/postgresql/9.1/main/postgresql.conf), run the Launchpad database
>> setup script or whatever alternative process you use to set things up.
>>
> 
> I followed these instructions, and have found that they don't work.
>
> [snip]
> 
> The script seems to configure postgres to run on port 5433. At the
> time of starting the script, there are no services running on port
> 5432. This is in a lucid LXC instance on my precise laptop.

That's probably because you only removed 8.4, rather than purging it.
Only purge removes the cluster automatically. This should recover:

sudo pg_dropcluster 8.4 main
sudo pg_dropcluster 9.1 main
sudo pg_createcluster 9.1 main

and then run launchpad-database-setup again.

Attachment: signature.asc
Description: OpenPGP digital signature