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

Re: How to bulk load a schema using JDBC multiple times?

From: Andres Olarte <olarte(dot)andres(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: How to bulk load a schema using JDBC multiple times?
Date: 2005-10-19 16:00:44
Message-ID: 3fccaa690510190900u3f2f97afle989609094b34725@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
That's exactly what I need !

That's so easy I never thought it was useful for my situation, I was
looking for a complex way :(

Why do thing the easy way, if they can be done the hard way?

Thanks a lot !

On 10/19/05, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> http://www.postgresql.org/docs/8.0/interactive/manage-ag-templatedbs.html
>
> >>> Andres Olarte <olarte(dot)andres(at)gmail(dot)com>  >>>
> Hi,
>
> Yes, but how? I tried to create a stored procedure with all of the
> commands.  I tried creating a table in a special schema, storing the
> schema in that table, and executing commands off that table.  They
> have all failed due to quote problems.  Any other ideas?
>
> On 10/18/05, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> > Have you considered having your test suite create a template
> > database, and using it to drop and create the test database?
> >
> > >>> Andres Olarte <olarte(dot)andres(at)gmail(dot)com>  >>>
> > Hi,
> >
> > I need to load and drop my schema multiple times during my unit tests.
> > This happens several thousand times per run of my test suite.  I'm
> > loading the schema from the file that's generated by pg_dump, and it
> > works, but it's SLOW. My tests are taking more than 10 minutes now,
> > and most of the time is spent loading the schema.  If there away to do
> > this faster? May be using a store procedure with the whole schema?
> > I've tried making such a procedure, but it doesn't work do to quoting
> > problems. Anybody have any ideas? Thanks
> >
> > Andres
> >
> >
>
>

In response to

pgsql-jdbc by date

Next:From: Kevin GrittnerDate: 2005-10-19 21:18:35
Subject: Re: tuning/profiling
Previous:From: Ken GeisDate: 2005-10-19 15:59:43
Subject: binary data transfers

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