Обсуждение: Scheduling backup via PgAgent
Dear all,
After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
What is the error message you are getting. Can you pass the bat file or sql file.
Date: Wed, 19 Nov 2008 04:14:00 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] Scheduling backup via PgAgent
To: pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
.ExternalClass DIV
{;}
What's on the ramp today could be on the streets tomorrow. Keep up with trends on MSN Lifestyle Try it!
Date: Wed, 19 Nov 2008 04:14:00 -0800
From: abr_ora@yahoo.com
Subject: [ADMIN] Scheduling backup via PgAgent
To: pgsql-admin@postgresql.org
CC: pgsql-general@postgresql.org
Dear all,
After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
After installing PgAgent I have successfully created a job for auto scheduled backup. But it is not working. I have tried both method i.e. via .bat and via SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
What's on the ramp today could be on the streets tomorrow. Keep up with trends on MSN Lifestyle Try it!
Oh!
I have got the mistake made by me. Actually I didn't start the PostgreSQL Scheduling Agent - pgAgent service. Now its working fine.
I also have attached the complete document of my work for the sake of knowledge share.
Regards,
Abdul Rehman.
I have got the mistake made by me. Actually I didn't start the PostgreSQL Scheduling Agent - pgAgent service. Now its working fine.
I also have attached the complete document of my work for the sake of knowledge share.
Regards,
Abdul Rehman.
On Thu, Nov 20, 2008 at 5:41 AM, Abdul Rahman <abr_ora@yahoo.com> wrote: > Oh! > > I have got the mistake made by me. Actually I didn't start the PostgreSQL > Scheduling Agent - pgAgent service. Now its working fine. > > I also have attached the complete document of my work for the sake of > knowledge share. I think you forgot the attachment. It would be useful if you could add it to the wiki though: http://wiki.postgresql.org/ -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com