change postgresql root password

Monday, 23 June 2008 at 13:12 UTC 3 comments

under ubuntu it is very easy to change postgresql database root password:

su -

su – postgres

psql  -d template1

template1=# ALTER USER postgres WITH PASSWORD ‘NEW_PASSWORD’;

\q

Advertisements

Entry filed under: database. Tags: .

sensors xfce4 plugin in ubuntu hardy otrs ticket system installation under ubuntu

3 Comments Add your own

  • 1. links for 2009-12-04 | Pratyush Kotturu - KE5YQZ  |  Friday, 4 December 2009 at 20:04 UTC

    […] Tech Department of Music L2Ork – Linux Laptop Orchestra 19 hours agoGoogle Public DNS 19 hours agochange postgresql root password « moojix web technology blog 20 hours agoIPTables HowTo – Community Ubuntu Documentation 20 hours agoHow to install postgresql […]

    Reply
  • 2. Euan Thoms  |  Saturday, 19 November 2011 at 18:38 UTC

    Thanks, helped. One small correction though: the ALTER command should end with a semicolon “;” , as with any SQL command.

    Reply
    • 3. moojix  |  Saturday, 19 November 2011 at 21:34 UTC

      no problem. added the “;” and the end of the line.

      Reply

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

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories


%d bloggers like this: