Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #658

Re: PostgreSQL 8.4 and 9.1 on same system?

Show all headers | View raw

Hi Dimitri!

On 05/31/2015 11:38 AM, Dimitri Fontaine wrote:
> Magnus Warker <magnux@mailinator.com> writes:
>> Why do I have the two directories on my system?
> Needed for upgrade, I bet you did upgrade from 8.4 in the past to 9.1.

Not knowingly. I upgraded my system the debian way (apt-get update/upgrade).

>> How do I know which version is running?
> pg_lsclusters

Ok, 9.1 is down:

$ pg_lsclusters
Version Cluster   Port Status Owner    Data directory 
   Log file
8.4     main      5432 online postgres /var/lib/postgresql/8.4/main 
   /var/log/postgresql/postgresql-8.4-main.log
9.1     main      5433 down   postgres /var/lib/postgresql/9.1/main 
   /var/log/postgresql/postgresql-9.1-main.log

Can I switch to 9.1 and remove the 8.4 version?
How?
What about the existing databases?

>> How can I remove the old version?
> pg_dropcluster and apt-get remove.

But how to "activate" 9.1 first?

Magnus

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

PostgreSQL 8.4 and 9.1 on same system? Magnus Warker <magnux@mailinator.com> - 2015-05-31 09:36 +0200
  Re: PostgreSQL 8.4 and 9.1 on same system? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-05-31 11:38 +0200
    Re: PostgreSQL 8.4 and 9.1 on same system? Magnus Warker <magnux@mailinator.com> - 2015-05-31 15:57 +0200
      Re: PostgreSQL 8.4 and 9.1 on same system? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-05-31 16:11 +0200
        Re: PostgreSQL 8.4 and 9.1 on same system? Magnus Warker <magnux@mailinator.com> - 2015-05-31 17:09 +0200
          Re: PostgreSQL 8.4 and 9.1 on same system? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-05-31 18:17 +0200
            Re: PostgreSQL 8.4 and 9.1 on same system? Magnus Warker <magnux@mailinator.com> - 2015-05-31 19:01 +0200
              Re: PostgreSQL 8.4 and 9.1 on same system? mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2015-05-31 22:21 +0100
                Re: PostgreSQL 8.4 and 9.1 on same system? Magnus Warker <magnux@mailinator.com> - 2015-06-01 18:43 +0200
                Re: PostgreSQL 8.4 and 9.1 on same system? mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2015-06-01 21:08 +0100
                Re: PostgreSQL 8.4 and 9.1 on same system? mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2015-06-01 21:13 +0100

csiph-web