Keep getting authentication failure when trying to restore database

From: Søren Neigaard <s(dot)neigaard(at)mobilethink(dot)dk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Keep getting authentication failure when trying to restore database
Date: 2002-09-02 07:28:24
Message-ID: 003001c25252$52da0150$200110ac@mt45neigaard
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have made a pg_dump of my database, and now I want to restore it on
another database. So I follow the instructions on
"http://www2.dk.postgresql.org/users-lounge/docs/7.1/admin/backup.html"
(both databases are 7.1 on Debian), but I keep getting "psql: Password
authentication failed for user 'postgres'" all the time.

I have looked in my dump file, and seen that it tries to connect first as
postgres, and thereafter as my other user that owns the tables. How do I
allow it to connect as these users? Can I somehow disable the passwords, and
how is this done?

Med venlig hilsen/Best regards
Søren Neigaard
System Architect
................................
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 5.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: s(dot)neigaard(at)mobilethink(dot)dk
Web: www.mobilethink.dk
................................

Browse pgsql-general by date

  From Date Subject
Next Message wlj 2002-09-02 08:39:36 about nowait
Previous Message NISHAL K.R 2002-09-02 07:13:05