Scheduled Jobs in Postgres.

Amrita_M wrote:Please can you tell the exact syntax for it.
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?

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.

Hi
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.

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.

How to update the password on the postgresql?
Do i have to install it again?

Amrita_M wrote: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.

How to update the password on the postgresql?
Do i have to install it again?

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

I have tried chaning the password by going to service.msc and right clicking on PostgreSQL Database Server 8.2,selecting properties and in log on changing the password but now when I am starting the database service the error is coming here also.Now i am unable to connect to database and don't have the dump also..I am stuck...Please help

Amrita_M wrote:I have tried chaning the password by going to service.msc and right clicking on PostgreSQL Database Server 8.2,selecting properties and in log on changing the password but now when I am starting the database service the error is coming here also.Now i am unable to connect to database and don't have the dump also..I am stuck...Please help

You must be mistyping the password. Try resetting it in Computer Management again, and then re-enter it for the PostgreSQL and pgAgent services.

ok..let me try again...now i have chosen the option of local computer and it started but when i am trying to start the pg agent it is giving an error 1053:The service did not respond to the start or control request in a timely fashion

Amrita_M wrote:ok..let me try again...now i have chosen the option of local computer and it started but when i am trying to start the pg agent it is giving an error 1053:The service did not respond to the start or control request in a timely fashion

Have you looked in the event log? Are there any pgAgent events logged?

I could not find any log.I tried to do everything instructed but still its not working.It seems there is no way out for creating the scheduled jobs.

Amrita_M wrote:I could not find any log.I tried to do everything instructed but still its not working.It seems there is no way out for creating the scheduled jobs.

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?

In the services.msc the service has started but when I am creating job in the pgAdmin then it is not running and not displaying any status also.Where to check that?
I am just trying to insert one column in a table for testing it.

Amrita_M wrote:In the services.msc the service has started but when I am creating job in the pgAdmin then it is not running and not displaying any status also.Where to check that?
I am just trying to insert one column in a table for testing it.

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:

- Change to the directory pgAgent is installed in:

- Start pgAgent in debug mode (amend the connection details as required):

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.

I have now created the scheduled jobs through java application.I need one more help regarding the testing of application.
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.

Amrita_M wrote:I have now created the scheduled jobs through java application.I need one more help regarding the testing of application.
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.

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.

Please can u tell me the syntax of for loop.
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.

Hi there is another query about analyzing tables from the java application,can we analyze the tables by writing statements in the application.I am trying to analyze by executing a query in the application stating analyze tablename.

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

Hi,
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