Al igual que en el post para Mysql necesito tener a mano esta anotacion por mi mente desmemoriada. :)

En pg_hba.conf añadir la linea :

hosttemplate1postgres127.0.0.1 255.255.255.0 trust

Reiniciar el servidor

$psql -U postgres -h 127.0.0.1 template1
#template1> ALTER USER postgres with password 'ElNuevoPassword';

Reiniciar el servidor ( esto no creo que sea necesario )

Well done!

Caregorias

Tags

  • postgresql

Add new comment

About text formats

Filtered HTML

  • Web page addresses and email addresses turn into links automatically.
  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
CAPTCHA
1 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.