How To Take Backup Of Database As SQL/TAR File And How Restore Database In PostgreSQL Using pgAdmin4

Sdílet
Vložit
  • čas přidán 15. 07. 2020
  • #knowledge360 #akramsohail #akramsohailproject
    You Are Hearty Welcomed To My Channel Knowledge 360.
    Here I post technical videos, mainly related to computer science and programming.
    I am posting project videos with coding explanations. I make tutorial videos on Technical Topics.
    Stay Connected, Stay Tuned, Study Smart.
    - Knowledge 360 ( Akram Sohail )
    Only 3.9% of viewers are subscribing to my channel 😓.
    I request you to please give click on Subscribe button.
    It really helps me grow 😢.
    Please Like, Comment, and Subscribe to my channel. ❤
    Follow me on Social Media
    --------------------------------------------------
    Facebook - / sonu.babu.5872682
    Instagram - / akkubakku007
    google+ - plus.google.com/u/0/116728183...
    Blog - knowledge360blog.blogspot.in/
    Business/Mentorship - knowledge.360.knowledge@gmail.com
    Topics
    ---------
    Oracle
    MySQL
    PostgreSQL
    SQL Server
    PHP
    C
    C++
    Python
    Java
    JavaScript
    HTML/CSS
    jQuery
    Ajax
    Bootstrap
    Angular
    Linux
    Ubuntu
    Windows
    Miscellaneous
    Description
    ------------------
    In this video, I have explained How To Take Backup Of Database As SQL/TAR File And How Restore Database In PostgreSQL Using pgAdmin4.
    This is a very helpful video if you are a developer working with PostgreSQL.

Komentáře • 34

  • @Knowledge360Channel
    @Knowledge360Channel  Před 2 lety +1

    *Please help me get that beautiful CZcams Silver button. Do subscribe to the channel if my video was helpful.* ❤

  • @crazetocode3159
    @crazetocode3159 Před 4 lety +2

    I like to learn about it. support and stay connected

  • @akramsohail4322
    @akramsohail4322 Před 2 lety +1

    Thanks for the video.

  • @prajaktamarotkar9013
    @prajaktamarotkar9013 Před rokem +1

    very helpful and knowledgeable video

  • @mosahebuddin1877
    @mosahebuddin1877 Před rokem +1

    Wow

  • @akramsohail6693
    @akramsohail6693 Před 2 lety +1

    wow

  • @lordbrayantv
    @lordbrayantv Před 9 měsíci +1

    TE AMOOOOOOOOOOOOOOOOOOO. MUCHAS GRACIAS!!. TE LO DIGO EN ESPAÑOL!. ME SALVASTE LA VIDA!!!!!!!!!!!!!!!!! THANKS A LOT :D

    • @Knowledge360Channel
      @Knowledge360Channel  Před 9 měsíci

      You're Welcome 🤗.... please subscribe my channel to support me 🙏

    • @Knowledge360Channel
      @Knowledge360Channel  Před měsícem

      *Please help me get that beautiful CZcams Silver button. Do subscribe to the channel if my video was helpful.* ❤

  • @vodacbao
    @vodacbao Před 2 lety +1

    thanks you

  • @EdsonBreno-kk5lt
    @EdsonBreno-kk5lt Před rokem +1

    Thanks for video!

  • @kel6207
    @kel6207 Před 2 lety +1

    hi, i already configured the Binary Preferences, and i tried to restored the database, an exit code 1 error pops up, can you please help me?

  • @user-jp2qy4gk2u
    @user-jp2qy4gk2u Před 5 měsíci +1

    it says pg_restore: error: el archivo de entrada parece ser un volcado de texto. Por favor use psql.

  • @9697Studio
    @9697Studio Před 2 lety +1

    Thanks for video it help me alot
    I succefully take backup in sql and tar file.
    But when i restore it ,i facing an error file code 1
    Pls help how to resolve it

  • @sureshrajendran6782
    @sureshrajendran6782 Před 3 lety +1

    Please how to take transaction log backup

  • @hans_hans
    @hans_hans Před 3 lety +1

    pg_restore: [archiver] unsupported version (1.14) in file header
    i get this error can anybody help

  • @natti771
    @natti771 Před 2 lety +1

    It would be easier to use Notepad ++ , and set SQL as a language.

  • @Samcasm7
    @Samcasm7 Před 2 lety +1

    Hi Akram , is there any way to recover the data directory, i have lost somehow, please let me know if we can restore the same anyhow

  • @pd.piyushdas21
    @pd.piyushdas21 Před 2 lety +1

    SIR, you did not show how to restore file with sql extension....why?

    • @Knowledge360Channel
      @Knowledge360Channel  Před 2 lety +1

      I have shown in some other video...that requires another command...and I'm making videos for PostgreSQL 14 version now. Subscribe the channel to get the updates.

    • @fathimashanavas6511
      @fathimashanavas6511 Před rokem +2

      @@Knowledge360Channel Hi, I'm facing this same issue and could not find the said video. Kindly help

    • @Knowledge360Channel
      @Knowledge360Channel  Před rokem

      @@fathimashanavas6511 Here's the video. In this video I've shown to take backup as SQL file as well as TAR file. Please check and subscribe my channel to support me 😊
      czcams.com/video/O94BynkAEzY/video.html

    • @Knowledge360Channel
      @Knowledge360Channel  Před rokem

      Please check this video.
      czcams.com/video/O94BynkAEzY/video.html

  • @robin46035
    @robin46035 Před 2 lety +1

    fake