2006/10/31, Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>:
> > I have a little problem. I have an .sql file ( db dump )
> > and i want to import it to postgres on linux.
> > Does anyone know how i can do it?
> You feed it to the command line interface psql.
> psql -h host -p port -d database -U user <dump.sql
It's a good enough solution in most cases, but when the rowcount
starts to skyrocket, it simply doesn't seem to cut it (at least I
couldn't make it to). To load 1,5M rows (~230MB of INSERT statements),
I used gvim (wonderful tool!) to transform the INSERT statements into
a CSV file and then used an ETL (kettle - another wonderful tool) tool
to import the data into the database.
This could have probably been done much easier: I'd welcome a helpful
hint so as I know next time. :)
In response to
pgsql-general by date
|Next:||From: Ron Johnson||Date: 2006-10-31 23:59:06|
|Subject: Text manipulation tools (was Re: postgres import)|
|Previous:||From: Dimitri Fontaine||Date: 2006-10-31 22:38:44|
|Subject: Re: updating to 7.4.13 helped it appears|