Re: Database upgrade from 8.4.7 to 9.1.4

From: Alanoly Andrews <alanolya(at)invera(dot)com>
To: 'desmodemone' <desmodemone(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database upgrade from 8.4.7 to 9.1.4
Date: 2014-02-26 13:53:10
Message-ID: a4de6f7c232c4ea78644756663adb6a0@exch1.invera.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Des,

I did not use any options with the "pg_dumpall" command. Just "pg_dumpall > outputfile", as given in the Postgres Manual on upgrades. I guess the default option is the "copy" mode, not "inserts".

Alanoly.

From: desmodemone [mailto:desmodemone(at)gmail(dot)com]
Sent: Tuesday, February 25, 2014 4:21 PM
To: Alanoly Andrews
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Database upgrade from 8.4.7 to 9.1.4

Hello Alanoly ,
which option you use to do the pg_dumpall ? did you use insert mode or copy mode?

Have a nice day

****************************************************
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et protg. L'expditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) dsign(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immdiatement, par retour de courriel ou par un autre moyen.
****************************************************

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2014-02-26 13:55:49 Re: PITR
Previous Message Ian Lawrence Barwick 2014-02-26 11:41:06 Re: Please Help Me...