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.
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