Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0501E1336971 for ; Mon, 10 Jan 2011 11:43:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 03526-03 for ; Mon, 10 Jan 2011 15:43:15 +0000 (UTC) X-Greylist: delayed 00:06:39.342704 by SQLgrey-1.7.6 Received: from www1.brickcitywebs.net (www1.brickcitywebs.net [8.8.67.10]) by mail.postgresql.org (Postfix) with ESMTP id DCDAD1337B8D for ; Mon, 10 Jan 2011 11:43:12 -0400 (AST) Received: (qmail 17545 invoked from network); 10 Jan 2011 10:36:32 -0500 Received: from softdnserror (HELO outlook.rad-con.com) (12.49.144.162) by www1.brickcitywebs.net with SMTP; 10 Jan 2011 10:36:31 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CBB0DC.26B35C88" Subject: Do I need to run pgagent_upgrade.sql? If so, when? Date: Mon, 10 Jan 2011 10:36:29 -0500 Message-ID: <04A6DB42D2BA534FAC77B90562A6A03D01700ECD@server.rad-con.local> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Do I need to run pgagent_upgrade.sql? If so, when? thread-index: AcuwygOQJwuXGETtRUq/N1G/OlHGVgAEaRIg From: "Rob Richardson" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201101/48 X-Sequence-Number: 36488 This is a multi-part message in MIME format. ------_=_NextPart_001_01CBB0DC.26B35C88 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Greetings! =20 I am putting together a formal installation package for a customer who is not happy if he doesn't have one, even though he's got primary and backup servers both running as expected. =20 =20 I am writing instructions on how to install PGAgent. The download package for PGAgent includes two SQL files, pgagent.sql and pgagent_upgrade.sql. But the only instructions I found online on how to install PGAgent only mention the first. Is pgagent_upgrade.sql required? If so, when do I run it? I presume that it should be run after pgagent.sql, but without instructions, I'm not positive. =20 Thank you. =20 RobR ------_=_NextPart_001_01CBB0DC.26B35C88 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Greetings!<= /p>

 

I am putting together a formal installation package for a customer who is not happy if he doesn’t = have one, even though he’s got primary and backup servers both running = as expected. 

 

I am writing instructions on how to install PGAgent.  The download package for PGAgent includes two SQL = files, pgagent.sql and pgagent_upgrade.sql.  But the only instructions I = found online on how to install PGAgent only mention the first.  Is = pgagent_upgrade.sql required?  If so, when do I run it?  I presume that it should = be run after pgagent.sql, but without instructions, I’m not = positive.

 

Thank = you.

 

RobR

------_=_NextPart_001_01CBB0DC.26B35C88--