X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EE3DF11F6704 for ; Wed, 26 Apr 2006 17:39:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07672-04 for ; Wed, 26 Apr 2006 17:39:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.202]) by postgresql.org (Postfix) with ESMTP id 1280111F60E8 for ; Wed, 26 Apr 2006 17:39:30 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id h31so1100954wxd for ; Wed, 26 Apr 2006 13:39:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IOSDiKziHm8zKS1XQcQgqBz8PGURDl2pzs4xsT1YUMHj809Rvc9CG9tTmOXF97ie1iprq3HUinl6B2Ty3CDa14A6GWgzvcUUl4O32xCn3CKuoE49iGQfWtBxjIAdjvNh8ZDwZpTDChsvyi/kE3iDBP163Lj5OcKE0Ih64HukCpM= Received: by 10.70.44.11 with SMTP id r11mr398060wxr; Wed, 26 Apr 2006 13:39:30 -0700 (PDT) Received: by 10.70.83.7 with HTTP; Wed, 26 Apr 2006 13:39:30 -0700 (PDT) Message-ID: <1d219a6f0604261339w1b32a84cw4c4c26f4f3411335@mail.gmail.com> Date: Wed, 26 Apr 2006 16:39:30 -0400 From: "Chris Hoover" To: "Uwe Maiwald" Subject: Re: waring from pg_restore Cc: pgsql-admin@postgresql.org In-Reply-To: <6.2.1.2.1.20060425221801.021a6cc8@mx0.kiss-net.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17175_6474682.1146083970732" References: <6.2.1.2.1.20060425221801.021a6cc8@mx0.kiss-net.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/285 X-Sequence-Number: 21454 ------=_Part_17175_6474682.1146083970732 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline you should use the PG 8.1 pg_dump to dump the 7.4.3 database and then impor= t it into the new server. It is not recommended to do it the way you have done it. On 4/25/06, Uwe Maiwald wrote: > > Hi, > > i get the following warning from pg_restore and would like to know if i > can > safely ignore it, or some action should be taken. > > pg_restore: creating FUNC PROCEDURAL LANGUAGE plpgsql_call_handler() > pg_restore: [archiver] WARNING: don't know how to set owner for object > type > FUNC PROCEDURAL LANGUAGE > pg_restore: creating PROCEDURAL LANGUAGE plpgsql > > i did the following to produce the warning on linux > > From postgresql 7.4.3: pg_dump =96Ft =96d =96b databasename > filename > In postgresql 8.1.3: pg_restore =96Ft =96v =96d databasename filename > > Any ideas why this happens? > > Thanks, Uwe > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > ------=_Part_17175_6474682.1146083970732 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline you should use the PG 8.1 pg_dump to dump the 7.4.3 database and then impor= t it into the new server.  It is not recommended to do it the way you = have done it.

On 4/25/06, Uwe Maiwald <u.maiwald@kiss= -net.de> wrote:
Hi,

i get the following warning from pg_restore and would like to kn= ow if i can
safely ignore it, or some action should be taken.

pg_= restore: creating FUNC PROCEDURAL LANGUAGE plpgsql_call_handler()
pg_res= tore: [archiver] WARNING: don't know how to set owner for object type
FUNC PROCEDURAL LANGUAGE
pg_restore: creating PROCEDURAL LANGUAGE pl= pgsql

i did the following to produce the warning on linux

Fr= om postgresql 7.4.3:  pg_dump =96Ft =96d =96b databasename > f= ilename
In postgresql=20 8.1.3:     pg_restore =96Ft =96v =96d databasename file= name

Any ideas why this happens?

Thanks, Uwe


-----= ----------------------(end of broadcast)---------------------------
TIP = 4: Have you searched our list archives?

           &= nbsp;   http://archive= s.postgresql.org

------=_Part_17175_6474682.1146083970732--