Thread: How can i import .backup file into the database

Am Dienstag, 4. April 2006 10:59 schrieb venu gopal:
>     I am trying to import tables from a file called choro.backup.I have
> created a db called dhis.Is this not possible to import data from a .backup
> file.If it is not possible then how can i import the data into my
> database.Can you please give me the steps how to import the data from a
> .backup file.

Perhaps you could explain to us what format the .backup file has.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Apr 4, 2006, at 4:59 AM, venu gopal wrote:
> Dear List,
>     I am trying to import tables from a file called choro.backup.I
> have created a db called dhis.Is this not possible to import data
> from a .backup file.If it is not possible then how can i import the
> data into my database.Can you please give me the steps how to
> import the data from a .backup file.

PostgreSQL supports several different backup formats, and doesn't
care what you call them, so a .backup could be any of the three.
You'll need to take a look at the file to get an idea of what format
it's in. If it's in plain SQL you can just feed it to psql, if not
give us the first few lines and we can help. If it's just gibberish
then try running it through gunzip first.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461