Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com
	[208.25.171.37]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA17786
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 11 Nov 1999 16:32:32 -0500 (EST) (envelope-from ken@ori-ind.com)
Received: from ken (ken.cncware.com [192.168.61.201])
	by cncware.whidbey.com (8.9.3/8.9.3) with SMTP id NAA05394
	for <pgsql-interfaces@postgreSQL.org>; Thu, 11 Nov 1999 13:35:12 -0800
Message-Id: <3.0.32.19991111133248.00970900@ren.cncware.com>
X-Sender: ken_ori@ren.cncware.com
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Thu, 11 Nov 1999 13:32:50 -0800
To: pgsql-interfaces@postgreSQL.org
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] Error on db recovery..
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 13:00 11/11/1999 -0800, you wrote:
>Hello,
>I am attempting to recover a database previously secured with pg_dump,
>however on attempting to restore using 
>
>pgsql < db_security_file 

psql dbname < db_security_file
 or
psql dbname -f db_security_file
 or
psql dbname, then \i db_security_file at the command prompt

>I get the following error(s)
>
>
>ERROR:  tbl_breeders relation already exists
>
>I have removed all data tables and user from the database,
>what am I over looking?
>
>Stephen