Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-ports by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group