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@datastore-1:/home/user# pg_dropcluster 12 main
Warning: corrupted cluster: data directory does not exist
... but it did its job
root@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.kla...@aklaver.com
