|
Home > Archive > PostgreSQL Discussion > April 2006 > How can i import .backup file into the database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How can i import .backup file into the database
|
|
| venu gopal 2006-04-04, 7:33 am |
| 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.
Thanks in advance,
venu
| |
| Peter Eisentraut 2006-04-04, 7:34 am |
| 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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Jim Nasby 2006-04-07, 3:36 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
|
|
|
|