Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by postgresql.org (Postfix) with SMTP id 72E0A4759A1 for ; Wed, 27 Mar 2002 11:54:55 -0500 (EST) Received: from smtp.mail.virginia.edu by mail.virginia.edu id ab06564; 27 Mar 2002 11:55 EST Received: from jlk3xpc (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.9.3/8.9.3) with SMTP id LAA24150 for ; Wed, 27 Mar 2002 11:54:59 -0500 Message-ID: <00b301c1d5b0$a9a15ed0$de138f80@virginia.edu> From: Jodi Kanter To: Postgres Admin List Subject: pg_restore Date: Wed, 27 Mar 2002 11:58:47 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B0_01C1D586.C0AE31E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200203/325 X-Sequence-Number: 3859 This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C1D586.C0AE31E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have an empty database that we recreated from scratch in order to make so= me column changes. I would like to restore the data that was in the origina= l database. Will it work given that their are some new fields that did not = exist before? Am I correct in that I cannot do this from pg_restore since i= t is a plain text file?=20 The data dump was created using the following syntax:=20 pg_dump genex -u -a > ./genex_data.backup (I have to use the -u switch sinc= e I have implemented forced sign on through the pg_passwd utility) How can I get this data back in? pg_restore? psql command? and if so what i= s the appropriate syntax becasue I have tried this and its not working. thanks Jodi Kanter _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu =20 =20 =20 ------=_NextPart_000_00B0_01C1D586.C0AE31E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I have an empty database that we recreated from scratch in order to ma= ke=20 some column changes. I would like to restore the data that was in the origi= nal=20 database. Will it work given that their are some new fields that did not ex= ist=20 before? Am I correct in that I cannot do this from pg_restore since it is a= =20 plain text file?

The data dump was created using the following syntax:

pg_dump genex -u -a > ./genex_data.backup (I have to use the -= u=20 switch since I have implemented forced sign on through the pg_passwd=20 utility)

How can I get this data back in? pg_restore? psql command? and if so w= hat=20 is the appropriate syntax becasue I have tried this and its not working.

thanks

Jodi Kanter

_______________________________
Jodi=20 L Kanter
BioInformatics Database Administrator
University of=20 Virginia
(434) 924-2846
jkanter@virginia.edu

<= /DIV> ------=_NextPart_000_00B0_01C1D586.C0AE31E0--