josh --
Delete everything under the postgres directory (we put ours on /apps/postgres.version.whatever.) to remove the executables/libs etc, and delete the entire data directory that the initdb pointed to. e.g if $PGDATA is /data/postgres/billing, rm -rf /data/postgres/billing would get rid of all the data and supporting tables. Don't forget to wipe the log, if any.
(Sorry for top-posting --challenged reader)
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Josh Harrison
Sent: Mon 12/3/2007 8:20 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: uninstall postgres 8.2
Hi,
What is the best way to uninstall postgres?
I'm planning to use postgres 8.3 beta and I would like to uninstall my
earlier version 8.2.3. This is only a test database and so I'm not
interested in upgrading or preserving anything from this version.
Thanks
josh