[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] How to upgrade postgres 8.4 -> 9.1 contrib?
From:       Benedikt Grundmann <bgrundmann () janestreet ! com>
Date:       2013-05-30 9:37:34
Message-ID: CADbMkNNU4KAUe1WzwvanCWp-q9xgTu3B2RHBeB5Ov_v7zYc++w () mail ! gmail ! com
[Download RAW message or body]

I just realized I never replied.  This basically worked the only thing I
couldn't get to work is to register the hstore binary send and receive
functions with the hstore type.  (As far as I can see there is no alter
type set primitives or similar).  However that doesn't matter for us as we
don't use the binary protocol.

Thanks,

Bene


On Mon, Nov 19, 2012 at 3:27 PM, Benedikt Grundmann <
bgrundmann@janestreet.com> wrote:

> On Mon, Nov 19, 2012 at 3:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Benedikt Grundmann <bgrundmann@janestreet.com> writes:
> >> What is the official guide line?
> >
> > You could try (1) run the 9.0 version of the hstore install script
> > and then (2) do the CREATE EXTENSION FROM UNPACKAGED bit.  I'd
> > strongly recommend testing this procedure in a scratch copy of your
> > installation first, though.
> >
> Thanks Tom.  Due to <complicated-not-relevant-reasons> it might take a
> while for us to do so but if we do try this out I'll let the list know
> if it worked.
>
> Cheers,
>
> Bene
>

[Attachment #3 (text/html)]

<div dir="ltr"><div>I just realized I never replied.  This basically worked the only \
thing I couldn&#39;t get to work is to register the hstore binary send and receive \
functions with the hstore type.  (As far as I can see there is no alter type set \
primitives or similar).  However that doesn&#39;t matter for us as we don&#39;t use \
the binary protocol.<br> <br></div>Thanks,<br><br>Bene<br></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Nov 19, 2012 at 3:27 PM, \
Benedikt Grundmann <span dir="ltr">&lt;<a href="mailto:bgrundmann@janestreet.com" \
target="_blank">bgrundmann@janestreet.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div class="im">On Mon, Nov 19, 2012 at 3:22 PM, Tom Lane \
&lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br>

&gt; Benedikt Grundmann &lt;<a \
href="mailto:bgrundmann@janestreet.com">bgrundmann@janestreet.com</a>&gt; writes:<br> \
&gt;&gt; What is the official guide line?<br> &gt;<br>
&gt; You could try (1) run the 9.0 version of the hstore install script<br>
&gt; and then (2) do the CREATE EXTENSION FROM UNPACKAGED bit.  I&#39;d<br>
&gt; strongly recommend testing this procedure in a scratch copy of your<br>
&gt; installation first, though.<br>
&gt;<br>
</div>Thanks Tom.  Due to &lt;complicated-not-relevant-reasons&gt; it might take \
a<br> while for us to do so but if we do try this out I&#39;ll let the list know<br>
if it worked.<br>
<br>
Cheers,<br>
<br>
Bene<br>
</blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]