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


Groups > linux.debian.user > #202325

Re: buster upgraded postgresql

From mick crane <mick.crane@gmail.com>
Newsgroups linux.debian.user
Subject Re: buster upgraded postgresql
Date 2018-11-11 15:10 +0100
Message-ID <wSYB4-4OD-3@gated-at.bofh.it> (permalink)
References <wSUH7-29D-5@gated-at.bofh.it> <wSUQN-2ss-3@gated-at.bofh.it> <wSVjP-2CY-5@gated-at.bofh.it> <wSVMS-334-3@gated-at.bofh.it> <wSYhH-4sg-1@gated-at.bofh.it>
Organization linux.* mail to news gateway

Show all headers | View raw


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

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