Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Posts
    135

    Unanswered: password authentication failed for user "postgres"

    Hi,

    I have created a user and a database with login postgres 5 days back

    but now when i am login with postgres
    password authentication failed for user "postgres"

    like this
    bash-3.2$ psql -W postgres postgres
    Password for user postgres:
    psql: FATAL: password authentication failed for user "postgres"

    can any one help how to login for postgres it some what urgent

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    You are sure you entered the correct password?

    If you forgot the password and the server is running locally, check out this post:

    Re: postgres user, forgotten password

  3. #3
    Join Date
    Dec 2008
    Posts
    135
    hi,

    Now i am accessing the database i have kill the process with processid
    and restart the postgresql then it is working

    now i want to Setup a multiple Postgresql instances on one machine/box
    can any one suggested me how to do?

    i tried as initdb -D /var/lib/pgsql/data/pgsql02

    i want to change the portnumber to 5433 how can i do that

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by bklr
    i want to change the portnumber to 5433 how can i do that
    In postgresql.conf

    PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Connections and Authentication

  5. #5
    Join Date
    Dec 2008
    Posts
    135
    Code:
    hi shammat, thanks for ur help 
    
    i have created a new instance 
    following steps:
    1.You would need to do an initdb command to create one more instance of postgresql database
    initdb -D /var/lib/pgsql/data/pgsql02
    2. Change the port number in postgresql.conf maybe by +1 or +2 or so
    3. Run the postgresql with the new database instance
    postmaster -D  /var/lib/pgsql/data/pgsql02
    4. Connect to each of the postgresql server instances
    psql postgres -p 5433

  6. #6
    Join Date
    Dec 2008
    Posts
    135
    i have create a portnumber 5433
    and i am unable to see in the phpadmin web page
    and how to create a new server with port number 5433

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •