Host-based backup of VMware vSphere VMs.
Post Reply
GEA_info
Lurker
Posts: 2
Liked: never
Joined: Oct 04, 2018 2:05 pm
Contact:

Postgres Backup on Windows server

Post by GEA_info »

Hi All

Before we used Oracle Db and get no issue to make backup by veeam.

Now we are using postgres DB 9.6 i try to use Pre-Freeze and Post-Thaw Scripts. These script are localy on Veeam server

my Pre-Freeze:
echo select veeam_start_backup (); | psql -U veeam_backup -d postgres -h ugp-sup-m > start_veeam_backup.log 2>&1

my Post-Thaw Scripts:
echo select veeam_stop_backup (); | psql -U veeam_backup -d postgres -h ugp-sup-m > stop_veeam_backup.log 2>&1

I set them in:
-->Guest Processing-->Applications--> Scripts tab.

I select Ignore script execution failures

When start my job i get this alarm:
post-thaw script finished execution with exit code 255

But Veeam job still working

I check on my windows server postgres backup status is in false and no backup label is create on \PostgreSQL\9.6\data

If i manually execute these script on veeam server the postgres backup status become True and Backup label is create on \PostgreSQL\9.6\data

I have try add "exit code " on Pre-Freeze script:

echo select veeam_start_backup (); | psql -U veeam_backup -d postgres -h ugp-sup-m > start_veeam_backup.log 2>&1
exit 0

Put Veeam backup in error.

Any idea to solve it?

Regards
foggy
Veeam Software
Posts: 21073
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Postgres Backup on Windows server

Post by foggy »

Are you running the script manually under the same account under which Veeam Service is being run?
GEA_info
Lurker
Posts: 2
Liked: never
Joined: Oct 04, 2018 2:05 pm
Contact:

Re: Postgres Backup on Windows server

Post by GEA_info »

Yes under same account
foggy
Veeam Software
Posts: 21073
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Postgres Backup on Windows server

Post by foggy »

Here's another hint, if it doesn't help, feel free to contact technical support for a closer look. Thanks!
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 85 guests