Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Backup does not run Options · View
fagnersn
#1 Posted : Tuesday, May 12, 2015 8:08:35 PM
Rank: Newbie

Groups: Registered

Joined: 5/12/2015
Posts: 2
Location: Belém-PA
Hello, the tool never worked for me.
After Several unsuccessful attempts, it returns the following message:


>>> run 12/05/2015 22:08:20 by novatera

SqlBackupAndFtp 1.0.3.37029 Free (started manually) at SRV-ACQUA (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET: 2.0.50727.5420, 3.0.30729.5420, 3.5.30729.5420, 4.0.30319)
Job name: D:\ALTERDAT\Backup\Backup_Pack-2130.pjobx

SUMMARY:
Database ALTERDATA: - Failed

DETAILED LOG:
05/12/2015 22:08:20 Creating backup of ALTERDATA to G:\BACKUPS SISTEMAS\PACK (dump)
05/12/2015 22:08:20 ERROR: pg_dump process has finished with "-1073741515" code. The error message: ""
05/12/2015 22:08:20 ERROR: Job finished (With Errors)
fagnersn
#2 Posted : Tuesday, May 12, 2015 8:22:51 PM
Rank: Newbie

Groups: Registered

Joined: 5/12/2015
Posts: 2
Location: Belém-PA
The version of My Postgree is 9.0
AlexP
#3 Posted : Wednesday, May 13, 2015 11:29:08 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hello,

We have just released PostgreSQL Backup 1.0.5 with fix of issues related to running pg_dump command. Please try to run the backup job with this version.

Regards,
Alexey.
wendinso
#4 Posted : Monday, August 20, 2018 10:56:57 AM
Rank: Newbie

Groups: Registered

Joined: 8/20/2018
Posts: 2
Location: BURKINA FASO

Hello
I am a young developper
and I use postgresql 9.5 su pgadmin 3
I have a windows 7 system
I do the backup with postgresql backup 2.0.6
the backup has no problem
I get a SQL file
but it's the restoration
I tested with psql, pgadmin
the orders:
psql -U postgres -f C: \ Users \ NANA \ Desktop \ management201808191728-backup.sql

psql -U <openpg> -d <rez> -1 -f <C: \ Users \ NANA \ Desktop \ Management201808191728> .sql

without normal result
I ask for help to understand
THANK YOU
Alexander Omelchenko
#5 Posted : Monday, October 1, 2018 9:57:08 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 456
Hello,

Here is a short tutorial on how to restore PostgreSQL databases backups via command line:

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 -d -f
3. Type password for your postgres user
4. Check the restore process

Sorry for the delay
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