Re: Import 2GB .sql file

Patrick Headley <[email protected]> Thu, 2 Jan 2020 16:32:47 -0700
Newsgroups gmane.comp.db.postgresql.pgadmin
Message-ID <[email protected]> 
This is a multi-part message in MIME format.
--------------4C701A416794D8F3A42B0193
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Sorry, I missed some of the text from this email when I initially replied.

You should be able to find instructions for restoring an sql file at 
https://www.postgresql.org/.

*/Patrick Headley/*
Linx Consulting, Inc.
(303) 916-5522
[email protected]
www.linxco-inc.com

On 1/2/20 12:03 PM, Travis Harris wrote:
> I have a 2GB sql file that I need to import.
>
> It is a database backup, but I do not have the ability to get it in 
> another format.
>
> When I try to use the open file option in the query tool, it spins for 
> a while but then brings up a blank text area with the file name as the 
> tab name.
>
> Is there some method to import this file?
>
> Thank you.


--------------4C701A416794D8F3A42B0193
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Helvetica, Arial, sans-serif">Sorry, I missed some of
      the text from this email when I initially replied.<br>
      <br>
      You should be able to find instructions for restoring an sql file
      at <a class="moz-txt-link-freetext" href="https://www.postgresql.org/">https://www.postgresql.org/</a>.<br>
      <br>
    </font>
    <div class="moz-signature"><font size="3"><b><i>Patrick Headley</i></b><br>
        Linx Consulting, Inc.<br>
        (303) 916-5522<br>
        <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a><br>
        <a class="moz-txt-link-abbreviated" href="http://www.linxco-inc.com">www.linxco-inc.com</a><br>
      </font>
      <br>
    </div>
    <div class="moz-cite-prefix">On 1/2/20 12:03 PM, Travis Harris
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAJfmU9fhxSz7DmM+R_gQVGkwfx6v8Pn_yFjxwg7e_jXSHYLrdg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>
          <div dir="ltr" class="gmail_signature"
            data-smartmail="gmail_signature">
            <div dir="ltr">
              <div>
                <div dir="ltr">
                  <div>
                    <div dir="ltr">
                      <div>
                        <div dir="ltr">
                          <div>I have a 2GB sql file that I need to
                            import.</div>
                          <div><br>
                          </div>
                          <div>It is a database backup, but I do not
                            have the ability to get it in another
                            format.</div>
                          <div><br>
                          </div>
                          <div>When I try to use the open file option in
                            the query tool, it spins for a while but
                            then brings up a blank text area with the
                            file name as the tab name.</div>
                          <div><br>
                          </div>
                          <div>Is there some method to import this file?</div>
                          <div><br>
                          </div>
                          <div>Thank you.</div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------4C701A416794D8F3A42B0193--