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

JavaScript default parameters

-
Image
Since es6 its possible to include default function parameters just like other programing languages such as php do, default parameters cut down the need to initially set default Parameters within the code as; const vec function (x, y){ if(typeof x == "undefined") x = 0; if(typeof y == "undefined") y = 0; return { x, y } } now the above can be done in a more simple way , using default parameters as; const vec function (x = 0, y = 0){ return { x, y } } In either of the functions if you omit either of the Parameters your parameter will default to zero ie 0;
Read more

How to install tfjs JavaScript library

-
Image
Tensorflow is a hardware accelerated JavaScript library for building, training, testing and deploying machine learning models on a JavaScript runtime environment. Installation through html script tag For use within the browser you can link to jsdelivr content delivery network using an html script tag as follows; <script src="https://cdn.jsdelivr.net/npm/@tensorflow/tfjs@1.0.0/dist/tf.min.js"></script> Installation through npm package manager Alternatively you can install a self hosted version of tensorflow from npm, in your terminal type; npm install '@tensorflow/tfjs' Installation for tfjs-node on npm tensorflow has two nodejs packages made specifically for nodejs Installation for '@tensorflow/tfjs-node' This version is a cpu only version it doesn't utilize gpu to do the computing, install tfjs node by typing; npm install '@tensorflow/tfjs-node' Installation for '@tensorflow/ tfjs-node...
Read more

JavaScript math methods

-
JavaScript comprehensive list of all JavaScript Math methods Math.round () {type} method {parameter} {Number} {description} It returns a given number rounded off to the nearest integer. ie Math.round(0.6251) // returns 1 or Math.round(1.7252) // returns 2 Math . pow () {type} method {parameter} {Number}, {Number} {description} It returns a given number raised to the power the exponent. ie Math.pow(2, 5) // returns 32 or Math.pow(7, 2) // returns 49 Math.sqrt () {type} method {parameter} {Number} {description} It returns the square root of a given integer. ie Math.sqrt(25) // returns 5 or Math.sqrt(64) // returns 8 Math.abs () {type} method {parameter} {Number} {description} It returns absolute positive value of a given number ie Math.abs(-10) // returns 10 or Math.abs(52) // returns 52 Math.ceil () {type} method {parameter} {Number} {description} It returns a smaller number which is greater or equal to the given integer. ie Math.ceil(9.87) // returns 10 or...
Read more

How to make a Snake Game using JavaScript and html5

-
Image
I compiled stapes to create a game similar to Nokia developed, popular game called 'snake' Snake was first developed by Nokia, programmed in 1997 by Taneli Armanto and published on Nokia mobile devices,  It was introduced on Nokia model 6110, 3310 from 2000 and later the game was rebranded as " Snake Xenzia " Included on later mobile phone models I made a version that is more simplified and more beginners friendly, It's based on the same idea of making a snake that grows as it eats stuff and the score increases as it grows I'm implementing this whole game in pure vanilla JavaScript and a taste of html5 canvas, In this project the canvas is used as a renderer for the game's visual output concepts and initial ideas I got the idea while doing another retro gaming project, i thought it would be good too if i created this game, from start my plan had been simplicity and making this game easy to implement, So to simplify everything i had...
Read more

Redirecting a webpage in JavaScript

-
Redirects are way of navigating a user to another webpage or location redirects are normally done by server side implementations. it's possible to do redirects using JavaScript too window.location is a object that stores current location information such as path, port, hostname and href or the location in the address bar of your browser changing it invokes a redirect it's a simple way to redirect a user to another webpage Syntax window.location.asign('https://example.com') or simply like window.location = "https://example.com" or simply omit window location = "https://example.com"
Read more