If you continue to have trouble with this issue, posting to the postgres ADMIN list will probably get good suggestions.
If you can edit the pg_hba.conf and add the user running the drop with a "trust" level and then reload postgres it won't ask for a password. The pg_hba.conf files lives with the config file for postgres itself in the "main" directory, e.g. /etc/postgresql/9.1/main HTH, Greg Williamson >________________________________ > From: Smaran Harihar <smaran.hari...@gmail.com> >To: PostGIS Users Discussion <postgis-users@postgis.refractions.net> >Sent: Tuesday, June 19, 2012 11:49 AM >Subject: [postgis-users] Unable to drop user and db > > >Hi Guys, > > >I am trying to execute the following command to remove user and db geonode, > > >if su - postgres -c 'psql -l | grep -q geonode'; then su - postgres -c 'dropdb >geonode'; su - postgres -c 'dropuser geonode'; fi > > >It is asking me for a password. I do not the password. How can I change this >password or drop the user and db without knowing the password? > > >-- >Thanks & Regards >Smaran Harihar > >_______________________________________________ >postgis-users mailing list >postgis-users@postgis.refractions.net >http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
