How to restore PostgreSQL database dump

-

They'res a magnitude of methods to restore PostgreSQL dumps for a typical plaintext dump "psql" can do a pretty neat Job

In few words a PostgreSQL plaintext dump is nothing but a corpus embodied with SQL statements, which when executed tables are created data gets retrieved, inserted and restored.

So assuming you have a backup dump saved somewhere on your system open your terminal.

And type;

psql -U {{username}} < {{dump.sql}}

That's it you've imported a database dump

Comments

Post a Comment

Popular posts from this blog

Tar basic commands to store and extract files

-
Targeted is an archiving program designed to package, store, and compress multiple files into a single portable package the name tar is an abbreviation for tape archiver Apart from creating .tar archives tar is also capable of compressing files using zip, bzip2, and gzip compression algorithms Tar flags c — compress directive x — extract directive t — tabulate contents f — specify filename z — use zip/gzip compression j — use bzip2 compression k — do not overwrite t — files from file w — ask for configuration v — verbose gzip flags d — decompress file Tar commandline commands syntax tar -{arguments} {params} Example tar commands tar -cf music.tar music.mp3 Tar archiver will be directed to compress music.mp3 into a tar archive named music.tar and save it in the current working directory tar -xf music.tar Tar will be directed to extract music.tar archive and save the constituent contents of the archive...
Read more

Removing bash.sh #hash comments from a string using regEx in JavaScript

-
Last night i was looking for a method to remove comments from a robots.txt file containing contents of form below `# robots.txt user-agent Disallow:` Or a more practical format obtained by splitting the robots.txt file line by line. ["# robots.txt", "user-agent", "Disallow:"] every element of the array is a string representing a single line of text from a robots.txt plain text file. Regular expression I used regular expression to strip out the unwanted text until the end of the line however it's not limited to robots.txt it works perfectly with bash.sh files as well. Example var string = "Disallow / #deny bots" string.replace(/#.*$/, "") // returns  Disallow / It simply strip's off all characters after the hash character until the end of the line.
Read more

FlappingBird Postmortem (JS13K)

-
Image
FlappingBird was my Primary entry for JS13K Games competition 2020 It's about a bird flying in a forest of trees (Some of which are upside down) It started out as i was trying to draw some clouds for fun, then later i added every missing component to complete the sky First day. I planned making a game that should as well serve as a 404 page with a hidden game such that when a button is pressed It transitions into gameplay qualities were that it should be easy to play by everybody without need to master many rules Second day. There was a bunch of game ideas up my sleeves one of them was a game where a typical 404 page transitions into a green garden like mine sweeper version made up of a flowering mine field with smooth sweet sound effects Fourth day. We'll Since Mine sweeper is not a very common game there's nothing fun about it and not everyone knows how it's played. So i gave up on it and on this day i started working on backgrounds for flappingBird "the final...
Read more

How to build a twitter retweet bot using JavaScript

-
I'm sharing the code of my tweeter bot called ' JavaScript bot ' I forked the original source code from a certain github repository written in nodejs the bot retweets a giver hashTag at a specified time interval You can use a twitter bot to promote an interest or a campaign unlike Facebook twitter is more tolerant on automated accounts I used to build Facebook automated accounts which were posting user friendly comments on my Facebook friends posts with no success few months down the line Facebook suspended my account until then i decided to stop using Facebook at all And twitter is just the right platform for this kind of thing. For this bot to work you'll simply need an APIs key and a secret Twitter doesn't need waiting the long verification process as of 2020 I created my developer account and almost instantaneously my account got approved. The twitter hard limit on the number of retweets per day is 1000; clone git repository using the command; git clone ...
Read more

Npm how to install webpack nodejs

-
A guide on how to install webpack bundler and webpack-cli using npm package manager first thing install webpack it's recommended not to install webpack globally to avoid conflicts with webpack versions npm i webpack -D Note it's installed as a developer dependency. You'll also need to install webpack-cli npm i webpack-cli -D Again as a developer dependency.
Read more