Re: complete uninstall of postgres 9.0.4 - Mailing list pgsql-novice

Dear ramy,

ok "manual" uninstall does not seem to be a good idea. Most of your results do not actually correspond to postgresql. And a lot of what has been installed does not appear. You mentionned in your first message that the uninstall process left  "a bunch of configuration  nonsense". Could you tell us what it is? Does someone else successfully uninstalled postgres via brew??

david


Le 07/11/11 16:19, Ramy Abdel-Azim a écrit :

sorry here's the whole result of my find (i only posted just a little over half the first time - very sorry. i don't frequent the mailing lists as much as I should)

 

> sudo find / -name "*postgres*"             

find: /dev/fd/3: Not a directory

find: /dev/fd/4: Not a directory

/Library/Ruby/Gems/1.8/doc/activerecord-3.1.1/rdoc/lib/active_record/connection_adapters/postgresql_adapter_rb.html

/Library/Ruby/Gems/1.8/doc/activerecord-3.1.1/ri/ActiveRecord/ConnectionAdapters/PostgreSQLAdapter/postgresql_version-i.ri

/Library/Ruby/Gems/1.8/doc/arel-2.2.1/rdoc/lib/arel/visitors/postgresql_rb.html

/Library/Ruby/Gems/1.8/gems/activerecord-3.1.1/lib/active_record/connection_adapters/postgresql_adapter.rb

/Library/Ruby/Gems/1.8/gems/arel-2.2.1/lib/arel/visitors/postgresql.rb

/Library/Ruby/Gems/1.8/gems/arel-2.2.1/test/visitors/test_postgres.rb

/Library/Ruby/Gems/1.8/gems/railties-3.1.1/lib/rails/generators/rails/app/templates/config/databases/jdbcpostgresql.yml

/Library/Ruby/Gems/1.8/gems/railties-3.1.1/lib/rails/generators/rails/app/templates/config/databases/postgresql.yml

/Library/WebServer/Documents/postgresql

/Library/WebServer/Documents/postgresql/html/app-postgres.html

/Library/WebServer/Documents/postgresql/html/postgres-user.html

/private/etc/apache2/users/postgres.conf

/private/var/db/dslocal/nodes/Default/groups/_postgres.plist

/private/var/db/dslocal/nodes/Default/sharepoints/postgres's Public Folder.plist

/private/var/db/dslocal/nodes/Default/users/_postgres.plist

/private/var/db/dslocal/nodes/Default/users/postgres.plist

/System/Library/DirectoryServices/DefaultLocalDB/Default/groups/_postgres.plist

/System/Library/DirectoryServices/DefaultLocalDB/Default/users/_postgres.plist

/Users/postgres

/Users/remcat/dev/working/startwire/vendor/plugins/foreign_keys/lib/foreign_keys/postgresql_adapter.rb

/Users/remcat/Library/Application Support/CrashReporter/postgres_DCCEF98F-4602-5FF7-964F-5E717AC007B4.plist

/Users/remcat/Library/Caches/Homebrew/postgresql-9.0.4.tar.bz2

/Users/remcat/Library/Caches/Metadata/Safari/History/http:%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fstatic%2Findex.html.webhistory

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/CrashReporter/postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/.postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash.plist

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194716_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194742_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194757_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-194958_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-203352_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Logs/DiagnosticReports/postgres_2011-11-06-203359_Ramys-MacBook-Pro.crash

/Users/remcat/Library/Saved Application State/org.postgresql.pgadmin.savedState

/usr/bin/postgres_real

/usr/include/postgres_ext.h

/usr/include/postgresql

/usr/include/postgresql/internal/postgres_fe.h

/usr/include/postgresql/server/postgres.h

/usr/include/postgresql/server/postgres_ext.h

/usr/include/postgresql/server/postgres_fe.h

/usr/lib/postgresql/usr/local/Library/Aliases/postgres

/usr/local/Library/Formula/postgresql.rb

/usr/local/var/postgres

/usr/local/var/postgres/postgresql.conf

/usr/share/devicemgr/backend/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb

/usr/share/devicemgr/backend/vendor/rails/railties/configs/databases/postgresql.yml

/usr/share/devicemgr/webserver/gems/gems/eventmachine-0.12.10/lib/em/protocols/postgres3.rb

/usr/share/man/man1/postgres.1.gz

/usr/share/postgresql

/usr/share/postgresql/postgres.bki

/usr/share/postgresql/postgres.description

/usr/share/postgresql/postgres.shdescription

/usr/share/postgresql/postgresql.conf

/usr/share/postgresql/postgresql.conf.sample

On Mon, Nov 7, 2011 at 10:17 AM, Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com> wrote:

ok, i'm going to go about this in a bit of a brute force manner for the sake of time, I apologize for bombarding everyone with this ugly post but it would helpful me significantly. the following is the output of my "sudo find" command. which files/directories are safe/necessary to delete?

 

On Mon, Nov 7, 2011 at 10:03 AM, Baux David <david.baux@inserm.fr> wrote:

Dear Ramy,

I confirm the message posted twice. I am also new to postgresql and I just switched to Lion so I am probably not very helpful but as it seems that you got no answers, I can try to give you some clues.
My postgresql install was not through brew, but if I understood weel, all should be in /usr/local. So if you can locate the file manually, or follow the symlinks, you can probably delete them manually (but be careful).
Maybe you should also check that the server was not running before launching the uninstall process (pg_ctl stop).

To answer your last question, I used the dmg directly downloaded from Postgres website, and everything did well (it installs in /Library/PostgreSQL/, and some stuff in /Applications/PostgreSQL/). And for post install, the documentation is quite complete. Installing DBD::Pg for perl on Lion worked also well.
BW

david




Le 07/11/11 15:36, Ramy Abdel-Azim a écrit :

Not sure if this has already posted, but I wasn't accepted to the mailing list the first time i sent it. apologies if it shows up twice.

_Ramy

On Mon, Nov 7, 2011 at 9:02 AM, Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com> wrote:

Hello,

It seems I've rather botched my installation of postgres onto my Mac OSX lion machine. I would like to "start over from scratch". I've tried "brew uninstall postgresql" but this seems to leave a bunch of configuration nonsense that I dont' need in my new installation still in tact (or something). In any case, instead of trying to figure out what i did wrong, I'd like to completely start over with the installation process. i don't need to retain any database tables or any data or anything like that. I'd like to get my machine back to a point where it knew nothing of postgres.

Please let me know if you can assist me.

And, along the way, if you know of any gotchas that come with trying to install postgres on mac osx lion, please let me know about them. I'm completely new to both Mac OSX lion (though not linux) and completely new to postgres (though i have used MySQL and SQL-Server in the past).

Thanks kindly,

_Ramy

--

Baux David
Ingénieur bioinformatique
Groupe neurosensoriel (site web)
Laboratoire de Génétique Moléculaire - CHU
IURC, Institut Universitaire de Recherche Clinique
UFR Médecine Site NORD UPM/IURC
641 Avenue du Doyen Giraud
34093 MONTPELLIER Cedex 5
Nouveau numéro:
04 11 75 98 76