Обсуждение: complete uninstall of postgres 9.0.4

Поиск

Список

Период

Сортировка

complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 13:11:38

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 13:44:07

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

Re: complete uninstall of postgres 9.0.4

От

Baux David

Дата:

07 ноября 2011 г., 14:07:48

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 14:38:02

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 14:41:01

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?

> 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

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

Re: complete uninstall of postgres 9.0.4

От

Baux David

Дата:

07 ноября 2011 г., 14:51:39

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

Re: complete uninstall of postgres 9.0.4

От

Arvind Sharma

Дата:

07 ноября 2011 г., 14:56:27

If the regular /Applications/PostgreSQL 9.0/uninstall-postgresql.app doesn't help then there are manual steps which will remove ALL the elements of the PG

Manual Uninstallation:

1) Stop the server

sudo /sbin/SystemStarter stop postgresql-9.0

2) Remove menu shortcuts:

sudo rm -rf /Applications/PostgreSQL 9.0

3) Remove the ini file

sudo rm -rf /etc/postgres-reg.ini

4) Removing Startup Items

sudo rm -rf /Library/StartupItems/postgresql-9.0

5) Remove the data and installed files

sudo rm -rf /Library/PostgreSQL/9.0

6) Delete the user postgres

sudo dscl . delete /users/postgres

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: pgsql-novice@postgresql.org
Sent: Monday, November 7, 2011 6:02 AM
Subject: [NOVICE] complete uninstall of postgres 9.0.4

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 15:18:26

Arvind,

files such as: /Applications/PostgreSQL 9.0 and /etc/postgres-reg.ini

do not exist on my machine.

On Mon, Nov 7, 2011 at 10:42 AM, Arvind Sharma <arvind321@yahoo.com> wrote:

If the regular /Applications/PostgreSQL 9.0/uninstall-postgresql.app doesn't help then there are manual steps which will remove ALL the elements of the PG

Manual Uninstallation:

1) Stop the server

sudo /sbin/SystemStarter stop postgresql-9.0

2) Remove menu shortcuts:

sudo rm -rf /Applications/PostgreSQL 9.0

3) Remove the ini file

sudo rm -rf /etc/postgres-reg.ini

4) Removing Startup Items

sudo rm -rf /Library/StartupItems/postgresql-9.0

5) Remove the data and installed files

sudo rm -rf /Library/PostgreSQL/9.0

6) Delete the user postgres

sudo dscl . delete /users/postgres

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: pgsql-novice@postgresql.org
Sent: Monday, November 7, 2011 6:02 AM
Subject: [NOVICE] complete uninstall of postgres 9.0.4

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 15:21:54

well, by "configuration nonsense" what I mean is that when I uninstall using brew and then install again using brew and try to start the server or run my rails app, i get messages telling me that there is something already running on port 5432. incidentally, i also installed "brew install postgis". not sure if i mentioned that in my original post.

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

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 15:24:29

not sure if this is a clue to anything but i'm getting this output:

> ps auxwww | grep postgres

postgres 53692 0.0 0.0 0 0 ?? Z 4:36PM 0:00.00 (userInit)

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

well, by "configuration nonsense" what I mean is that when I uninstall using brew and then install again using brew and try to start the server or run my rails app, i get messages telling me that there is something already running on port 5432. incidentally, i also installed "brew install postgis". not sure if i mentioned that in my original post.

On Mon, Nov 7, 2011 at 10:39 AM, Baux David <david.baux@inserm.fr> wrote:
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

Re: complete uninstall of postgres 9.0.4

От

Arvind Sharma

Дата:

07 ноября 2011 г., 15:35:13

Looks like an non-standard Install then, on Mac OS. Or the PostgreSQL 9.0 is already deleted from the /Applications area, which is ok.

The INI file is just a data file which stores information when PG starts up. If that is not there, no problem.

If you can remove all the rest, reboot the Mac, then see if all the tell tale signs of PG are gone or not.

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: Arvind Sharma <arvind321@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Monday, November 7, 2011 8:04 AM
Subject: Re: [NOVICE] complete uninstall of postgres 9.0.4

