pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSchedules Running Problem
6+ messages / 3 participants
[nested] [flat]
* Schedules Running Problem
@ 2007-09-19 12:43 yogesh.arora.daffodil@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: yogesh.arora.daffodil@gmail.com @ 2007-09-19 12:43 UTC (permalink / raw)
To: pgsql-admin
Hello EveryBody,
I have to create a schedule in the Postgres to insert
some data in the table. But before creating this schedule, i create
schedule that create the table in the Database specified. But, the
schedule is not working.not creating any Table in the Database.....
could any body tell me about the correct way of creating the
schedule(if i am wrong) and how could my problem be solved?????
Please reply as soon as possible.
Regards,
Yogesh Arora
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Schedules Running Problem
@ 2007-09-20 17:34 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: yogesh.arora.daffodil@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: Kevin Grittner @ 2007-09-20 17:34 UTC (permalink / raw)
To: yogesh.arora.daffodil@gmail.com; pgsql-admin
>>> On Wed, Sep 19, 2007 at 7:43 AM, in message
<1190205804.953274.158470@i13g2000prf.googlegroups.com>,
<yogesh.arora.daffodil@gmail.com> wrote:
>
> I have to create a schedule in the Postgres to insert
> some data in the table. But before creating this schedule, i create
> schedule that create the table in the Database specified. But, the
> schedule is not working.not creating any Table in the Database.....
>
> could any body tell me about the correct way of creating the
> schedule(if i am wrong) and how could my problem be solved?????
You didn't give us much to go on.
What operating system?
What did you do to try to schedule these things?
What were you expecting to see as a result?
What did you see, including exact error text, if any?
-Kevin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Schedules Running Problem
@ 2007-09-21 14:12 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 6+ messages in thread
From: Kevin Grittner @ 2007-09-21 14:12 UTC (permalink / raw)
To: Yogesh Arora <yogesh.arora.daffodil@gmail.com>; pgsql-admin
Please respond to the list as well as any individuals. This helps make
the archive message thread useful for others who may have a similar
problem, and it may draw advice from others who can help.
>>> On Thu, Sep 20, 2007 at 11:01 PM, in message
<116685ec0709202101o7142adabrc5fe851e54f6bca3@mail.gmail.com>, "Yogesh Arora"
<yogesh.arora.daffodil@gmail.com> wrote:
> Hello Kevin,
> First of all, Thanks for your response.
> The answer to your Questions
>
>>>>>What operating system?
> I am using the Windows 2003 operating System.
>>>>>What did you do to try to schedule these things?
> I have created a Batch File of a Command to take the Back of the Database
> specified. When i run this file through command Prompt, its run
> successfully. But when i try to schedule it., It's not get scheduled and
> does not show any errors.
Exactly what are you doing to try to schedule it?
How do you determine that it hasn't been scheduled?
> Then i tried to schedule the direct SQL command , but the same result, not
> being scheduled.
>>>>What were you expecting to see as a result?
> Expecting the results of the above.
>>>>>>>What did you see, including exact error text, if any?
> There are not any Error to show......................................
>
> The Query in Batch File is :-
>
> @echo off
> "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U username -f
> D:\test\test.sql -F p -C -d -D postgres
>
> The Password related info is being stored in the PgPass.conf file.......
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Schedules Running Problem
@ 2007-09-24 04:00 Yogesh Arora <yogesh.arora.daffodil@gmail.com>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 6+ messages in thread
From: Yogesh Arora @ 2007-09-24 04:00 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
Hello Kevin,
>>>>Exactly what are you doing to try to schedule it?
I am trying to schedule a database back up...using batch
File....but it is not happening then i tried to schedule a SQL Script for
creating a table on the Database. this is also not functioning....
>>>>How do you determine that it hasn't been scheduled?
When i tried to back up the back up file is not created and in
the case of Create table there is not any table in the database.
On 9/21/07, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>
> Please respond to the list as well as any individuals. This helps make
> the archive message thread useful for others who may have a similar
> problem, and it may draw advice from others who can help.
>
> >>> On Thu, Sep 20, 2007 at 11:01 PM, in message
> <116685ec0709202101o7142adabrc5fe851e54f6bca3@mail.gmail.com>, "Yogesh
> Arora"
> <yogesh.arora.daffodil@gmail.com> wrote:
> > Hello Kevin,
> > First of all, Thanks for your response.
> > The answer to your Questions
> >
> >>>>>What operating system?
> > I am using the Windows 2003 operating System.
> >>>>>What did you do to try to schedule these things?
> > I have created a Batch File of a Command to take the Back of the
> Database
> > specified. When i run this file through command Prompt, its run
> > successfully. But when i try to schedule it., It's not get scheduled and
> > does not show any errors.
>
> Exactly what are you doing to try to schedule it?
> How do you determine that it hasn't been scheduled?
>
> > Then i tried to schedule the direct SQL command , but the same result,
> not
> > being scheduled.
> >>>>What were you expecting to see as a result?
> > Expecting the results of the above.
> >>>>>>>What did you see, including exact error text, if any?
> > There are not any Error to show......................................
> >
> > The Query in Batch File is :-
> >
> > @echo off
> > "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U username -f
> > D:\test\test.sql -F p -C -d -D postgres
> >
> > The Password related info is being stored in the PgPass.conf file.......
>
>
>
>
--
Best Regards,
Yogesh Arora
Mobile: 09255123173
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Schedules Running Problem
@ 2007-09-24 07:36 Yogesh Arora <yogesh.arora.daffodil@gmail.com>
parent: Yogesh Arora <yogesh.arora.daffodil@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Yogesh Arora @ 2007-09-24 07:36 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
Thanks to all in the Group,
Now my Schedule is Running.....
The Steps i have taken are given below:-
PgAgent for windows
1) Run PgAgent.sql script in maintenance database (Postgres database by
default).
2) Install PgAgent service using the following command on command
prompt -
• "C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u
postgres
-p XXXX hostaddr=127.0.0.1 dbname=postgres user=Postgres
if the above command didnot work suceefully then u can use the following
Command:----
go to the Diectory path("C:\Program Files\PostgreSQL\8.2\bin") and run the
Command
pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX
hostaddr=127.0.0.1dbname=postgres
user=postgres password=XXXX
• Replace the path of pgAgent if you are not using default installation
path
of Postgres
• Replace XXXX with the password of OS User Postgres (One given while
installing Postgres on windows)
• dbname=postgres (change if your maintenance database is different.)
3) Login using Postgres user account in windows.
4) Try to access pgAdmin III tool in that login. (These two steps are
required to create pgpass.conf file under Postgres login account.)
5) Login back to your normal account.
Edit the pgpass.conf File with the Following Line :----
localhost:PortNumber:myDBname:myUserName:myPassword
*:*:*:*:Password
in both the Account Postgres and your Local Login Account. The
Pgpass.Conf File is located in
%ApplicationData%/postgres/
6) Start pgAgent service using the following command on command prompt
• Net start pgAgent
7) Create a new job using PgAdmin III
8) Under step tab click Add to add new step.
• Specify some name
• Kind – SQL / Batch depending upon the kind of job to be performed.
• Database on which the job is to be performed.
• Definition tab would contain a SQL command if kind selected is SQL
• Definition tab would contain path of Batch file if kind selected is
Batch
9) Under Schedule tab in Job window click Add to add new schedule for
the
job
• Specify some name
• Specify the start date & time
• Specify the end date and time
• Specify days or weekdays, months when the task needs to be performed
in
days tab
• Specify time hours & Minutes when you want the task to be performed.
(Atleast One hour & minute to be selected.)
• Specify exception if any when you do not want the task to be
performed.
10) All set to work.
On 9/24/07, Yogesh Arora <yogesh.arora.daffodil@gmail.com> wrote:
>
> Hello Kevin,
> >>>>Exactly what are you doing to try to schedule it?
> I am trying to schedule a database back up...using batch
> File....but it is not happening then i tried to schedule a SQL Script for
> creating a table on the Database. this is also not functioning....
>
> >>>>How do you determine that it hasn't been scheduled?
> When i tried to back up the back up file is not created and in
> the case of Create table there is not any table in the database.
>
>
> On 9/21/07, Kevin Grittner <Kevin.Grittner@wicourts.gov > wrote:
> >
> > Please respond to the list as well as any individuals. This helps make
> > the archive message thread useful for others who may have a similar
> > problem, and it may draw advice from others who can help.
> >
> > >>> On Thu, Sep 20, 2007 at 11:01 PM, in message
> > < 116685ec0709202101o7142adabrc5fe851e54f6bca3@mail.gmail.com>, "Yogesh
> > Arora"
> > <yogesh.arora.daffodil@gmail.com> wrote:
> > > Hello Kevin,
> > > First of all, Thanks for your response.
> > > The answer to your Questions
> > >
> > >>>>>What operating system?
> > > I am using the Windows 2003 operating System.
> > >>>>>What did you do to try to schedule these things?
> > > I have created a Batch File of a Command to take the Back of the
> > Database
> > > specified. When i run this file through command Prompt, its run
> > > successfully. But when i try to schedule it., It's not get scheduled
> > and
> > > does not show any errors.
> >
> > Exactly what are you doing to try to schedule it?
> > How do you determine that it hasn't been scheduled?
> >
> > > Then i tried to schedule the direct SQL command , but the same
> > result, not
> > > being scheduled.
> > >>>>What were you expecting to see as a result?
> > > Expecting the results of the above.
> > >>>>>>>What did you see, including exact error text, if any?
> > > There are not any Error to show......................................
> > >
> > > The Query in Batch File is :-
> > >
> > > @echo off
> > > "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U username -f
> > > D:\test\test.sql -F p -C -d -D postgres
> > >
> > > The Password related info is being stored in the PgPass.conffile.......
> >
> >
> >
> >
>
>
> --
> Best Regards,
> Yogesh Arora
> Mobile: 09255123173
>
>
--
Best Regards,
Yogesh Arora
Asst. Software Engg.
Daffodil Software Pvt. Ltd.,
Mobile: 09255123173
Web : www.daffodildb.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Schedules Running Problem
@ 2007-09-24 08:51 Yogesh Arora <yogesh.arora.daffodil@gmail.com>
parent: Yogesh Arora <yogesh.arora.daffodil@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Yogesh Arora @ 2007-09-24 08:51 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin
Hello all,
Now my Schedule is Running.....
The Steps i have taken are given below:-
PgAgent for windows
1) Run PgAgent.sql script in maintenance database (Postgres database by
default).
2) Install PgAgent service using the following command on command
prompt -
• "C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u
postgres
-p XXXX hostaddr= 127.0.0.1 dbname=postgres user=Postgres
if the above command didnot work suceefully then u can use the following
Command:----
go to the Diectory path("C:\Program Files\PostgreSQL\8.2\bin") and run the
Command
pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX
hostaddr=127.0.0.1dbname=postgres
user=postgres password=XXXX
• Replace the path of pgAgent if you are not using default installation
path
of Postgres
• Replace XXXX with the password of OS User Postgres (One given while
installing Postgres on windows)
• dbname=postgres (change if your maintenance database is different.)
3) Login using Postgres user account in windows.
4) Try to access pgAdmin III tool in that login. (These two steps are
required to create pgpass.conf file under Postgres login account.)
5) Login back to your normal account.
Edit the pgpass.conf File with the Following Line :----
localhost:PortNumber:myDBname:myUserName:myPassword
*:*:*:*:Password
in both the Account Postgres and your Local Login Account. The
Pgpass.Conf File is located in
%ApplicationData%/postgres/
6) Start pgAgent service using the following command on command prompt
• Net start pgAgent
7) Create a new job using PgAdmin III
8) Under step tab click Add to add new step.
• Specify some name
• Kind – SQL / Batch depending upon the kind of job to be performed.
• Database on which the job is to be performed.
• Definition tab would contain a SQL command if kind selected is SQL
• Definition tab would contain path of Batch file if kind selected is
Batch
9) Under Schedule tab in Job window click Add to add new schedule for
the
job
• Specify some name
• Specify the start date & time
• Specify the end date and time
• Specify days or weekdays, months when the task needs to be performed
in
days tab
• Specify time hours & Minutes when you want the task to be performed.
(Atleast One hour & minute to be selected.)
• Specify exception if any when you do not want the task to be
performed.
10) All set to work.
Thanks for your support.
On 9/24/07, Yogesh Arora <yogesh.arora.daffodil@gmail.com> wrote:
>
> Thanks to all in the Group,
>
> Now my Schedule is Running.....
>
> The Steps i have taken are given below:-
>
>
> PgAgent for windows
> 1) Run PgAgent.sql script in maintenance database (Postgres database
> by
> default).
> 2) Install PgAgent service using the following command on command
> prompt -
> • "C:\Program Files\PostgreSQL\8.2\bin\pgAgent" INSTALL pgAgent -u
> postgres
> -p XXXX hostaddr= 127.0.0.1 dbname=postgres user=Postgres
>
> if the above command didnot work suceefully then u can use the following
> Command:----
>
> go to the Diectory path("C:\Program Files\PostgreSQL\8.2\bin") and run
> the Command
>
> pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX hostaddr=127.0.0.1dbname=postgres
> user=postgres password=XXXX
>
> • Replace the path of pgAgent if you are not using default
> installation path
> of Postgres
> • Replace XXXX with the password of OS User Postgres (One given while
> installing Postgres on windows)
> • dbname=postgres (change if your maintenance database is different.)
> 3) Login using Postgres user account in windows.
>
> 4) Try to access pgAdmin III tool in that login. (These two steps are
> required to create pgpass.conf file under Postgres login account.)
>
> 5) Login back to your normal account.
>
> Edit the pgpass.conf File with the Following Line :----
>
> localhost:PortNumber:myDBname:myUserName:myPassword
>
> *:*:*:*:Password
> in both the Account Postgres and your Local Login Account. The
> Pgpass.Conf File is located in
> %ApplicationData%/postgres/
>
> 6) Start pgAgent service using the following command on command
> prompt
> • Net start pgAgent
>
> 7) Create a new job using PgAdmin III
>
> 8) Under step tab click Add to add new step.
> • Specify some name
> • Kind – SQL / Batch depending upon the kind of job to be performed.
> • Database on which the job is to be performed.
> • Definition tab would contain a SQL command if kind selected is SQL
> • Definition tab would contain path of Batch file if kind selected is
> Batch
> 9) Under Schedule tab in Job window click Add to add new schedule for
> the
> job
> • Specify some name
> • Specify the start date & time
> • Specify the end date and time
> • Specify days or weekdays, months when the task needs to be performed
> in
> days tab
> • Specify time hours & Minutes when you want the task to be performed.
> (Atleast One hour & minute to be selected.)
> • Specify exception if any when you do not want the task to be
> performed.
> 10) All set to work.
>
>
>
>
>
> On 9/24/07, Yogesh Arora < yogesh.arora.daffodil@gmail.com> wrote:
> >
> > Hello Kevin,
> > >>>>Exactly what are you doing to try to schedule it?
> > I am trying to schedule a database back up...using
> > batch File....but it is not happening then i tried to schedule a SQL Script
> > for creating a table on the Database. this is also not functioning....
> >
> > >>>>How do you determine that it hasn't been scheduled?
> > When i tried to back up the back up file is not created and
> > in the case of Create table there is not any table in the database.
> >
> >
> > On 9/21/07, Kevin Grittner < Kevin.Grittner@wicourts.gov > wrote:
> > >
> > > Please respond to the list as well as any individuals. This helps
> > > make
> > > the archive message thread useful for others who may have a similar
> > > problem, and it may draw advice from others who can help.
> > >
> > > >>> On Thu, Sep 20, 2007 at 11:01 PM, in message
> > > < 116685ec0709202101o7142adabrc5fe851e54f6bca3@mail.gmail.com>,
> > > "Yogesh Arora"
> > > < yogesh.arora.daffodil@gmail.com> wrote:
> > > > Hello Kevin,
> > > > First of all, Thanks for your response.
> > > > The answer to your Questions
> > > >
> > > >>>>>What operating system?
> > > > I am using the Windows 2003 operating System.
> > > >>>>>What did you do to try to schedule these things?
> > > > I have created a Batch File of a Command to take the Back of the
> > > Database
> > > > specified. When i run this file through command Prompt, its run
> > > > successfully. But when i try to schedule it., It's not get scheduled
> > > and
> > > > does not show any errors.
> > >
> > > Exactly what are you doing to try to schedule it?
> > > How do you determine that it hasn't been scheduled?
> > >
> > > > Then i tried to schedule the direct SQL command , but the same
> > > result, not
> > > > being scheduled.
> > > >>>>What were you expecting to see as a result?
> > > > Expecting the results of the above.
> > > >>>>>>>What did you see, including exact error text, if any?
> > > > There are not any Error to
> > > show......................................
> > > >
> > > > The Query in Batch File is :-
> > > >
> > > > @echo off
> > > > "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U username -f
> > > > D:\test\test.sql -F p -C -d -D postgres
> > > >
> > > > The Password related info is being stored in the PgPass.conffile.......
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Best Regards,
> > Yogesh Arora
> > Mobile: 09255123173
> >
> >
>
>
> --
> Best Regards,
> Yogesh Arora
> Asst. Software Engg.
> Daffodil Software Pvt. Ltd.,
> Mobile: 09255123173
> Web : www.daffodildb.com
--
Best Regards,
Yogesh Arora
Asst. Software Engg.
Daffodil Software Pvt. Ltd.,
Mobile: 09255123173
Web : www.daffodildb.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-09-24 08:51 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-19 12:43 Schedules Running Problem yogesh.arora.daffodil@gmail.com
2007-09-20 17:34 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-09-21 14:12 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-09-24 04:00 ` Yogesh Arora <yogesh.arora.daffodil@gmail.com>
2007-09-24 07:36 ` Yogesh Arora <yogesh.arora.daffodil@gmail.com>
2007-09-24 08:51 ` Yogesh Arora <yogesh.arora.daffodil@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox