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

Re: Database conversion

From: brad <brad(at)kieser(dot)net>
To: Max Pyziur <pyz(at)panix(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database conversion
Date: 2000-04-16 20:40:08
Message-ID: 38FA2528.5238E28B@kieser.net (view raw or flat)
Thread:
Lists: pgsql-admin
I have had problems with the pg_dump command, though, when the tables have
been wide (many columns with long text items in them) and deep (many rows).

The pg_dump utility reloads the data from the stdin, using a pipe.
This doesn't work too well (i.e. no data gets loaded) for these tables, but
is fine for smaller tables.

I use linux - nearly every release of kernel 2.0 and 2.2.


Max Pyziur wrote:

> Steve Murphy wrote:
> >
> > Hi,
> >
> > Does anyone know of any conversion programs that will either convert an
> > MS Access database file to a Postresql database or from a Filemaker Pro
> > database file to a Postresql database for the Red Hat Linux OS?
> >
> > Any help or educated guesses of where to start looking would be
> > extremely welcome.
>
> Apologies that this reply is coming possibly a bit late.
>
> My experience is essentially limited to Postgres, Informix, and
> Foxpro, the last in which I haven't done any development in a while.
>
> General procedure that I know of is:
> 1 - dump the schema of one to a file and tweak it so that it conforms
> to the standards of the target database server
> 2 - dump the data to a pipe-delimited text file
> 3 - use the schema from the source database program to create a
> database in the target database program/server
> 4 - import the pipe-delimited data.
>
> In the case of Informix and Postgres, both have utilities (dbschema
> and pg_dump with the -s flag, respectively) which allow you to output
> a databases schema to stdout or a file.  I know that with Foxpro 3.0
> there was some sort of schema utility included somewhere.  Informix
> has an SQL command called UNLOAD which allows you to dump data to
> pipe-delimited formats; pg_dump -a dumps the data in postgres; COPY in
> the postgres monitor gives you a little more control as to the format
> of data dump.  Informix's syntax is a cleaner implementation in this
> regard, though.  Postgres's pg_dump is great, though, for backing up a
> whole database w/ schema and restoring it.
>
> So I only gave you half an answer since I didn't address your MS
> Access or Filemaker pro issues.  I suspect though you can do exports
> and control the format in some way.
>
> > Thanx, Steve.
>
> --
> Max Pyziur                                     BRAMA - Gateway Ukraine
> pyz(at)brama(dot)com                                  http://www.brama.com/


In response to

Responses

pgsql-admin by date

Next:From: Chris CarbaughDate: 2000-04-16 22:35:48
Subject: Re: Database conversion
Previous:From: Max PyziurDate: 2000-04-16 20:02:36
Subject: Re: Database conversion

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