Wednesday, March 16, 2016

Postgresql upgrade issues - Checking for reg* system OID user data types

So I am prepping for an upgrade of postgres from version 9.2 to 9.4. Since this is a major version upgrade, I chose to use pg_upgrade to try and minimize downtime. My first attempt in one of our dev environments went fairly well, up until I actually launched the upgrade process.

My stopwatch was ready, my commands were ready, my server was ready!

Start the stopwatch...
#/etc/init.d/postgresql-9.2  stop#sudo -u postgres /usr/pgsql-9.4/bin/pg_upgrade --old-datadir=/var/lib/pgsql/9.2/data/ --new-datadir=/var/lib/pgsql/9.4/data/ --old-bindir=/usr/pgsql-9.2/bin/ --new-bindir=/usr/pgsql-9.4/bin/


HERE WE GO!

Performing Consistency Checks
-----------------------------
Checking cluster versions                                   ok
Checking database user is a superuser                       ok
Checking database connection settings                       ok
Checking for prepared transactions                          ok
Checking for reg* system OID user data types                fatal

NOOOOOO!!!!




Quick.....
#/etc/init.d/postgresql-9.2 start

Thank goodness that was only dev... So what now?? Running cat of tables_using_reg.txt, showed me that there were several tables affected:

  public.pg_ts_dict.dict_init
  public.pg_ts_dict.dict_lexize
  public.pg_ts_parser.prs_start
  public.pg_ts_parser.prs_nexttoken
  public.pg_ts_parser.prs_end
  public.pg_ts_parser.prs_headline
  public.pg_ts_parser.prs_lextype

The good news is, it looks like these are remnants of the old pgsql 8.x days when tsearch2 was not part of the distribution.

My solution? Drop pg_ts_dict & pg_ts_parser. Once upgraded, I'll test everything, as long as there are not any issues, we are good to go. Worst case scenario, I can dump those two tables (5 rows total between them) and run an import post upgrade.

