How to thoroughly purge and reinstall postgresql on ubuntu? [closed]

by

Option A

If your install isn’t already damaged, you can drop unwanted PostgreSQL servers (“clusters”) using pg_dropcluster. Use that in preference to a full purge and reinstall if you just want to restart with a fresh PostgreSQL instance.

$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
11  main    5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
$ sudo systemctl stop postgresql@11-main
$ sudo pg_dropcluster --stop 11 main
$ sudo pg_createcluster --start 11 main

Option B

If you really need to do a full purge and reinstall, first make sure PostgreSQL isn’t running. ps -C postgres should show no results.

Now run:

apt-get --purge remove postgresql\*

to remove everything PostgreSQL from your system. Just purging the postgres package isn’t enough since it’s just an empty meta-package.

Once all PostgreSQL packages have been removed, run:

rm -r /etc/postgresql/
rm -r /etc/postgresql-common/
rm -r /var/lib/postgresql/
userdel -r postgres
groupdel postgres

You should now be able to:

apt-get install postgresql

or for a complete install:

apt-get install postgresql-8.4 postgresql-contrib-8.4 postgresql-doc-8.4

More Related Contents:

  1. Where does PostgreSQL store configuration/conf files?
  2. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  3. How to fix pg_dump version mismatch errors?
  4. What is PostgreSQL equivalent to autoincrement?
  5. How do I specify a password to ‘psql’ non-interactively?
  6. INSERT with dynamic table name in trigger function
  7. psql: FATAL: Ident authentication failed for user “postgres”
  8. Use multiple conflict_target in ON CONFLICT clause
  9. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  10. How to find table creation time?
  11. Creating a copy of a database in PostgreSQL
  12. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  13. Can’t connect the postgreSQL with psycopg2
  14. How do you change the character encoding of a postgres database?
  15. Difference between GiST and GIN index
  16. Test for null in function with varying parameters
  17. PostgreSQL: Why psql can’t connect to server?
  18. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  19. Can I use return value of INSERT…RETURNING in another INSERT?
  20. Changing a postgres containers server port in Docker Compose
  21. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  22. no pg_hba.conf entry for host
  23. PostgreSQL – disabling constraints
  24. PostgreSQL authentication method 10 not supported
  25. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  26. input file appears to be a text format dump. Please use psql
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment