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

Groups > linux.debian.user > #202318 > unrolled thread

buster upgraded postgresql

Started bymick crane <mick.crane@gmail.com>
First post2018-11-11 11:00 +0100
Last post2018-11-12 15:30 +0100
Articles 8 — 3 participants

Back to article view | Back to linux.debian.user

Contents

  buster upgraded postgresql mick crane <mick.crane@gmail.com> - 2018-11-11 11:00 +0100
    Re: buster upgraded postgresql Georgi Naplatanov <gosho@oles.biz> - 2018-11-11 11:10 +0100
      Re: buster upgraded postgresql mick crane <mick.crane@gmail.com> - 2018-11-11 11:40 +0100
        Re: buster upgraded postgresql mick crane <mick.crane@gmail.com> - 2018-11-11 12:10 +0100
          Re: buster upgraded postgresql Georgi Naplatanov <gosho@oles.biz> - 2018-11-11 14:50 +0100
            Re: buster upgraded postgresql mick crane <mick.crane@gmail.com> - 2018-11-11 15:10 +0100
              Re: buster upgraded postgresql Greg Wooledge <wooledg@eeg.ccf.org> - 2018-11-12 14:50 +0100
                Re: buster upgraded postgresql mick crane <mick.crane@gmail.com> - 2018-11-12 15:30 +0100

#202318 — buster upgraded postgresql

Frommick crane <mick.crane@gmail.com>
Date2018-11-11 11:00 +0100
Subjectbuster upgraded postgresql
Message-ID<wSUH7-29D-5@gated-at.bofh.it>
hello

this last upgrade buster upgraded postgresql-10 to 11
I'm not sure what uses postgresql.
during upgrade think there was a message about pg_upgradecluster or I 
may have read that in manpage.

:~# ps -ef | grep postgre
postgres   599     1  0 09:36 ?        00:00:00 
/usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c 
config_file=/etc/postgresql/10/main/postgresql.conf
postgres   600     1  0 09:36 ?        00:00:00 
/usr/lib/postgresql/11/bin/postgres -D /var/lib/postgresql/11/main -c 
config_file=/etc/postgresql/11/main/postgresql.conf

shows postgresql-10 and -11 both running after reboot ( I thought reboot 
might dump 10 if not needed )

should I do "pg_upgradecluster" ?
how to find out if 10 is needed and if not needed stop it ?

please bear in mind I don't know what I'm doing.

mick


-- 
Key ID    4BFEBB31

[toc] | [next] | [standalone]

#202319

FromGeorgi Naplatanov <gosho@oles.biz>
Date2018-11-11 11:10 +0100
Message-ID<wSUQN-2ss-3@gated-at.bofh.it>
In reply to#202318
On 11/11/18 11:52 AM, mick crane wrote:
> hello
> 
> this last upgrade buster upgraded postgresql-10 to 11
> I'm not sure what uses postgresql.
> during upgrade think there was a message about pg_upgradecluster or I
> may have read that in manpage.
> 
> :~# ps -ef | grep postgre
> postgres   599     1  0 09:36 ?        00:00:00
> /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c
> config_file=/etc/postgresql/10/main/postgresql.conf
> postgres   600     1  0 09:36 ?        00:00:00
> /usr/lib/postgresql/11/bin/postgres -D /var/lib/postgresql/11/main -c
> config_file=/etc/postgresql/11/main/postgresql.conf
> 
> shows postgresql-10 and -11 both running after reboot ( I thought reboot
> might dump 10 if not needed )
> 
> should I do "pg_upgradecluster" ?
> how to find out if 10 is needed and if not needed stop it ?
> 
> please bear in mind I don't know what I'm doing.
> 
> mick

Hi Mick,

I think that you should the following:

 - drop existing cluster of PostgreSQL 11
 - upgrade existing PostgreSQL 10 cluster to 11
 - drop existing PostgreSQL 10
 - remove PostgreSQL 10 packages

You have to use commands:

pg_dropcluster
and
pg_upgradecluster

HTH

Kind regards
Georgi

[toc] | [prev] | [next] | [standalone]

#202320

Frommick crane <mick.crane@gmail.com>
Date2018-11-11 11:40 +0100
Message-ID<wSVjP-2CY-5@gated-at.bofh.it>
In reply to#202319
On 2018-11-11 10:00, Georgi Naplatanov wrote:
> On 11/11/18 11:52 AM, mick crane wrote:
>> hello
>> 
>> this last upgrade buster upgraded postgresql-10 to 11
>> I'm not sure what uses postgresql.
>> during upgrade think there was a message about pg_upgradecluster or I
>> may have read that in manpage.
>> 
>> :~# ps -ef | grep postgre
>> postgres   599     1  0 09:36 ?        00:00:00
>> /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c
>> config_file=/etc/postgresql/10/main/postgresql.conf
>> postgres   600     1  0 09:36 ?        00:00:00
>> /usr/lib/postgresql/11/bin/postgres -D /var/lib/postgresql/11/main -c
>> config_file=/etc/postgresql/11/main/postgresql.conf
>> 
>> shows postgresql-10 and -11 both running after reboot ( I thought 
>> reboot
>> might dump 10 if not needed )
>> 
>> should I do "pg_upgradecluster" ?
>> how to find out if 10 is needed and if not needed stop it ?
>> 
>> please bear in mind I don't know what I'm doing.
>> 
>> mick
> 
> Hi Mick,
> 
> I think that you should the following:
> 
>  - drop existing cluster of PostgreSQL 11
>  - upgrade existing PostgreSQL 10 cluster to 11
>  - drop existing PostgreSQL 10
>  - remove PostgreSQL 10 packages
> 
> You have to use commands:
> 
> pg_dropcluster
> and
> pg_upgradecluster
> 
> HTH
> 
> Kind regards
> Georgi

