FAQ
I`m change the default passwod, and not conect for this user. What the
default password?


Raphael Giovanini
+55-11-9938-6810
"O que pensais, passais a ser" (Gandhi)

Search Discussions

  • John R Pierce at Apr 1, 2011 at 8:18 am

    On 03/31/11 6:50 PM, Raphael Giovanini wrote:
    I`m change the default passwod, and not conect for this user. What the
    default password?
    there is no default password. on most unix and linux distributions, the
    default authentication mode is set to 'ident' which means a given unix
    user X can only connect as the postgres user X. initially, the only
    postgres user is 'postgres', so...

    (assuming you're on the typical unix/linux system, you didn't say)

    $ sudo -u postgres psql

    postgres=> alter user postgres password 'apassword';
    postgres=> create user yerusername createdb createuser password
    'somepass';
    postgres=> create database yerusername owner yerusername;
    postgres=> \q

    $ ...

    now as your regular user 'yerusername' you can connect to postgres, and
    have the privileges to create new users and databases.

    That sequence also modified the postgres user's password in case you
    change the default authentication method to md5 (this is set in
    pg_hba.conf, see the documentation for more details)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedApr 1, '11 at 1:51a
activeApr 1, '11 at 8:18a
posts2
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase