buster upgraded postgresql
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 ID4BFEBB31
Re: buster upgraded postgresql
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
Re: buster upgraded postgresql
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 ID4BFEBB31
Re: buster upgraded postgresql
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 ID4BFEBB31
Re: buster upgraded postgresql
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".
Re: buster upgraded postgresql
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 ID4BFEBB31
Re: buster upgraded postgresql
> > > > 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.
Re: buster upgraded postgresql
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 ID4BFEBB31