Arvind,

files such as: /Applications/PostgreSQL 9.0 and /etc/postgres-reg.ini
do not exist on my machine.

On Mon, Nov 7, 2011 at 10:42 AM, Arvind Sharma <arvind321@yahoo.com> wrote:
If the regular /Applications/PostgreSQL 9.0/uninstall-postgresql.app doesn't help then there are manual steps which will remove ALL the elements of the PG

Manual Uninstallation:

1) Stop the server

sudo /sbin/SystemStarter stop postgresql-9.0

2) Remove menu shortcuts:

sudo rm -rf /Applications/PostgreSQL 9.0

3) Remove the ini file

sudo rm -rf /etc/postgres-reg.ini

4) Removing Startup Items

sudo rm -rf /Library/StartupItems/postgresql-9.0

5) Remove the data and installed files

sudo rm -rf /Library/PostgreSQL/9.0

6) Delete the user postgres

sudo dscl . delete /users/postgres

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: pgsql-novice@postgresql.org
Sent: Monday, November 7, 2011 6:02 AM
Subject: [NOVICE] complete uninstall of postgres 9.0.4

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

Re: complete uninstall of postgres 9.0.4

От

Ramy Abdel-Azim

Дата:

07 ноября 2011 г., 15:56:35

well, i rolled the dice and re-installed Postgres 9.1 using the one-click installer (instead of using "brew install postgres"). so far, this seems to be working.

thanks to everyone for all the help and the quick responses.

On Mon, Nov 7, 2011 at 11:23 AM, Arvind Sharma <arvind321@yahoo.com> wrote:

Looks like an non-standard Install then, on Mac OS. Or the PostgreSQL 9.0 is already deleted from the /Applications area, which is ok.

The INI file is just a data file which stores information when PG starts up. If that is not there, no problem.

If you can remove all the rest, reboot the Mac, then see if all the tell tale signs of PG are gone or not.

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: Arvind Sharma <arvind321@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Monday, November 7, 2011 8:04 AM
Subject: Re: [NOVICE] complete uninstall of postgres 9.0.4

Arvind,

files such as: /Applications/PostgreSQL 9.0 and /etc/postgres-reg.ini
do not exist on my machine.

On Mon, Nov 7, 2011 at 10:42 AM, Arvind Sharma <arvind321@yahoo.com> wrote:
If the regular /Applications/PostgreSQL 9.0/uninstall-postgresql.app doesn't help then there are manual steps which will remove ALL the elements of the PG

Manual Uninstallation:

1) Stop the server

sudo /sbin/SystemStarter stop postgresql-9.0

2) Remove menu shortcuts:

sudo rm -rf /Applications/PostgreSQL 9.0

3) Remove the ini file

sudo rm -rf /etc/postgres-reg.ini

4) Removing Startup Items

sudo rm -rf /Library/StartupItems/postgresql-9.0

5) Remove the data and installed files

sudo rm -rf /Library/PostgreSQL/9.0

6) Delete the user postgres

sudo dscl . delete /users/postgres

Arvind

From: Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>
To: pgsql-novice@postgresql.org
Sent: Monday, November 7, 2011 6:02 AM
Subject: [NOVICE] complete uninstall of postgres 9.0.4

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

Re: complete uninstall of postgres 9.0.4

От

Tom Lane

Дата:

07 ноября 2011 г., 17:18:44

Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com> writes:
> 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)

Hmmm ... you said you're running on OS X Lion?  If you are, then a lot
of these hits correspond to the postgresql code installed *by Apple*
as part of the OS, and it's likely not such a good idea to remove them.
(Yes, they ship 9.0.4 with Lion, or large chunks of it anyway.  I think
you need to buy Lion Server to get a complete working server from Apple,
but all the client-side code is there in the base OS.)

It's possible to set up a user install of a different version of
Postgres without conflicting with Apple's copy, but it has to go into
different directories, such as /usr/local.  Trying to remove Apple's
copy altogether doesn't sound like the way to proceed.

            regards, tom lane

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: complete uninstall of postgres 9.0.4