pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?
> 



view thread (10+ messages)  latest in thread

Message-ID: <43D5091C.9010608@bitsp.com>
Permalink:  ../43D5091C.9010608@bitsp.com/
Also on:    postgresql.org/message-id/43D5091C.9010608@bitsp.com

 · 

reply

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