Re: Unable to run psql on 9.5 after broken 12 remove

On 7/3/20 8:15 AM, Moreno Andreo wrote:
> Il 03/07/2020 16:51, Adrian Klaver ha scritto:
>> On 7/3/20 1:54 AM, Moreno Andreo wrote:
>>
>> Looks like the cluster was not removed from the pgcommon setup. This
>> would explain why you can't run psql. By default pgcommon looks for
>> the version of psql connected with the most recent version of Postgres
>> it knows about, in this case 12. Unfortunately that binary no longer
>> exists. You still have psql. Do:
>>
>> /usr/lib/postgresql/9.5/bin/psql --help
> OK, it confirms that 9.5 client is still ok
>>
>> To avoid having to do that try:
>>
>> sudo pg_dropcluster  12 main
> This reported a warning

Yeah, I'm guessing the original uninstall clean up process went off the
rails here:

"
Processing triggers for postgresql-common (215.pgdg80+1) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Setting up python3.4 (3.4.2-1+deb8u3) ...
File "/usr/lib/python3.4/http/client.py", line 1014
raise InvalidURL(f"URL can't contain control characters. {url!r} "
^
SyntaxError: invalid syntax
dpkg: error processing package python3.4 (--configure):
"

The below just finished what the above started.

>
> root(at)datastore-1:/home/user# pg_dropcluster 12 main
> Warning: corrupted cluster: data directory does not exist
>
> ... but it did its job
>
> root(at)datastore-1:/home/user# sudo -u postgres psql
> psql (9.5.6)
> Type "help" for help.
>
> postgres=# \q
>
>
> Thanks, you saved my day again!
>
> Moreno.
>
>>
>>>
>>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com