Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIevN-00080y-J3 for pgsql-admin@arkaria.postgresql.org; Wed, 26 Feb 2014 13:53:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WIevM-0003wc-Sv for pgsql-admin@arkaria.postgresql.org; Wed, 26 Feb 2014 13:53:24 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIevK-0003wT-8k for pgsql-admin@postgresql.org; Wed, 26 Feb 2014 13:53:22 +0000 Received: from mailfilter.invera.com ([198.168.207.50]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIevB-0005KW-3p for pgsql-admin@postgresql.org; Wed, 26 Feb 2014 13:53:21 +0000 Received: from epgate.invera.com (localhost.localdomain [127.0.0.1]) by epgate.invera.com (Postfix-out) with ESMTP id A3D283C60F4; Wed, 26 Feb 2014 08:53:12 -0500 (EST) X-Propel-Return-Path: Received: from mailfilter.invera.com ([172.20.200.19]) by [127.0.0.1] ([127.0.0.1]) (port 7027) (Abaca EPG outproxy filter 3.1.1.9369 $Rev: 9262 $) id rfTOre2qdRc0; Wed, 26 Feb 2014 08:53:12 -0500 Received: from exch1.invera.com (exch1.invera.com [172.20.100.3]) by epgate.invera.com (Postfix-out) with ESMTP id 797373C60F0; Wed, 26 Feb 2014 08:53:12 -0500 (EST) Received: from EXCH1.invera.com (172.20.100.3) by exch1.invera.com (172.20.100.3) with Microsoft SMTP Server (TLS) id 15.0.775.38; Wed, 26 Feb 2014 08:53:11 -0500 Received: from EXCH1.invera.com ([fe80::c06f:c347:dd1c:5c92]) by exch1.invera.com ([fe80::c06f:c347:dd1c:5c92%16]) with mapi id 15.00.0775.031; Wed, 26 Feb 2014 08:53:11 -0500 From: Alanoly Andrews To: 'desmodemone' CC: "pgsql-admin@postgresql.org" Subject: Re: Database upgrade from 8.4.7 to 9.1.4 Thread-Topic: [ADMIN] Database upgrade from 8.4.7 to 9.1.4 Thread-Index: AQHPMmVlEwLutVDKYEmOd3MV3EY5SZrGzeqAgADAhoA= Date: Wed, 26 Feb 2014 13:53:10 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.20.35.89] Content-Type: multipart/alternative; boundary="_000_a4de6f7c232c4ea78644756663adb6a0exch1inveracom_" MIME-Version: 1.0 X-Propel-ID: rfTOre2qdRc0 X-Pg-Spam-Score: 0.8 (/) 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 --_000_a4de6f7c232c4ea78644756663adb6a0exch1inveracom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi=20Des, I=20did=20not=20use=20any=20options=20with=20the=20"pg_dumpall"=20command.= =20Just=20"pg_dumpall=20>=20outputfile",=20as=20given=20in=20the=20Postgres= =20Manual=20on=20upgrades.=20I=20guess=20the=20default=20option=20is=20the= =20"copy"=20mode,=20not=20"inserts". Alanoly. From:=20desmodemone=20[mailto:desmodemone@gmail.com] Sent:=20Tuesday,=20February=2025,=202014=204:21=20PM To:=20Alanoly=20Andrews Cc:=20pgsql-admin@postgresql.org Subject:=20Re:=20[ADMIN]=20Database=20upgrade=20from=208.4.7=20to=209.1.4 Hello=20Alanoly=20, =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20= =20=20which=20option=20you=20use=20to=20do=20the=20pg_dumpall=20?=20did=20y= ou=20use=20insert=20mode=20or=20copy=20mode? Have=20a=20nice=20day **************************************************** This=20e-mail=20may=20be=20privileged=20and/or=20confidential,=20and=20the= =20sender=20does=20not=20waive=20any=20related=20rights=20and=20obligations= .=20Any=20distribution,=20use=20or=20copying=20of=20this=20e-mail=20or=20th= e=20information=20it=20contains=20by=20other=20than=20an=20intended=20recip= ient=20is=20unauthorized.=20If=20you=20received=20this=20e-mail=20in=20erro= r,=20please=20advise=20me=20(by=20return=20e-mail=20or=20otherwise)=20immed= iately. =20 Ce=20courriel=20est=20confidentiel=20et=20prot=E9g=E9.=20L'exp=E9diteur=20n= e=20renonce=20pas=20aux=20droits=20et=20obligations=20qui=20s'y=20rapporten= t=2E=20Toute=20diffusion,=20utilisation=20ou=20copie=20de=20ce=20message=20= ou=20des=20renseignements=20qu'il=20contient=20par=20une=20personne=20autre= =20que=20le=20(les)=20destinataire(s)=20d=E9sign=E9(s)=20est=20interdite.= =20Si=20vous=20recevez=20ce=20courriel=20par=20erreur,=20veuillez=20m'en=20= aviser=20imm=E9diatement,=20par=20retour=20de=20courriel=20ou=20par=20un=20= autre=20moyen. **************************************************** --_000_a4de6f7c232c4ea78644756663adb6a0exch1inveracom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 1024x768 Hi =20Des,

 

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

 

Alanoly.

 

From: desmodemone=20[mailto:desmodemone@gmail.com= ]
Sent:=20Tuesday,=20February=2025,=202014=204:= 21=20PM
To:=20Alanoly=20Andrews
Cc:=20pgsql-admin@postgres= ql.org
Subject:=20Re:=20[ADMIN]= =20Database=20upgrade=20from=208.4.7=20to=209.1.4<= /p>
&n= bsp;

= Hello Alanoly=20,

 &= nbsp;           &nbs= p;             which=20option=20you=20use=20to=20do=20the= =20pg_dumpall=20? did=20you=20use=20insert=20mode=20or=20copy= =20mode?

= Have=20a=20nice=20day<= /font>

&n= bsp;


This=20e-mail=20may=20be=20privileged=20and/or=20confidential,=20and=20the= =20sender=20does=20not=20waive=20any=20related=20rights=20and=20obligations= .=20Any=20distribution,=20use=20or=20copying=20of=20this=20e-mail=20or=20th= e=20information=20it=20contains=20by=20other=20than=20an=20intended=20recip= ient=20is=20unauthorized.=20If=20you=20received=20this=20e-mail=20in=20erro= r,=20please=20advise=20me=20(by=20return=20e-mail=20or=20otherwise)=20immed= iately.

=20 Ce=20courriel=20est=20confidentiel=20et=20prot=E9g=E9.=20L'exp=E9diteur=20n= e=20renonce=20pas=20aux=20droits=20et=20obligations=20qui=20s'y=20rapporten= t=2E=20Toute=20diffusion,=20utilisation=20ou=20copie=20de=20ce=20message=20= ou=20des=20renseignements=20qu'il=20contient=20par=20une=20personne=20autre= =20que=20le=20(les)=20destinataire(s)=20d=E9sign=E9(s)=20est=20interdite.= =20Si=20vous=20recevez=20ce=20courriel=20par=20erreur,=20veuillez=20m'en=20= aviser=20imm=E9diatement,=20par=20retour=20de=20courriel=20ou=20par=20un=20= autre=20moyen.

Mail=20sent=20via=20the=20Abaca= =20EPG

--_000_a4de6f7c232c4ea78644756663adb6a0exch1inveracom_--