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


From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: pg_restore
Date: 2002-03-27 16:58:47
Message-ID: 00b301c1d5b0$a9a15ed0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I have an empty database that we recreated from scratch in order to make some column changes. I would like to restore the data that was in the original 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 it is a 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 switch since 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 is the appropriate syntax becasue I have tried this and its not working.
Jodi Kanter

Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846




pgsql-admin by date

Next:From: Stephan SzaboDate: 2002-03-27 17:43:08
Subject: Re: timestamp in 7.2
Previous:From: Joe ConwayDate: 2002-03-27 16:36:15
Subject: Re: join vs. IN statement

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