Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxZZq-0008OC-CP for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2015 11:32:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxZZp-0007Aa-Nu for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2015 11:32:49 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YxZZo-0007A3-H7 for pgsql-admin@postgresql.org; Wed, 27 May 2015 11:32:48 +0000 Received: from mout.web.de ([212.227.15.3]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1YxZZk-0007MJ-I7 for pgsql-admin@postgresql.org; Wed, 27 May 2015 11:32:47 +0000 Received: from vm-mailsrv.lan.net ([87.155.110.239]) by smtp.web.de (mrweb004) with ESMTPSA (Nemesis) id 0MFvnC-1Ysblc2gEw-00EubD for ; Wed, 27 May 2015 13:32:42 +0200 Received: from localhost (localhost [127.0.0.1]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 95523F12E for ; Wed, 27 May 2015 13:32:40 +0200 (CEST) X-Spam-Flag: NO X-Spam-Score: -2.899 X-Spam-Level: X-Spam-Status: No, score=-2.899 tagged_above=-99.9 required=6.31 tests=[ALL_TRUSTED=-1, BAYES_00=-1.9, FREEMAIL_FROM=0.001] autolearn=ham autolearn_force=no Received: from vm-mailsrv.lan.net ([127.0.0.1]) by localhost (vm-mailsrv.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5uERwh6q9fMz for ; Wed, 27 May 2015 13:32:38 +0200 (CEST) Received: from neslonek.homeunix.org (vm-webapp-ext.dmz-lan.net [192.168.0.100]) by vm-mailsrv.lan.net (Postfix) with ESMTP id D23F5F12B for ; Wed, 27 May 2015 13:32:37 +0200 (CEST) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Date: Wed, 27 May 2015 13:32:37 +0200 From: Jan Lentfer To: Subject: Re: PostgreSQL Dump based backup using pipe In-Reply-To: References: Message-ID: <36ef17a4ea3cd5cd5bb0020c74c2f688@imap.lan.net> X-Sender: Jan.Lentfer@web.de User-Agent: Roundcube Webmail/0.7.2 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K0:/bew51KqjZRl4JzAGEQCoXMOPgs1j8HsWmaDkQOM2f4oaOxldkM UV8DBvCqZBGosns0Yp7BxO1KD5z3+ve5GW3cXlfEpwiy2cripj6/rE1OQReU7Xk1VJa+tXI AJah3x+nGxxhRYK7G6pCX+pkzzTdV2/SA20cwA44gpqu0/pU7KdGKIspjf0DZuw9eJXoAT0 qEYityoVBnKs1vEb8pvVQ== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Am 2015-05-27 13:19, schrieb girish R G peetle: [...] > 2. On Linux also from strace output of pg_dump -Fc (compressed dump) > used with fifo file, I see illegal seek performed on fifo file too.=C2=A0 > But restore doesnt have any issues. Is =C2=A0it safe to use pg_dump -Fc > with output file as fifo on Linux ? I have used pg_dump -Fc with fifos on both Linux and BSDs for several=20 years without any problem, afair. Jan --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin