Solved

Need help on taking backup in postgress SQL -- Challenging question

Posted on 2016-09-24
4
59 Views
Last Modified: 2016-09-27
Hi ,

Iam new to PostGress SQL , I need to write a batch script in windows to take backup . The script should accept the date as an input and take the backup for that day.

Iam sorry , Iam asking for the code , any help is really appreciated.
0
Comment
Question by:sam_2012
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
John Tsioumpris earned 500 total points
ID: 41813942
Why bother with scripting when there are free tools that can do the job effortlessly.
However if you insist then the Postgre Wiki has guides for Linux and Windows
1
 

Author Comment

by:sam_2012
ID: 41815241
Thanks .  I need to write an script which takes backup for a given day . Is there any script which can help me in this regard.
0
 
LVL 15

Expert Comment

by:John Tsioumpris
ID: 41815359
With pgAdmin you can create a job backup and get the script it uses
0
 

Author Closing Comment

by:sam_2012
ID: 41819146
awesome
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Batch to Restart Remote Computers 4 96
How to batch remove spreadsheet password 19 249
To check for the file in a batch script 8 47
Autorun Remote Desktop - USB Stick 6 34
TOMORROW TOMORROW.BAT is inspired by a question I get asked over and over again; that is, "How can I use batch file commands to obtain tomorrow's date?" The crux of this batch file revolves around the XCOPY command - a technique I discovered w…
VALIDATING DATES One method of validating dates is to jam the date into the DATE command and see if it accepts it by examining the system's errorlevel value. A non-zero result indicates failure. A typical example might look something like the fol…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question