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
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 |