in ubuntu you can try this: sudo su postgres
which should make you the ubuntu-user "postgres" As this you can run psql, createdb ... generally read https://help.ubuntu.com/10.04/serverguide/C/postgresql.html and https://help.ubuntu.com/community/PostgreSQL which gives some nice startingpoints Thomas Am 14.02.2012 10:52, schrieb Zelio Fernandes: > Hi also tried with no password and it gave me error as : > > *An error has occurred: > > Error connecting to the server: fe_sendauth: no password supplied > * > > i cannot do anything because postgres is a superuser and only it has all the > roles. > Unless i give current password it wont allow me to change the password of > superuser(postgres). > How can i delete the postgres super user and create it again so that i can > give a new password > > -- > View this message in context: > http://postgis.17.n6.nabble.com/what-is-the-default-password-of-Postgres-user-in-POSTGIS-2-0-tp4468052p4468107.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users -- Thomas Baschetti - Systemanalyse Geographische Informationssysteme Hakenstraße 8D 49074 Osnabrück Tel: 0541 25 91 90 | mobil 01577 189 25 91 E-Mail: [email protected] www.thomas-baschetti.de Ust-IdNr.: DE264355072 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
