http://forums.enterprisedb.com/posts/list/9.page JForum - http://www.jforum.net
What is the way to uninstall Postgresql, once installed using the .bin installer (postgresql-8.3.3-2-linux.bin) ?

I tried "uninstall-postgresql", but I got "Uninstallation did not complete successfully", and noting changed.

Please, advise.

Best regards,
CB

OS : Debian Etch]]> http://forums.enterprisedb.com/posts/preList/1437/5082.page http://forums.enterprisedb.com/posts/preList/1437/5082.page GMT
What is the way to uninstall Postgresql, once installed using the .bin installer (postgresql-8.3.3-2-linux.bin) ?

I tried "uninstall-postgresql", but I got "Uninstallation did not complete successfully", and noting changed.

Please, advise.

Best regards,
CB

OS : Debian Etch[/quote]

Hmm, strange. Is that the entire message text?

The easiest possible fix would be to re-run the installer, which we've found can fix the uninstaller (they normally only break when we make silly mistakes in development though - and what you have has been thoroughly tested). Then, try re-running the uninstaller.

Failing that, you can try a manual uninstallation (as root, assuming a default installation path):

/opt/PostgreSQL/8.3/installer/server/removeshortcuts.sh /opt/PostgreSQL/8.3 8.3
/etc/init.d postgresql-8.3 stop
rm -rf /opt/PostgreSQL
rm /etc/postgres-reg.ini
rm -rf /etc/init.d/postgresql-8.3
userdel postgres

if /etc/ld.so.conf exists, edit it and remove /opt/PostgreSQL/8.3/lib
if present.

if /etc/ld.so.conf.d exists:

rm /etc/ld.so.conf.d/postgresql-8.3.conf

]]> http://forums.enterprisedb.com/posts/preList/1437/5084.page http://forums.enterprisedb.com/posts/preList/1437/5084.page GMT http://forums.enterprisedb.com/posts/preList/1437/5635.page http://forums.enterprisedb.com/posts/preList/1437/5635.page GMT
Via uninstaller:

1) In the installation directory, there will be a uninstall-postgresql.app file will be there, executing (double clicking) that will uninstall the postgresql installation.

Manual Uninstallation:

1) Stop the server

sudo /sbin/SystemStarter stop postgresql-8.3

2) Remove menu shortcuts:

sudo rm -rf /Applications/PostgreSQL 8.3

3) Remove the ini file

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

4) Removing Startup Items

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

5) Remove the data and installed files

sudo rm -rf /Library/PostgreSQL/8.3

6) Delete the user postgres

sudo dscl . delete /users/postgres]]> http://forums.enterprisedb.com/posts/preList/1437/5636.page http://forums.enterprisedb.com/posts/preList/1437/5636.page GMT i tried this:
rd /s /q "C:\program files\postgresql"
net user postgres /delete

but it's not enought

Please, advice.

best regards;

thanks
]]> http://forums.enterprisedb.com/posts/preList/1437/6050.page http://forums.enterprisedb.com/posts/preList/1437/6050.page GMT
Via Uninstaller:

i) Go to the Add/Remove Programs and uninstall postgresql server from there or go to the postgresql server installation directory and run the uninstaller.

Manual Uninstallation:

i) Remove the postgresql server installation directory. (rd /s /q "C:\Program Files\PostgreSQL\8.3") Assuming default location.

ii) Delete the user 'postgres' (net user postgres /delete)

iii) Remove the Registry entries. (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.3) and (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-8.3)

iv) Remove the postgresql-8.3 service. (sc delete postgresql-8.3)


]]> http://forums.enterprisedb.com/posts/preList/1437/6074.page http://forums.enterprisedb.com/posts/preList/1437/6074.page GMT
thank you very much
]]> http://forums.enterprisedb.com/posts/preList/1437/6076.page http://forums.enterprisedb.com/posts/preList/1437/6076.page GMT
I decided to give Postgresql a go after hearing about it all the time. As a result seeing I was going to "give it a go" I gave the initial install [super]usernames, server and database just some silly names, to see how it all worked.

Well now that I want to uninstall/reinstall I can't get it to lose all the silly names. Everytime I try it comes back with those initial setting instead of giving me a clean setup. I have never had this proplem with other software. I will try the above instructions and see if that helps.

The uninstall is not clearing things out properly. Hopefully this will be fixed in the future.

My Linux box at home I setup later so I gave it the names I wanted to use and have not dared to attempt an uninstall to see if it suffers from the same issues.]]> http://forums.enterprisedb.com/posts/preList/1437/6086.page http://forums.enterprisedb.com/posts/preList/1437/6086.page GMT
All that uninstaller leaves behind is:

i) The service user account 'postgres'

Reason: That account is being used by any other postgresql installations. and if in case user doesnt need it he can manually delete the user as told in previous postings.

ii) The data directory.

Reason: It is not advisable to delete the data directory as it may contains useful information and can be used afterwards (with other postgresql installations) and if in case that directory is not important, user can any time delete it manually.

