Replication Scenario on Postgres












0















Recently i got a request from team that confusing. I have search the internet but found no exact information about it.
I have 2 request of replication scenario that i dont know whether is it possible or not.




  1. Replication between 2 servers with different database name. Example, i have 2 server, A (primary) and B (slave), is it possible to replicate database primary_product in server A, into primary_product_anltycs in server B (Different database name) ? Any link tutorial for this ?


  2. Replication between 2 servers which consist of several databases in Server A, need to be transfered into single database with multiple schema (custom schema name) on Server B. Is this possible ? Any link tutorial for this ?



Be informed, i have successfully setup replication using WAL.



Any help would be very appreciated.










share|improve this question







New contributor




user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    Recently i got a request from team that confusing. I have search the internet but found no exact information about it.
    I have 2 request of replication scenario that i dont know whether is it possible or not.




    1. Replication between 2 servers with different database name. Example, i have 2 server, A (primary) and B (slave), is it possible to replicate database primary_product in server A, into primary_product_anltycs in server B (Different database name) ? Any link tutorial for this ?


    2. Replication between 2 servers which consist of several databases in Server A, need to be transfered into single database with multiple schema (custom schema name) on Server B. Is this possible ? Any link tutorial for this ?



    Be informed, i have successfully setup replication using WAL.



    Any help would be very appreciated.










    share|improve this question







    New contributor




    user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      Recently i got a request from team that confusing. I have search the internet but found no exact information about it.
      I have 2 request of replication scenario that i dont know whether is it possible or not.




      1. Replication between 2 servers with different database name. Example, i have 2 server, A (primary) and B (slave), is it possible to replicate database primary_product in server A, into primary_product_anltycs in server B (Different database name) ? Any link tutorial for this ?


      2. Replication between 2 servers which consist of several databases in Server A, need to be transfered into single database with multiple schema (custom schema name) on Server B. Is this possible ? Any link tutorial for this ?



      Be informed, i have successfully setup replication using WAL.



      Any help would be very appreciated.










      share|improve this question







      New contributor




      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      Recently i got a request from team that confusing. I have search the internet but found no exact information about it.
      I have 2 request of replication scenario that i dont know whether is it possible or not.




      1. Replication between 2 servers with different database name. Example, i have 2 server, A (primary) and B (slave), is it possible to replicate database primary_product in server A, into primary_product_anltycs in server B (Different database name) ? Any link tutorial for this ?


      2. Replication between 2 servers which consist of several databases in Server A, need to be transfered into single database with multiple schema (custom schema name) on Server B. Is this possible ? Any link tutorial for this ?



      Be informed, i have successfully setup replication using WAL.



      Any help would be very appreciated.







      postgresql replication






      share|improve this question







      New contributor




      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 12 mins ago









      user776550user776550

      1




      1




      New contributor




      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user776550 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          user776550 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227628%2freplication-scenario-on-postgres%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          user776550 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          user776550 is a new contributor. Be nice, and check out our Code of Conduct.













          user776550 is a new contributor. Be nice, and check out our Code of Conduct.












          user776550 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f227628%2freplication-scenario-on-postgres%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Liste der Baudenkmale in Friedland (Mecklenburg)

          Single-Malt-Whisky

          Czorneboh