an error regarding pg_dump

From: <rashmi(at)it(dot)iitb(dot)ac(dot)in>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: an error regarding pg_dump
Date: 2003-03-29 13:40:21
Message-ID: 1069.10.129.111.40.1048945221.squirrel@www.it.iitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Hello sir,
i am working in a project based on POstgreSQL database & project requires
the backup & restoration facility of the database so that if the server
crash the database can be recovered from the archive file.
i did
pg_dump LCC>backup.sql

exported backup.sql from one server1 TO another

then created a database'CMS' with Template0 on another server2 so that CMS
is the exact copy of the LCC

when in server2 i do the restoration with

psql -d CMS -f backup.sql or cat backup.sql | psql CMS

it sometimes ask for password & sometimes says

[root(at)localhost pgsql]# psql -d CMS -f backup.sql;
psql:backup.sql:4: \connect: FATAL 1: IDENT authentication failed for
user "admin"

admin is the username of 'LCC' database.

plz send the reply soon & help me in sorting out the problem.

rashmi bhatia
IIT Bombay

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2003-04-01 18:59:40 Re: Compile of pgsql v7.1.3 fails on Red Hat 8.0
Previous Message Tom Lane 2003-03-28 19:55:11 Re: nextval syntax