Apart from the above two, the installer wont delete any file/directory that is being created (within the postgresql installation directory) by the user, after installation.
]]> http://forums.enterprisedb.com/posts/preList/1437/6087.page http://forums.enterprisedb.com/posts/preList/1437/6087.page GMT
Ideally the windows uninstall through the control panel/add remove programs should deal with registry entries removal. Who knows what damage I've done in there.]]> http://forums.enterprisedb.com/posts/preList/1437/6097.page http://forums.enterprisedb.com/posts/preList/1437/6097.page GMT
I install again from the MSI fie (bypassing the option of starting it as a service, I want to start it manually.) and now it does not create a data directory nor do I have my postgres user. I am also not able to add a server in pgadmin III (it shows none and won't let be create one.).]]> http://forums.enterprisedb.com/posts/preList/1437/6098.page http://forums.enterprisedb.com/posts/preList/1437/6098.page GMT
I suggest you to use the one-click installer (.exe one) because that is maintained by us. and all the above postings were made assuming the user had used the one-click installer only.]]> http://forums.enterprisedb.com/posts/preList/1437/6099.page http://forums.enterprisedb.com/posts/preList/1437/6099.page GMT
Problem running post-install step. Installation may not complete correctly Error reading file C:/Program Files/PostgreSQL/8.3/data/postgresql.conf]]> http://forums.enterprisedb.com/posts/preList/1437/6107.page http://forums.enterprisedb.com/posts/preList/1437/6107.page GMT
Can you please post the contents [error part] of the installation log present in your system's temp directory (%TEMP%\install_postgresql.log). Also, please let us know the version of windows you are using. ]]> http://forums.enterprisedb.com/posts/preList/1437/6108.page http://forums.enterprisedb.com/posts/preList/1437/6108.page GMT
I deleted everything postgres I could find and reinstalled (this time to another location) and still got the same error.

Below is the tail end of the log file.

[quote]
Starting the database server...
Executing cscript
Script exit code: 0

Script output:
Starting postgresql-8.3
Service postgresql-8.3 started successfully
startserver.vbs ran to completion

Script stderr:


Loading additional SQL modules...
Executing cscript
Script exit code: 0

Script output:
Installing pl/pgsql in the template1 databases...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

Installing the adminpack module in the postgres database...
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

loadmodules.vbs ran to completion

Script stderr:


Write the data directory to the ini file...
Write the port number, service ID, locale and superuser to the ini file...
Problem running post-install step. Installation may not complete correctly
Error reading file D:/Installed Software/PostgreSQL/8.3/data/postgresql.conf
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 06/03/09 at 09:32:51
]]> http://forums.enterprisedb.com/posts/preList/1437/6119.page http://forums.enterprisedb.com/posts/preList/1437/6119.page GMT http://forums.enterprisedb.com/posts/preList/1437/8927.page http://forums.enterprisedb.com/posts/preList/1437/8927.page GMT
The uninstaller will not be created when you run the installer in upgrade mode. You can use these steps to uninstall postgresql from your mac.

i) Stop the server.
sudo launchctl unload /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

ii) Remove the plist file
sudo rm -f /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

iii) Remove the Applications Menu.
sudo rm -f "/Applications/PostgreSQL 8.4"

iv) Remove the installation directory
sudo rm -rf /Library/PostgreSQL/8.4
(Note: You can backup your data directory in case you need it.)

v) Remove the 'postgres' user
sudo dscl . delete /Users/postgres
(Note: This step is optional)

vi) Remove the ini file
sudo rm -f /etc/postgres-reg.ini

After these steps, PostgreSQL is completely removed from your system.

You can run the latest installer again to install PostgreSQL (You can also point the installation to use your backed up data directory also). This time it will create the uninstaller.

Hope it helps.]]> http://forums.enterprisedb.com/posts/preList/1437/8929.page http://forums.enterprisedb.com/posts/preList/1437/8929.page GMT I am Using CentOS, Whether anyone have any idea how to uninstall POSGRESQL in Centos?

Thanks]]> http://forums.enterprisedb.com/posts/preList/1437/9677.page http://forums.enterprisedb.com/posts/preList/1437/9677.page GMT http://forums.enterprisedb.com/posts/preList/1437/9694.page http://forums.enterprisedb.com/posts/preList/1437/9694.page GMT
Can you please copy paste the first and last 10 lines of the installation logs (/tmp/postgresql.log)?

Did you try to upgrade or install a new instance?]]> http://forums.enterprisedb.com/posts/preList/1437/9695.page http://forums.enterprisedb.com/posts/preList/1437/9695.page GMT
By mistake i uninstalled db_server, edbmtk and edbpgagent from database server.
Is there anyway to restore the database to the previous point?
Please help me in this issue]]> http://forums.enterprisedb.com/posts/preList/1437/11362.page http://forums.enterprisedb.com/posts/preList/1437/11362.page GMT http://forums.enterprisedb.com/posts/preList/1437/11363.page http://forums.enterprisedb.com/posts/preList/1437/11363.page GMT http://forums.enterprisedb.com/posts/preList/1437/11364.page http://forums.enterprisedb.com/posts/preList/1437/11364.page GMT