Home Database Mysql Tutorial greenplum激活standby和恢复master原有角色

greenplum激活standby和恢复master原有角色

Jun 07, 2016 pm 03:22 PM
greenplum master standby recover activation

定义:server1=(master) server2=(standby) Active standby server when master down. gpactivatestandby -d /data/master/gpseg-1 -f (on server2) Change server1 as standby . gpinitstandby -s server1 (on server2) gpactivatestandby -d /data/master/g

定义:server1=(master) server2=(standby)
    Active standby server when master down.
    gpactivatestandby -d /data/master/gpseg-1 -f (on server2)
  1. Change server1 as standby .
    gpinitstandby -s server1 (on server2)
    gpactivatestandby -d /data/master/gpseg-1 -f (on server1)
  2. restore server1 as master
    gpstop -m (on server2)
    gpactivatestandby -d /data/master/gpseg-1 -f (on server1)
  3. restore server2 as standby
    gpinitstandby -s server2 (on server1)


    MARK: pay attention to store or remove /data/master/gpseg-1 when do gpactivatestandby operation.
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to recover expired WeChat files? Can expired WeChat files be recovered? How to recover expired WeChat files? Can expired WeChat files be recovered? Feb 22, 2024 pm 02:46 PM

Open WeChat, select Settings in Me, select General and then select Storage Space, select Management in Storage Space, select the conversation in which you want to restore files and select the exclamation mark icon. Tutorial Applicable Model: iPhone13 System: iOS15.3 Version: WeChat 8.0.24 Analysis 1 First open WeChat and click the Settings option on the My page. 2 Then find and click General Options on the settings page. 3Then click Storage Space on the general page. 4 Next, click Manage on the storage space page. 5Finally, select the conversation in which you want to recover files and click the exclamation mark icon on the right. Supplement: WeChat files generally expire in a few days. If the file received by WeChat has not been clicked, the WeChat system will clear it after 72 hours. If the WeChat file has been viewed,

How to turn off the office activation wizard? (How to turn off the Office Activation Wizard prompt) How to turn off the office activation wizard? (How to turn off the Office Activation Wizard prompt) Mar 14, 2024 pm 07:00 PM

In the process of computer work, office software is often used, but as soon as office is opened, a window prompt of the activation wizard appears. How to close it? Is there any way to completely turn off the activation wizard prompt? In fact, the operation is very simple, you can follow the editor's method. 1. Use the Windows key + R key combination to close the Excel Activation Wizard 1. First, use the Windows key + R shortcut key to open the run window; 2. Enter "excel/regserver" in the run window, and then press the Enter key; 3. Wait for a moment, and you will see a black box appear with the message "Registration Successful" displayed.

How to recover browsing history in incognito mode How to recover browsing history in incognito mode Feb 19, 2024 pm 04:22 PM

Private browsing is a very convenient way to browse and protect your privacy when surfing the Internet on your computer or mobile device. Private browsing mode usually prevents the browser from recording your visit history, saving cookies and cache files, and preventing the website you are browsing from leaving any traces in the browser. However, for some special cases, we may need to restore the browsing history of Incognito Browsing. First of all, we need to make it clear: the purpose of private browsing mode is to protect privacy and prevent others from obtaining the user’s online history from the browser. Therefore, incognito browsing

How to restore chat spark on TikTok How to restore chat spark on TikTok Mar 16, 2024 pm 01:25 PM

On Douyin, a short video platform full of creativity and vitality, we can not only enjoy a variety of exciting content, but also have in-depth communications with like-minded friends. Among them, chat sparks are an important indicator of the intensity of interaction between the two parties, and they often inadvertently ignite the emotional bonds between us and our friends. However, sometimes due to some reasons, the chat spark may be disconnected. So what should we do if we want to restore the chat spark? This tutorial guide will bring you a detailed introduction to the content strategy, hoping to help everyone. How to restore the spark of Douyin chat? 1. Open the Douyin message page and select a friend to chat. 2. Send messages and chat to each other. 3. If you send messages continuously for 3 days, you can get the spark logo. On a 3-day basis, send pictures or videos to each other

How to activate cad2020-cad2020 activation tutorial How to activate cad2020-cad2020 activation tutorial Mar 04, 2024 pm 06:00 PM

Many friends still don’t know how to activate cad2020, so the editor below explains the activation tutorial of cad2020. Friends in need should take a look at it. I believe it will be helpful to everyone. 1. Double-click the [CAD2020 icon] on the desktop to pop up the transplant custom settings. Click the [tick] icon. 2. You can click [Yes] or [No]. 3. When [AutoCAD-DWG Association] pops up, click the first one. 4. Select [Single User] and click [Enter Serial Number]. 5. Click [I agree]. 6. Click [Activate]. 7. Serial number: [666-69696969], enter product key: [001L1], click [Next]. 8. Check I have Aut

How to restore Xiaomi Cloud photo album to local How to restore Xiaomi Cloud photo album to local Feb 24, 2024 pm 03:28 PM

How to restore Xiaomi Cloud Photo Album to local? You can restore Xiaomi Cloud Photo Album to local in Xiaomi Cloud Photo Album APP, but most friends don’t know how to restore Xiaomi Cloud Photo Album to local. The next step is to restore Xiaomi Cloud Photo Album to local. Local method graphic tutorials, interested users come and take a look! How to restore Xiaomi cloud photo album to local 1. First open the settings function in Xiaomi phone and select [Personal Avatar] on the main interface; 2. Then enter the Xiaomi account interface and click the [Cloud Service] function; 3. Then jump to Xiaomi For the function of cloud service, select [Cloud Backup]; 4. Finally, in the interface as shown below, click [Cloud Album] to restore the album to local.

Activating PyCharm Professional Edition in one minute Activating PyCharm Professional Edition in one minute Feb 22, 2024 pm 05:27 PM

Since activating PyCharm Professional requires purchasing a license, the activation process does not take just one minute to complete. During the process of activating PyCharm Professional Edition, you usually need to use a license key and activation code. If you have a legitimate license key and activation code, you can activate PyCharm Professional Edition by following these steps: Open the PyCharm software and select "Help" - "Register" in the menu bar. In the pop-up dialog box, select "Licensese

How to activate Xiaomi Xiaoai How to activate Xiaomi Xiaoai Mar 19, 2024 am 09:30 AM

Friends who are familiar with the MIUI system should know that it has many convenient operations, such as one-touch dialing on the desktop, three-finger slide down to take screenshots, etc. What I want to introduce to you today is the long press operation of MIUI14. For example, press and hold the application icon on the desktop to display the extended menu. Press and hold the power button on any interface to wake up Xiao Ai classmates. Long press can realize functions such as direct function and quick startup. . How to activate Xiaomi Xiaoai Classmate? In the phone settings, find and click "Xiaomi Xiaoai Classmate". Then enter the Xiaoai interface and click "Voice Assistant". Then on the voice assistant interface, click the button to the right of "Voice Wake" to turn it on.

See all articles