pg dump - PostgreSQL: Database backup and Recovery? -


what procedure take database backup , recovery in postgresql 9.3?

i using sql dump same, getting error near pg_dump.

--example 

pg_dump testdb > backupfile

--error occurred 

error:  syntax error @ or near "pg_dump"   line 1: pg_dump testdb > backupfile

use below command take database backup locally 

pg_dump -u postgres -h 127.0.0.1 -p 5432 -fc -f filename.backup -w dbname

if want take database backup remotely use remote ipaddress in place of 127.0.0.1.


Comments

Post a Comment

Popular posts from this blog

css - I want to align grid in center -

as see code grid_2 has float left. added center class fix in center div block floating left. want place grid_2 div in center. can 1 me fix this? html code: <div class="center"><div class="grid_2">content goes here </div> </div> css: .grid_0 { width: 100%; margin-bottom: 15px; display: block; } .grid_1, .grid_2, .grid_3, .grid_3c, .grid_4, .grid_4c { margin-left : 1.00%; margin-right : 1.00%; margin-bottom : 15px; float : left; display : block; -webkit-box-sizing: border-box; /* safari/chrome, other webkit */ -moz-box-sizing: border-box; /* firefox, other gecko */ box-sizing: border-box; /* opera/ie 8+ */ } .center{ display: block; text-align: center; margin: 0 auto !important; } .grid_1 { width: 98%; } .grid_2 { width: 48%; } please find link below http://jsfiddle.net/kiranm/aqbs6/5/ ok, here problem lies in width of grid_2. as width of grid_2 = 48% of...
Read more

python - SWIG function not printing output -

i'm having prblem in executing function i've written in c. i've made , interface file given below: %module cnode %{ #include "cnode.h" %} %include "cnode.h" and here c program : #include <stdio.h> #include "cnode.h" void kill(void) { printf("method executed\n"); } the header file: void kill(void); when i'm trying execute in python interpreter, don't output. there problem declarations or bug? figured out, kill() predefined function won't work. changing name of function works fine.
Read more

Contact Form PHP Email Script -

Image
hello having problem email script on site. i used files https://jonbake.com/blog/bootstrap-3-contact-form-with-captcha/ but add fields. sending email i'm not receiving data inputted on fields. here html form <form role="form" id="feedbackform"> <div class="form-group"> <input type="text" class="form-control" id="first_name" name="first_name" placeholder="first name"> <span class="help-block" style="display: none;">please enter name.</span> </div> <div class="form-group"> <input type="text" class="form-control" id="last_name" name="last_name" placeholder="last name"> <span class="help-block" style="display: none;">please enter name.</span> </di...
Read more