Uninstalling adminpack - Mailing list pgadmin-hackers

From August Zajonc
Subject Uninstalling adminpack
Date
Msg-id 43FC7682.9090603@augustz.com
Whole thread Raw
List pgadmin-hackers
It's always fun installing new software. Sometimes though you need to
clean it out, for testing, because it's not needed etc.

Attached is a stab at making the adminpacks somewhat easier to uninstall.

The one question I had was on the LANGUAGE INTERNAL compatibility
functions, which I'm assuming earlier versions of pgadmin used?

Feedback welcome, testing probably neede.

- August




Index: Makefile
===================================================================
--- Makefile    (revision 5029)
+++ Makefile    (working copy)
@@ -1,6 +1,7 @@
 MODULE_big = admin81
 PG_CPPFLAGS = -I$(libpq_srcdir)
 DATA_built = admin81.sql
+DATA = admin81_uninstall.sql
 DOCS = README.admin81
 OBJS = admin81.o

Index: README.admin81
===================================================================
--- README.admin81    (revision 5029)
+++ README.admin81    (working copy)
@@ -36,6 +36,18 @@

 On PostgreSQL 8.1 or above, you should use the admin81.sql script.

+Uninstall
+============
+
+To uninstall use the helper script admin81_uninstall.sql:
+
+psql -U postgres postgres < admin81_uninstall.sql
+
+and then run:
+
+make [USE_PGXS=1] uninstall
+
+
 Objects implemented (superuser only)
 ====================================

/* ***********************************************
 * Cleanup administrative functions
 * for PostgreSQL 8.1.x
 * *********************************************** */

/* drop generic file access functions (genfile.c) */

DROP FUNCTION pg_catalog.pg_file_write(text, text, bool);

DROP FUNCTION pg_catalog.pg_file_rename(text, text, text);

DROP FUNCTION pg_catalog.pg_file_unlink(text);

DROP FUNCTION pg_catalog.pg_file_rename(text, text);

DROP FUNCTION pg_catalog.pg_logdir_ls();

/* Drop compatibility redefines */

DROP FUNCTION pg_catalog.pg_logfile_rotate();

DROP FUNCTION pg_catalog.pg_file_read(text, bigint, bigint);

DROP FUNCTION pg_catalog.pg_file_length(text);

pgadmin-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: select inside transactions
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r5030 - trunk/pgadmin3/src