Why do I get the feeling I'm going to break something ?

with "pg_ctlcluster" assume cluster-version is "11" and action is "stop"
but how to find out what is this "cluster-name" for pg_ctlcluster, 
pg_dropcluster and pg_upgradecluster ?

"pg_dropcluster [--stop] cluster-version cluster-name"

"pg_upgradecluster oldversion name [newdatadir]" ?


mick









-- 
Key ID    4BFEBB31

[toc] | [prev] | [next] | [standalone]

#202321

Frommick crane <mick.crane@gmail.com>
Date2018-11-11 12:10 +0100
Message-ID<wSVMS-334-3@gated-at.bofh.it>
In reply to#202320
> but how to find out what is this "cluster-name" for pg_ctlcluster,
> pg_dropcluster and pg_upgradecluster ?
> 
> "pg_dropcluster [--stop] cluster-version cluster-name"
> 
> "pg_upgradecluster oldversion name [newdatadir]" ?
> 

OK from the conf files assume cluster-name is '10/main' and '11/main' 
respectively ?


-- 
Key ID    4BFEBB31

[toc] | [prev] | [next] | [standalone]

#202324

FromGeorgi Naplatanov <gosho@oles.biz>
Date2018-11-11 14:50 +0100
Message-ID<wSYhH-4sg-1@gated-at.bofh.it>
In reply to#202321

On 11/11/18 1:00 PM, mick crane wrote:
> 
>> but how to find out what is this "cluster-name" for pg_ctlcluster,
>> pg_dropcluster and pg_upgradecluster ?
>>
>> "pg_dropcluster [--stop] cluster-version cluster-name"
>>
>> "pg_upgradecluster oldversion name [newdatadir]" ?
>>
> 
> OK from the conf files assume cluster-name is '10/main' and '11/main'
> respectively ?
> 

default cluster name for both clusters should be "main".

[toc] | [prev] | [next] | [standalone]

#202325

Frommick crane <mick.crane@gmail.com>
Date2018-11-11 15:10 +0100
Message-ID<wSYB4-4OD-3@gated-at.bofh.it>
In reply to#202324
On 2018-11-11 13:40, Georgi Naplatanov wrote:
> On 11/11/18 1:00 PM, mick crane wrote:
>> 
>>> but how to find out what is this "cluster-name" for pg_ctlcluster,
>>> pg_dropcluster and pg_upgradecluster ?
>>> 
>>> "pg_dropcluster [--stop] cluster-version cluster-name"
>>> 
>>> "pg_upgradecluster oldversion name [newdatadir]" ?
>>> 
>> 
>> OK from the conf files assume cluster-name is '10/main' and '11/main'
>> respectively ?
>> 
> 
> default cluster name for both clusters should be "main".
yes I got there eventually
so is
"pg_ctlcluster 11 main stop"
"pg_dropcluster 11 main"
"pg_upgradecluster 10 main /var/lib/postgresql/11/main"
"pg_dropcluster 10 main"

"sudo -u postgres psql"
"SHOW data_directory;"
"\q"

nothing seems to be broken

cheers

mick

-- 
Key ID    4BFEBB31

[toc] | [prev] | [next] | [standalone]

#202335

FromGreg Wooledge <wooledg@eeg.ccf.org>
Date2018-11-12 14:50 +0100
Message-ID<wTkLg-2bz-5@gated-at.bofh.it>
In reply to#202325
> > > > but how to find out what is this "cluster-name" for pg_ctlcluster,
> > > > pg_dropcluster and pg_upgradecluster ?
> > > 
> > > OK from the conf files assume cluster-name is '10/main' and '11/main'
> > > respectively ?
> > 
> > default cluster name for both clusters should be "main".
> yes I got there eventually

You could also try reading the README.Debian.gz file in
/usr/share/doc/postgresql-*/

In stretch, this is /usr/share/doc/postgresql-9.6/README.Debian.gz
and it contains the exact steps needed to upgrade from 9.1 to 9.4.
Just replace the version numbers with whatever you have.

[toc] | [prev] | [next] | [standalone]

#202338

Frommick crane <mick.crane@gmail.com>
Date2018-11-12 15:30 +0100
Message-ID<wTlnX-2Fb-1@gated-at.bofh.it>
In reply to#202335
On 2018-11-12 13:44, Greg Wooledge wrote:
>> > > > but how to find out what is this "cluster-name" for pg_ctlcluster,
>> > > > pg_dropcluster and pg_upgradecluster ?
>> > >
>> > > OK from the conf files assume cluster-name is '10/main' and '11/main'
>> > > respectively ?
>> >
>> > default cluster name for both clusters should be "main".
>> yes I got there eventually
> 
> You could also try reading the README.Debian.gz file in
> /usr/share/doc/postgresql-*/
> 
> In stretch, this is /usr/share/doc/postgresql-9.6/README.Debian.gz
> and it contains the exact steps needed to upgrade from 9.1 to 9.4.
> Just replace the version numbers with whatever you have.

In my defence I've used msql but have no idea about postgresql and 
thinking there's probably a few things use it I asked.
Looked later but didn't know about "zless" and as it was working didn't 
bother to extract it. I did now so next time I'll be less nervous.

mick

-- 
Key ID    4BFEBB31

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web