Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Options to choose from Output SQL Options · View
sandyjs7
#1 Posted : Thursday, May 17, 2018 5:00:01 PM
Rank: Newbie

Groups: Registered

Joined: 5/16/2018
Posts: 3
Hi,

I am taking the backup and need both the database structure and data for the first time and then only the data from 2nd run.
I want to do a daily restore of this backup in a different env. Ideally, I would like to keep the schema and restore only the data on a day-day basis.
Can you guide me what are all the options I need to choose from the Advanced settings--> Output SQL file options.

Thanks in advance
Alexander Omelchenko
#2 Posted : Friday, May 18, 2018 3:48:02 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 456
Hello

PostgreSQL-Backup performs databases backups, in the same way, as pg_dump tool. Sorry, but there is no way to restore backups using PostgreSQL-Backup tool, but they can be easily restored via command prompt:

1. Go to Postgres bin folder. For example: cd "C:\ProgramFiles\PostgreSQL\9.5\bin"
2. Enter the command to restore your database. For example: psql.exe -U <user-name> -d <database-name> -f <file-name>
3. Type password for your postgres user
4. Check the restore process

Also, you can add all necessary arguments, that you can use with pg_dump tool at the Advanced settings > More SQL Options... > Custom arguments.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com