From: Ciprian Hodorogea <ciprian.hodorogea@bitsp.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump - txt sql vs binary
Date: Mon, 23 Jan 2006 18:49:32 +0200
Message-ID: <43D5091C.9010608@bitsp.com> (raw)
In-Reply-To: <20060123155729.GA23544@winnie.fuhr.org>
References: <20060122204132.9567D14DB13@mail07.powweb.com>
<22930.1137973880@sss.pgh.pa.us>
<43D4E9A8.8050005@bitsp.com>
<20060123155729.GA23544@winnie.fuhr.org>
Command I have used:
pg_dump.exe -i -h localhost -p 5432 -U postgres -F p -v -f "C:\test.sql"
bicms_server
This will put in the output SQL file postgres functions also (not only
those defined by me), for example:
CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
AS '$libdir/plpgsql', 'plpgsql_call_handler'
LANGUAGE c;
CREATE TYPE tablefunc_crosstab_2 AS (
row_name text,
category_1 text,
category_2 text
);
CREATE FUNCTION connectby(text, text, text, text, integer, text) RETURNS
SETOF record
AS '$libdir/tablefunc', 'connectby_text'
LANGUAGE c STABLE STRICT;
ALTER FUNCTION public.connectby(text, text, text, text, integer, text)
OWNER TO postgres;
...and many others.
Anyway, my question would be: if I have postgres 8.1.x installed on
computer A and the same version of postgres installed on computer B,
which would be your recommended way of backing up data on computer A and
put it on computer B?
Regards, Ciprian
Michael Fuhr wrote:
> On Mon, Jan 23, 2006 at 04:35:20PM +0200, Ciprian Hodorogea wrote:
>
>>>>2. All dumps generated with pg_dump seem to contain internal functions
>>>>also, which then raise problems when trying to import. Can these be
>>>>somehow excluded from the generated SQL backup?
>>
>>Is there a way to differentiate postgres internal functions from
>>user-defined functions? (other but making up a list of those functions
>>names)
>
>
> What "internal" functions are you talking about? What's the exact
> command you're running and what's the exact error message or
> unexpected behavior you're seeing?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ciprian.hodorogea@bitsp.com, mike@fuhr.org, tgl@sss.pgh.pa.us
Subject: Re: pg_dump - txt sql vs binary
In-Reply-To: <43D5091C.9010608@bitsp.com>
References: <20060122204132.9567D14DB13@mail07.powweb.com> <22930.1137973880@sss.pgh.pa.us> <43D4E9A8.8050005@bitsp.com> <20060123155729.GA23544@winnie.fuhr.org> <43D5091C.9010608@bitsp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox