{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Adapter for Envoy
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • 日本語コミュニティ
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • General /
avatar image
0
Question by Wesley Nurse · Dec 13, 2017 at 06:21 PM · 259 Views management serverreinstall

I somehow screwed up postgresql on management server

for private cloud deployment, I initially installed everything fine (I installed without authentication for Cassandra). Everything worked, I was able to log into edge ui, developer portal, etc. All services were running. Then I decided to change the Cassandra password so I executed the command

apigee-service <component> store_cassandra_credentials -f /opt/apigee/config/apigee.cfg for various components.

This is a 5 node cluster. On management server I accidentally ran

apigee-service edge-postgres-server store_cassandra_credentials -f /opt/apigee/config/apigee.cfg (the management server does not have postgres server, only postgresql). Anyway, obviously, this gave an error... now, I cannot get postgresql to start on management server. it keeps saying server is dead. The directory /opt/apigee/data/apigee-postgresql/pgdata does not exist now.

I am thinking of just reinstalling (unless someone can give me a good solution)... I am thinking of just reinstalling the management component and it will reinstall postgresql.

Question. Will this destroy any of my current setup (the organization, virtual hosts, etc) I have already created?.. Will apigee delete or modify the existing property files for management server?.

Does anyone have a solution that does not involve reinstalling management component?

Comment
Add comment
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Close

1 Answer

  • Sort: 
avatar image
0

Answer by Mauro Gonzalez · Dec 28, 2017 at 05:40 AM

Hi,

Postgreql (PG) is not part of the management components, it is part of the analytics pod. Reinstalling management server won't reinstall PG. In a 5-node topology PG is installed with the ps profile which installs Postgres Server (PS) and PG, commonly in node 4 (master) and node 5 (standby).

If you have already another PG running and is the standby you can follow handling-postgressql-database-failover. If there's an issue with PGs then QPIDD has enough memory to save the analytics msgs in the queues while it is fixed. This does not impact runtime traffic.

All your configuration is saved in Zookeepers and Cassandras so there's no problem modifying analytics or management componens.

Regards,

-Mauro

Comment
Add comment · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow this Question

Answers Answers and Comments

35 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

What these errors on the management server logs mean? 1 Answer

How to validate the installation of some apigee Edge Components ? 1 Answer

How are Postgres servers in different data center in SYNC? 2 Answers

Does the management server sometimes deregisters one or more of the MPs on its own? 1 Answer

What is the minimum Hardware requirement for single host architecture 2 Answers

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2021 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Adapter for Envoy
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • 日本語コミュニティ
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Badges