Restoring Postgres db dump on Greenplum The Next CEO of Stack OverflowHow could I import...

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

Can I hook these wires up to find the connection to a dead outlet?

Is the offspring between a demon and a celestial possible? If so what is it called and is it in a book somewhere?

Can you teleport closer to a creature you are Frightened of?

How can the PCs determine if an item is a phylactery?

How seriously should I take size and weight limits of hand luggage?

How can I prove that a state of equilibrium is unstable?

Planeswalker Ability and Death Timing

Creating a script with console commands

Why does the freezing point matter when picking cooler ice packs?

Is it a bad idea to plug the other end of ESD strap to wall ground?

Calculate the Mean mean of two numbers

How badly should I try to prevent a user from XSSing themselves?

Oldie but Goldie

Is it correct to say moon starry nights?

Why doesn't Shulchan Aruch include the laws of destroying fruit trees?

Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?

Finitely generated matrix groups whose eigenvalues are all algebraic

pgfplots: How to draw a tangent graph below two others?

Can a PhD from a non-TU9 German university become a professor in a TU9 university?

Is this a new Fibonacci Identity?

Why do we say “un seul M” and not “une seule M” even though M is a “consonne”?

logical reads on global temp table, but not on session-level temp table

What does this strange code stamp on my passport mean?



Restoring Postgres db dump on Greenplum



The Next CEO of Stack OverflowHow could I import Postgres data dumps into MS SQL?Giving a database an alias in postgresmigrating from postgres 8.1 to 9.0Postgres backupCan you dump tables from a non-functional postgresql database?postgres restore from data files - no data showing upMost reliable MariaDB to Postgres dump methodPostgresql: restoring database from dump failsPostgres 9.5: Restoring dumps is very very slowPostgres 10.1 slow on Ubuntu 16.04












0















I Have set up a Greenplum db with two segments on AWS.
I have a Postgres database SQL dump and I would like to use that dum to recreate the database on Greenplum.
The only options I have seen in the Greenplum documentation is restoring to an existing db or restoring from another Greenplum set up with the same number of segments.
Does anyone have an idea of how I would do this?









share







New contributor




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

























    0















    I Have set up a Greenplum db with two segments on AWS.
    I have a Postgres database SQL dump and I would like to use that dum to recreate the database on Greenplum.
    The only options I have seen in the Greenplum documentation is restoring to an existing db or restoring from another Greenplum set up with the same number of segments.
    Does anyone have an idea of how I would do this?









    share







    New contributor




    kanataki 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








      I Have set up a Greenplum db with two segments on AWS.
      I have a Postgres database SQL dump and I would like to use that dum to recreate the database on Greenplum.
      The only options I have seen in the Greenplum documentation is restoring to an existing db or restoring from another Greenplum set up with the same number of segments.
      Does anyone have an idea of how I would do this?









      share







      New contributor




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












      I Have set up a Greenplum db with two segments on AWS.
      I have a Postgres database SQL dump and I would like to use that dum to recreate the database on Greenplum.
      The only options I have seen in the Greenplum documentation is restoring to an existing db or restoring from another Greenplum set up with the same number of segments.
      Does anyone have an idea of how I would do this?







      postgresql





      share







      New contributor




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










      share







      New contributor




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








      share



      share






      New contributor




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









      asked 3 mins ago









      kanatakikanataki

      1




      1




      New contributor




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





      New contributor





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






      kanataki 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: "2"
          };
          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: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          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
          });


          }
          });






          kanataki 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%2fserverfault.com%2fquestions%2f961042%2frestoring-postgres-db-dump-on-greenplum%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








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










          draft saved

          draft discarded


















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













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












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
















          Thanks for contributing an answer to Server Fault!


          • 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%2fserverfault.com%2fquestions%2f961042%2frestoring-postgres-db-dump-on-greenplum%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

          As a Security Precaution, the user account has been locked The Next CEO of Stack OverflowMS...

          Список ссавців Італії Природоохоронні статуси | Список |...

          Українські прізвища Зміст Історичні відомості |...