[postgis-users] Unable to drop user and db

[Greg Williamson]

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.harihar at gmail.com>
>To: PostGIS Users Discussion <postgis-users at 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 at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>