21 comments:

  1. The term which offers a nearby relationship with information science is Machine learning. ExcelR Data Science Courses

    ReplyDelete
  2. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  3. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  4. A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.
    360digitmg

    ReplyDelete
  5. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete
  6. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm

    Logistic Regression explained

    ReplyDelete
  7. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  8. Honestly speaking this blog is absolutely amazing in learning the subject that is building up the knowledge of every individual and enlarging to develop the skills which can be applied in to practical one. Finally, thanking the blogger to launch more further too.

    data science course in bangalore with placement

    ReplyDelete
  9. How long does a Yorkie live? 13 – 16 years

    Are Yorkies cuddlers?
    A lover of all things comfortable, the Yorkshire terrier enjoys cuddling with loved ones and snuggling into everything soft and fluffy. And for you, their silky coat isn't too bad for petting. https://www.newdaypuppies.com/

    Adorable Teacup and Toy AKC Yorkie Puppies
    We have adorable Yorkshire Terrier puppies male and female (she is pictured with the bow).The little girl was born on and the male was born on. teacup yorkie for sale Both puppies have started potty training and have had all sets of puppy shots and deworming. They both come with AKC papers.The girl is very petite and has an adorable baby doll face. yorkies for sale near me She is a teacup and will mature to be around just lbs. She is very gentle and easy going She is the princess in our home and loves to be held.The male is full of spunk and is super playful He will mature to be lbs and would make an awesome family dog. He has a gorgeous silky coat and adorable teddy bear face.Both puppies are AKC registered and will come with a health guarantee shot record and sample puppy food. https://www.newdaypuppies.com/teacup-yorkie-puppies-for-sale/

    Adorable Teacup and Toy AKC Yorkie Puppies is a Female, Male Yorkshire Terrier Puppy for sale in US. Adorable Teacup and Toy AKC Yorkie Puppies by newdaypuppies for Female, Male Yorkshire Terrier Puppies. yorkie puppies for sale

    ReplyDelete

  10. Is a Yorkie a good family dog?

    Yorkies, like many other Toy breeds, make good pets for people; they're especially good for senior citizens, people with medical issues, and those who may worry about the size and strength of a larger dog. ... They're loving, devoted, and very affectionate: This makes them great personal companions and good family pets.

    Do Yorkshire terriers bark a lot?
    https://www.newdaypuppies.com/teacup-yorkie-puppies-for-sale/
    Yorkshire Terriers are little dogs with huge personalities. teacup yorkies for sale With those huge personalities come a fierce territorial bark. Any time your phone rings, someone speaks or knocks on your door, or your doorbell chimes, your Yorkshire Terrier will likely bark. Outside noises aren't even required for barking for some Yorkies. yorkshire terriers for sale

    How much do Yorkshire terriers cost?
    yorkie for sale near me
    Typical Yorkie prices range from $1,500 to $3,000, but the cost can fall far below or above that range. Prices will vary based on the puppy's lineage, appearance, health, and the breeder. It's also possible to adopt an older Yorkie for significantly less through a rescue shelter. yorkie for sale

    ReplyDelete
  11. Are Yorkies high maintenance?
    https://www.newdaypuppies.com/teacup-yorkie-puppies-for-sale/
    The spunky Yorkshire Terrier has a lot going for him, but his beautiful coat is high-maintenance, even if clipped short. yorkie puppy for sale near me A Yorkie with a long coat requires daily brushing and weekly baths. ... Yorkies for sale near me don't shed much compared with some other dogs, but they aren't hypoallergenic.

    Are Yorkies hard to train?
    Are Yorkies easy to train? yorkie poo for sale are not the easiest breed to train. It's not because they aren't smart; they are quite an intelligent breed. But they tend to be confident, curious, and a bit stubborn—all of which can make training more difficult.

    Are Yorkies smart?
    So, are Yorkies smart? Yorkshire Terriers are highly intelligent dogs. According to canine psychologist Stanley Coren, are “above average” intelligent dogs. yorkies puppy for sale In fact, they're ranked the 34th smartest dog breed out of 138 qualifying breeds.

    ReplyDelete
  12. Do Yorkie Poos get along with cats?
    yorkies for sale
    While most Yorkies do great with cats, there are always going to be some instances where it just does not work out. Of course, it is best if you go plan for this rare but possible circumstances in which the only answer is, unfortunately, to keep them separate at all times or to find a new home for one of them. yorkie puppy for sale near me

    Do Yorkshire terriers bark a lot?
    Yorkshire Terriers are little dogs with huge personalities. With those huge personalities come a fierce territorial bark. Any time your phone rings, someone speaks or knocks on your door, or your doorbell chimes, your Yorkshire Terrier will likely bark. Outside noises aren't even required for barking for some Yorkies. yorkie for sale near me

    Are Yorkies hard to train?
    Are Yorkies easy to train? Yorkies are not the easiest breed to train. yorkie poo for sale It's not because they aren't smart; they are quite an intelligent breed. But they tend to be confident, curious, and a bit stubborn—all of which can make training more difficult. yorkie for sale

    ReplyDelete
  13. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data scientist course in warangal

    ReplyDelete
  14. I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
    business analytics course in hyderabad

    ReplyDelete
  15. I have bookmarked your site since this site contains significant data in it. You rock for keeping incredible stuff. I am very appreciative of this site.
    data analytics course in hyderabad

    ReplyDelete
  16. I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place data analytics course in kanpur

    ReplyDelete
  17. Betting spreads and totals isn’t enough for most individuals anymore. The payouts will range primarily based on what number of} bets you embrace, and the prices of those bets. If you wager $11 to win $10 and the Colts win by 14, you’d win $10. The spread is -8, so to win your wager, you need Indy to win by 9+ factors. The over/under idea is utilized to many various kinds of bets. Bettors can then wager on whether or not the sport will go over or beneath 빅카지노 the entire.

    ReplyDelete