parihaaraka writes:
> I have the same issue after pg_upgrade from 9.3 to 9.5.
> pg_dump generates excess commands like
> CREATE OPERATOR FAMILY bit_ops USING gin;
> ...
> while all of this is done during CREATE EXTENSION
This is fixed in the latest round of minor releases, but not in a way th
Hello, All
I have the same issue after pg_upgrade from 9.3 to 9.5.
pg_dump generates excess commands like
CREATE OPERATOR FAMILY bit_ops USING gin;
...
while all of this is done during CREATE EXTENSION
(i have only btree_gin and plpgsql installed)
--
View this message in context:
http://pos
om text[] to hstore
function akeys(hstore)
function avals(hstore)
function defined(hstore,text)
function delete(hstore,hstore)
function delete(hstore,text)
function delete(hstore,text[])
function each(hstore)
function exist(hstore,text)
function exists_all(hstore,text[])
function exists
"Feld, Michael (IMS)" writes:
> Thanks for the reply Tom. template1 is definitely empty and does not contain
> any hstore objects. I did a little debugging and placed the below SQL before
> and after the hstore creation in the file produced by the pg_dump and
> determined that these operator ob
al Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, April 06, 2016 7:01 PM
To: Feld, Michael (IMS)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade error regarding hstore operator
"Feld, Michael (IMS)" writes:
> Thanks for the assist Tom. That wo
"Feld, Michael (IMS)" writes:
> Thanks for the assist Tom. That worked for us. Noticing a different
> issue following the pg_upgrade. If we take a pg_dump of a database on
> this upgraded instance with the hstore extension and try to pg_restore
> it back up to the same instance we get the followin
it did not. Thanks for any help you
can offer.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, March 08, 2016 6:22 PM
To: Feld, Michael (IMS)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_upgrade error regarding hstore operator
"Feld, Michael
"Feld, Michael (IMS)" writes:
> I am attempting to upgrade my organization's database cluster from
> 9.1.19 to 9.5.1 using the pg_upgrade utility.
That's kind of a big jump :-( ... you missed the versions where =>
was deprecated as an operator name.
> I tried dropping the operator before doing t
On 03/08/2016 10:27 AM, Feld, Michael (IMS) wrote:
I am attempting to upgrade my organization's database cluster from 9.1.19 to
9.5.1 using the pg_upgrade utility. After some processing, the tool bails out
with the following error in the log:
pg_restore: creating OPERATOR "public.=>"
pg_restor
