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

Groups > linux.debian.user > #202320

Re: buster upgraded postgresql

Show all headers | View raw

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

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web