Re: FW: Getting information about sequences - Mailing list pgsql-general

From Tom Lane
Subject Re: FW: Getting information about sequences
Date
Msg-id 12028.1147789296@sss.pgh.pa.us
Whole thread Raw
In response to FW: Getting information about sequences  ("Forums @ Existanze" <forums@existanze.com>)
Responses Re: FW: Getting information about sequences
List pgsql-general
"Forums @ Existanze" <forums@existanze.com> writes:
> We are creating a jdbc backup solution that does NOT require the pgdump
> program.

In heaven's name, WHY?

Do you have any idea how much future pain you are setting yourself up
for?  pg_dump changes with every PG release to deal with new features
and changes in the system catalogs.  Read the CVS logs for pg_dump for
the past few years, then ask yourself if you really want to buy into a
comparable amount of ongoing maintenance effort.

You'd be way better off just invoking pg_dump as a subprocess.  If there
are specific features you need that pg_dump doesn't have (eg, dumping
just selected tables) consider helping to add them.

            regards, tom lane

pgsql-general by date:

Previous
From: "Rafael Martinez, Guerrero"
Date:
Subject: Weird ..... (a=1 or a=2) <> (a=2 or a=1)
Next
From: "Forums @ Existanze"
Date:
Subject: Re: FW: Getting information about sequences