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.

29 comments:

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

    ReplyDelete
    Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Project Centers in Chennai

      Delete
  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. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Correlation vs Covariance

    ReplyDelete
  4. 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 inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  5. 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
  6. 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
  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

    ReplyDelete
  8. 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
  9. 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
  10. 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
  11. 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

  12. 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
  13. 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
  14. Do Yorkshire Terriers bite?
    Puppies bite beginning at a very young age. They learn this behavior while still with their littermates, long before you bring your Yorkie puppy into your home. yorkshire puppies for sale If the biting can be corrected while a Yorkie is still a puppy, training works best. ... This will be very similar to when a puppy yelps in pain. teacup chihuahuas for sale

    What are Teacup Yorkies?
    Teacup Yorkie is a smaller version of the same pure breed Yorkie, also known as Toy Yorkie or Micro Yorkshire Terrier. It's a tiny dog breed at about 5 to 7 inches tall, weighing between 2 to 4 pounds. The average lifespan of the Teacup Yorkie is around 12 years. yorkie terrier for sale

    Why do they cut Yorkies tails off?
    https://www.newdaypuppies.com/teacup-yorkie-puppies-for-sale/
    The main reason that Yorkie tails are docked are for aesthetic purposes. The natural tail is long and sticks up beyond the height of the head. A docked Yorkie has a tail that sticks straight up below the level of the head, which creates clean lines when the hair is worn at show length. yorkies puppy for sale


    ReplyDelete
  15. Are Yorkies good for first time dog owners?
    yorkshire terrier for sale
    The Yorkshire terrier is a great starter dog for those who want a little lap dog. This breed is affectionate towards its owner and may even act protective around strangers. teacup yorkie puppies for sale The Yorkie has a moderate energy level and only needs basic exercise.

    Are Yorkie Poo good for first time owners?
    tea cup yorkie puppy for sale
    It is the ideal pet for people who don't want to deal with pet fur at home or in their cars. This is the ideal pet for first time dog owners, since it trains easily and needs only moderate grooming maintenance. Yorkie poos are good with kids. It will play with them, is energetic and affectionate.

    Are Yorkie hypoallergenic? Yes
    yorkshire terrier for sale near me
    How much does a Yorkie Poo puppy cost?
    Yorkie Poo puppies range in price from $1,000 to $3,500, depending on the puppy's coloring and the breeder.

    Are Yorkie Poos good dogs?
    yorkie terrier puppy for sale near me
    The Yorkipoo is a gentle and loving dog who can do well with children. He's not recommended for homes with very young children, since he can be easily injured when improperly handled. A Yorkipoo can make an excellent companion for an older, more considerate child.

    ReplyDelete
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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