Home > Postgresql > PostgreSQL default password

PostgreSQL default password

Step 1: open terminal

Step 2: su postgres

Note: If you don’t remember the postgres (ubuntu user) password then use the command ‘sudo passwd postgres’

Stept 3: Type ‘psql’ and enter

Step 4: Use the following command to change the posgres user password

alter user postgres with password ‘newpassword’;

‘\q’ is used to exit psql

and Finsish

Categories: Postgresql
  1. January 24, 2011 at 5:20 am

    PostgreSQL password in windows when installing openerp
    when we install “openerp all in one” it also install postgresql.
    with user name =’openpg’ and password =’openpgpwd ‘
    open the pgAdmin III, open the query terminal from using above user name and password.
    use the following command;
    alter user openpg with password ‘new_passward’
    note: new password will also need to reset in openerp server config files, else server will not connect to database.

  2. sangeen
    November 2, 2011 at 7:39 pm

    Thank you sir

  3. sangeen
    November 2, 2011 at 7:43 pm

    Thank you sir,
    sir if want to run a program as debug using eclipse, what we will?

  4. November 4, 2011 at 6:12 pm

    In Eclipse: follow menu Window->Show View->Other and then select Debug from Debug item.
    now Add break points in your code by right clicking at your code’s right side column
    Third Run your file in debug mode from Run-> ‘Deubg As’.
    you will fine your code in debug view with its available tools on toolbar. enjoy
    and thanks for complement

  5. November 13, 2011 at 4:17 pm

    but first may we have too kill servers in terminal and i don’t know how the way we kill servers

    • November 30, 2011 at 1:21 pm

      i don’t know which servers u are talking about, can u plz explain ur question so that i can easily sort out your problem.

      • December 4, 2011 at 10:19 am

        to run a program in debug mod in Eclips first we parform some command in terminal wiche are:

        ps aux|grep openerp
        sudo kill 2341
        sudo kill 2576

        But i am not clear that wiche server should kill and wiche should not kill to run a program in debuge mod

        • December 7, 2011 at 4:57 am

          I never kill any process for debugging in eclipse and also i did not find any problem in OpenERP official blogs & discussion forums like u mentioned.
          brother try debug in eclipse without killing any process. and btw brother! ps aux|grep openerp list the running processes in Ubuntu having name openerp, still i can’t able to understand, which server u want to kill and purpose.

  6. November 13, 2011 at 4:33 pm


    • December 7, 2011 at 9:46 am

      ok sir!
      sir what is the consipt of Inheritance in openerp?
      i.e: _inherit = ‘object.name’

  7. tag
    March 3, 2012 at 1:10 pm

    Note: If you don’t remember the postgres (ubuntu user) password then use the command ‘sudo passwd postgres’

    Please check the following link at stack exchange.

    It seems, resetting the postgres user password is not recommended. They suggest running the command as
    sudo -u postgres psql postgres

    Ubuntu Postgres installation guide also mentions the same methodology:

    Thank you.

    • March 3, 2012 at 6:01 pm

      Thanks brother,
      for your nice sharing, next i time will use the same way u told, and i think audience too

  8. nykid102
    March 22, 2013 at 2:47 am

    I have been looking around for an hour for this answer and finally found this for the win!

  1. January 2, 2014 at 10:00 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: