http://forums.enterprisedb.com/posts/list/9.page JForum - http://www.jforum.net The problem we are facing is how to create scheduled jobs in postgres as there are jobs in oracle.
Similar jobs is to be created in postgres.Is there any method of doing so?Please suggest or provide an alternate solution.

It is really urgent so do help.

Regards...
]]> http://forums.enterprisedb.com/posts/preList/1559/5447.page http://forums.enterprisedb.com/posts/preList/1559/5447.page GMT The problem we are facing is how to create scheduled jobs in postgres as there are jobs in oracle.
Similar jobs is to be created in postgres.Is there any method of doing so?Please suggest or provide an alternate solution.

It is really urgent so do help.

Regards...
[/quote]

Take a look at pgAgent:

http://www.pgadmin.org/download/pgagent.php
http://www.pgadmin.org/docs/1.8/pgagent.html
]]> http://forums.enterprisedb.com/posts/preList/1559/5448.page http://forums.enterprisedb.com/posts/preList/1559/5448.page GMT Can these jobs be properly scheduled and a function or porcedure can be called from these jobs?
]]> http://forums.enterprisedb.com/posts/preList/1559/5449.page http://forums.enterprisedb.com/posts/preList/1559/5449.page GMT [/quote]

Did you follow the installation instructions to run the pgagent.sql file? Note that pgAdmin will only add the node once it's treeview is refreshed - right-click the appropriate database node to do that.

[quote=Amrita_M]
Can these jobs be properly scheduled and a function or porcedure can be called from these jobs?
[/quote]

Depends what you mean by 'properly scheduled'. The point of the scheduler is to run the jobs at the required time - and yes, you can call functions from job steps.]]> http://forums.enterprisedb.com/posts/preList/1559/5450.page http://forums.enterprisedb.com/posts/preList/1559/5450.page GMT Now I have created a job after installing pgAgent.But now the problem is that the job is not getting executed at the scheduled time.Actually I have added the details in properties but the Statistics is not showing anything.

Can you tell me how to create the job.I want the job to execute a function in every 2-3 minutes.

Regards,
Amrita]]> http://forums.enterprisedb.com/posts/preList/1559/5453.page http://forums.enterprisedb.com/posts/preList/1559/5453.page GMT Now I have created a job after installing pgAgent.But now the problem is that the job is not getting executed at the scheduled time.Actually I have added the details in properties but the Statistics is not showing anything.

Can you tell me how to create the job.I want the job to execute a function in every 2-3 minutes.

Regards,
Amrita[/quote]

Did you put anything in the Host Agent field on the Job dialogue? If so, try removing it.]]> http://forums.enterprisedb.com/posts/preList/1559/5454.page http://forums.enterprisedb.com/posts/preList/1559/5454.page GMT ]]> http://forums.enterprisedb.com/posts/preList/1559/5455.page http://forums.enterprisedb.com/posts/preList/1559/5455.page GMT [/quote]

OK - thats the most common problem

What platform are you running on? If you restart pgAgent with '-l 2' (without the quotes) on the command line, that should give you lots of debugging info. On Windows, it'll go to the event log, or on *nix, it'll go to stdout. You can redirect to a logfile in that case with '-s log.txt'

]]> http://forums.enterprisedb.com/posts/preList/1559/5456.page http://forums.enterprisedb.com/posts/preList/1559/5456.page GMT That means may be the jobs are created but it is not running......
How to check it??
Plz do tell...]]> http://forums.enterprisedb.com/posts/preList/1559/5459.page http://forums.enterprisedb.com/posts/preList/1559/5459.page GMT That means may be the jobs are created but it is not running......
How to check it??
Plz do tell...[/quote]

The messages will go to the windows event log as I mentioned in my previous message. If you need to, set the debug level to 2 by removing the service and reinstalling it with -l 2 on the command line.]]> http://forums.enterprisedb.com/posts/preList/1559/5461.page http://forums.enterprisedb.com/posts/preList/1559/5461.page GMT Please suggest a possible solution for this.
]]> http://forums.enterprisedb.com/posts/preList/1559/5462.page http://forums.enterprisedb.com/posts/preList/1559/5462.page GMT Please suggest a possible solution for this.
[/quote]

Open the properties for the service, and enter the correct password for the username under which it will run.]]> http://forums.enterprisedb.com/posts/preList/1559/5463.page http://forums.enterprisedb.com/posts/preList/1559/5463.page GMT I have run this command
pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX hostaddr=localhost dbname=postgres user=postgres password=postgres

on the prompt and the service was created in the windows automatically,now when i am trying to start the service it is giving the error.]]> http://forums.enterprisedb.com/posts/preList/1559/5464.page http://forums.enterprisedb.com/posts/preList/1559/5464.page GMT I have run this command
pgAgent INSTALL pgAgent -l 2 -u postgres -p XXXX hostaddr=localhost dbname=postgres user=postgres password=postgres

on the prompt and the service was created in the windows automatically,now when i am trying to start the service it is giving the error.[/quote]

Windows is complaining about the password that you've written XXXX for in the command above. You need to ensure you get that right (if there are any space in it, quote it).]]> http://forums.enterprisedb.com/posts/preList/1559/5465.page http://forums.enterprisedb.com/posts/preList/1559/5465.page GMT We are using the following syntax:

pgAgent INSTALL pgAgent -l 2 -u postgres -p postgres hostaddr=localhost dbname=postgres user=postgres password=postgres


Please tell what does -u and -p signify?]]> http://forums.enterprisedb.com/posts/preList/1559/5466.page http://forums.enterprisedb.com/posts/preList/1559/5466.page GMT We are using the following syntax:

pgAgent INSTALL pgAgent -l 2 -u postgres -p postgres hostaddr=localhost dbname=postgres user=postgres password=postgres


Please tell what does -u and -p signify?[/quote]

The syntax looks correct. -u and -p are the options for the Windows username and password that the service will run as - this is documented at http://www.pgadmin.org/docs/1.8/pgagent.html.

The error you get when you try to start the service tells us that the value you pass in the -p option ('postgres') is not the correct password for the postgres windows user account (note that it is a separate password from the database one - the password= option - the two may be different).

If you need to change the windows password, you can do so by running the Computer Management tool found in the Administrative Tools folder, and modfying the user account there. If you do that, you will also need to update the password on the PostgreSQL service.]]> http://forums.enterprisedb.com/posts/preList/1559/5467.page http://forums.enterprisedb.com/posts/preList/1559/5467.page GMT I am still facing problem with starting of the application.It is giving Error:1069.The service could not start due to logon failure.

Please advice.]]> http://forums.enterprisedb.com/posts/preList/1559/5487.page http://forums.enterprisedb.com/posts/preList/1559/5487.page GMT

How to update the password on the postgresql?
Do i have to install it again?]]> http://forums.enterprisedb.com/posts/preList/1559/5488.page http://forums.enterprisedb.com/posts/preList/1559/5488.page GMT

How to update the password on the postgresql?
Do i have to install it again?[/quote]

To update the PostgreSQL service password, open the Services control panel applet, find the PostgreSQL server, right-click it and select properties. You can then change the password from there]]> http://forums.enterprisedb.com/posts/preList/1559/5489.page http://forums.enterprisedb.com/posts/preList/1559/5489.page GMT http://forums.enterprisedb.com/posts/preList/1559/5490.page http://forums.enterprisedb.com/posts/preList/1559/5490.page GMT
You must be mistyping the password. Try resetting it in Computer Management again, and then re-enter it for the PostgreSQL and pgAgent services.]]> http://forums.enterprisedb.com/posts/preList/1559/5491.page http://forums.enterprisedb.com/posts/preList/1559/5491.page GMT
]]> http://forums.enterprisedb.com/posts/preList/1559/5492.page http://forums.enterprisedb.com/posts/preList/1559/5492.page GMT
[/quote]

Have you looked in the event log? Are there any pgAgent events logged?]]> http://forums.enterprisedb.com/posts/preList/1559/5496.page http://forums.enterprisedb.com/posts/preList/1559/5496.page GMT http://forums.enterprisedb.com/posts/preList/1559/5505.page http://forums.enterprisedb.com/posts/preList/1559/5505.page GMT
The must be at least a message saying the service failed to start - the Windows service control manager will log that for *any* service that fails to start properly. Where are you looking exactly?]]> http://forums.enterprisedb.com/posts/preList/1559/5506.page http://forums.enterprisedb.com/posts/preList/1559/5506.page GMT I am just trying to insert one column in a table for testing it.]]> http://forums.enterprisedb.com/posts/preList/1559/5510.page http://forums.enterprisedb.com/posts/preList/1559/5510.page GMT I am just trying to insert one column in a table for testing it.[/quote]

Well, per my earlier messages, you need to run the scheduler in debug mode to get the debugging info we need. Let's try a quick run from the command line - assuming you used the service name 'pgAgent' - try the following from the command line:

- Stop the existing service:
[code]net stop pgAgent[/code]
- Change to the directory pgAgent is installed in:
[code]cd c:\path\to\the\pgagent\executable[/code]
- Start pgAgent in debug mode (amend the connection details as required):
[code]pgagent DEBUG pgAgent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgres port=5432[/code]

That should start pgAgent on the command line, and have it dump debug output to the console. If that tells you what is wrong, please try to fix it. Otherwise, please post the output here.


]]> http://forums.enterprisedb.com/posts/preList/1559/5511.page http://forums.enterprisedb.com/posts/preList/1559/5511.page GMT I want to import the oracle dump in the postgres database.There is a table in the database which has more than 2crores.When i am creating the insert query the file size is so huge that it is not opening.Please suggest as how to import the oracle dump directly.
]]> http://forums.enterprisedb.com/posts/preList/1559/5540.page http://forums.enterprisedb.com/posts/preList/1559/5540.page GMT I want to import the oracle dump in the postgres database.There is a table in the database which has more than 2crores.When i am creating the insert query the file size is so huge that it is not opening.Please suggest as how to import the oracle dump directly.
[/quote]

I'm afraid this is not something I'm able to help with. I would suggest trying the PostgreSQL mailing lists, or if you need more formal help, our services team may be able to provide assistance (see http://www.enterprisedb.com/tservices/professional_services.do) - they are very experienced with Oracle migrations.]]> http://forums.enterprisedb.com/posts/preList/1559/5541.page http://forums.enterprisedb.com/posts/preList/1559/5541.page GMT I am using this syntax to insert multiple rows in a table:

for i in 1..20000000 loop
insert into table_t(big_t) values(seq_big_t.nextval);
end loop;


Please tell the correct syntax as the above is not working.]]> http://forums.enterprisedb.com/posts/preList/1559/5543.page http://forums.enterprisedb.com/posts/preList/1559/5543.page GMT
When i am looking the output in the console it is not giving any error and shows that the table is analyzed but when i am writing the query

select last_analyze from pg_stat_user_tables where relname='tablename';
then it is not returning anything.

Please help]]> http://forums.enterprisedb.com/posts/preList/1559/5659.page http://forums.enterprisedb.com/posts/preList/1559/5659.page GMT I'm using windows and pgAgent, I've already a JOB, SCHEDULE, AND STEP...and the postgres job scheduler is automatic running on the services and Log on as ./postgres. Now, the problem is the JOB is not automatically running, is it meant that way?? but when i run this in the cmd:

pgagent DEBUG pgAgent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgres port=5432

the JOB is automatically doing the STEP...here is the result of the DEBUG

http://privatepaste.com/ddNjdVWbpW

do i REALLY need to run that command for me to automatically do the job?? If yes, then how can I hide the "password" i've editted the the pgpass.conf but i dont know how can i hide the password. If No, what's wrong with the method that I've used.

Thanks,
Gerard]]> http://forums.enterprisedb.com/posts/preList/1559/6585.page http://forums.enterprisedb.com/posts/preList/1559/6585.page GMT ]]> http://forums.enterprisedb.com/posts/preList/1559/12914.page http://forums.enterprisedb.com/posts/preList/1559/12914.page GMT