Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aVmhm-0004pT-QK for pgsql-admin@arkaria.postgresql.org; Tue, 16 Feb 2016 20:58:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aVmhm-0005MV-D7 for pgsql-admin@arkaria.postgresql.org; Tue, 16 Feb 2016 20:58:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aVmg6-0003VX-Ul for pgsql-admin@postgresql.org; Tue, 16 Feb 2016 20:56:58 +0000 Received: from smtp05.smtpout.orange.fr ([80.12.242.127] helo=smtp.smtpout.orange.fr) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aVmg1-000748-B9 for pgsql-admin@postgresql.org; Tue, 16 Feb 2016 20:56:55 +0000 Received: from [192.168.1.32] ([92.136.100.235]) by mwinf5d52 with ME id K8wn1s00854jVX8038woGb; Tue, 16 Feb 2016 21:56:50 +0100 X-ME-Helo: [192.168.1.32] X-ME-Auth: cGllcnJlLm1hcmllLmNoZXZhbGllckB3YW5hZG9vLmZy X-ME-Date: Tue, 16 Feb 2016 21:56:50 +0100 X-ME-IP: 92.136.100.235 Subject: Re: pg_dump fatal error To: pgsql-admin@postgresql.org, "drum.lucas@gmail.com" References: <56BCE798.1040008@free.fr> <56BDA108.4040203@free.fr> From: =?UTF-8?Q?Pierre_Chevalier_G=c3=a9ologue?= Message-ID: <56C38D0F.2060406@free.fr> Date: Tue, 16 Feb 2016 21:56:47 +0100 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101 Icedove/38.5.0 MIME-Version: 1.0 In-Reply-To: <56BDA108.4040203@free.fr> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -0.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 (still trying to get this thread back on the list... sorry for delay: I just ignore list messages arriving in my main Inbox...) Le 14/02/2016 09:04, drum.lucas@gmail.com a écrit : > > Thanks Pierre. > > I'm running the PG_DUMP in the local machine and then I'll copy through > the network... > It's still copying, but once it's done and all the process has been > successful I'll let u guys know. Normally, the pg_dump -s concerning just the structure should be very fast to run, as well as its restoration. The other one, the pg_dump -a, should generate a *much* greater output file, and should be *much* longer to restore. So it would be better if you begin to start with the structure: if any error is present at this stage, it may be faster (if not easier) to track it properly. À+ Pierre -- ____________________________________________________________________________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran 32100 Condom Tél+fax : 09 75 27 45 62 06 37 80 33 64 Émail : pierrechevaliergeolCHEZfree.fr icq# : 10432285 jabber: pierre.chevalier1967@jabber.fr http://pierremariechevalier.free.fr/pierre_chevalier_geologue ____________________________________________________________________________ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin