<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
hi,<br>
<br>
what you have to do first is to change the default password that
comes from the installation process, to do this:<br>
<br>
sudo su postgres -c "psql template1" <br>
<br>
template1=# ALTER USER postgres WITH PASSWORD 'new_password';<br>
<br>
I hope this helps you,<br>
Helen<br>
<br>
El 14/02/12 10:26, Zelio Fernandes escribió:
<blockquote cite="mid:1329211565884-4468052.post@n6.nabble.com"
type="cite">
<pre wrap="">Hi
I use ubuntu 11.04 operating system.
i installed POSTGIS 2.0 and POSTGRES 9.1.2 but while installing POSTGIS has
not asked me to give any password.
and when i tried to create a new database through SUPERUSER that is
username : postgres
password : ? (i dont know) - tried password as postgres and root but both
didnt work.
How to access the super user password?
The error i get is :
An error has occurred:
Error connecting to the server: FATAL: password authentication failed for
user "postgres"
FATAL: password authentication failed for user "postgres"
--
View this message in context: <a class="moz-txt-link-freetext" href="http://postgis.17.n6.nabble.com/what-is-the-default-password-of-Postgres-user-in-POSTGIS-2-0-tp4468052p4468052.html">http://postgis.17.n6.nabble.com/what-is-the-default-password-of-Postgres-user-in-POSTGIS-2-0-tp4468052p4468052.html</a>
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<p> Helen San Segundo Navazo<br>
<br>
Tècnica de productes<br>
Tel. 93 567 60 90<br>
Fax 93 567 61 02<br>
A/e <a href="mailto:hsansegundo@meteo.cat">hsansegundo@meteo.cat</a><br>
</p>
<p>
<img src="cid:part1.00040106.08070507@meteo.cat"><br>
<a href="http://www.meteo.cat">http://www.meteo.cat</a><br>
<br>
Carrer Berlín 38-46, 4a planta<br>
08029 Barcelona
</p>
<p><font color="seagreen">Abans d’imprimir aquest correu,
assegureu-vos que és del tot necessari. El medi ambient és
cosa de tothom!</font></p>
<p>La informació d'aquesta transmissió electrònica és confidencial
i el seu ús sols està permès als seus destinataris. Si Vostè no
és la persona destinatària d'aquesta transmissió electrònica, li
preguem que ens ho comuniqui de forma immediata i destrueixi
qualsevol copia de la mateixa (tant digital com en paper).</p>
</div>
</body>
</html>