From: Pierre Chevalier Géologue <pierrechevaliergeol@free.fr>
To: pgsql-admin@postgresql.org, "drum.lucas@gmail.com" <drum.lucas@gmail.com>
Subject: Re: pg_dump fatal error
Date: Tue, 16 Feb 2016 21:56:47 +0100
Message-ID: <56C38D0F.2060406@free.fr> (raw)
In-Reply-To: <56BDA108.4040203@free.fr>
References: <CAE_gQfXD622Uv0o2N5fmbBTbEDH7=-0TWeRwYjXEUQXJo7bs_Q@mail.gmail.com>
<56BCE798.1040008@free.fr>
<56BDA108.4040203@free.fr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
(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
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pierrechevaliergeol@free.fr, drum.lucas@gmail.com
Subject: Re: pg_dump fatal error
In-Reply-To: <56C38D0F.2060406@free.fr>
* 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