[GENERAL] PostgreSQL to Oracle
Hi All, I want to migrate from PostgreSQL to Oracle and need any tool preferably open source. And I am specially concerned with stored procedures / functions. Regards, Abdul Rehman.
[GENERAL] Oracle Functions to PostgreSQL
Hi all, Is there any preferably open source tool to convert Oracle Functions to PostgreSQL Functions. Thanks, Abdul Rehman.
Re: [GENERAL] Download link for 'Bristlecone'
Thanks Huxton & Gerd; I think pgbench is not suitable for those who want to test application on desired tables. pgbench is highly hard coded and tests only self generated tables. I used Mercury LoadRunner but it is not freeware. The link http://bristlecone.continuent.org/HomePage only has details about this software but not the download link. Secondly it is for Unix not for Windows. And I found AppLoader freeware but it does not include PostgreSQL in its database list. My research is ongoiung and will prompt you as I get something fruitful and expecting the same from you. Regards, Abdul Rehman. From: Richard Huxton To: Abdul Rahman Cc: pgsql-general@postgresql.org; ashis...@synechron.com Sent: Wednesday, February 18, 2009 2:13:27 PM Subject: Re: [GENERAL] Download link for 'Bristlecone' Abdul Rahman wrote: > Dear All, > > I searched a lot but failed to find any download link for Bristlecone. Kindly > help me. Or let me know about any open source Load Tester for PostgreSQL > based application. > Ashish, according to my search Bristlecone is open source. Thanks in advance. Sorry - never heard of Bristlecone. You might want to start with "pgbench" which is in the contrib/ directory of the source distribution: http://www.postgresql.org/docs/current/static/pgbench.html Make sure you read the manual page above, and also search the mailing-list archives for tips on how to get useful information from it. You might also be interested in the sourceforge DBT project http://sourceforge.net/projects/osdldbt/ Read this msg first though, there is more up-to-date code available than the sf.net download page. http://archives.postgresql.org/pdxpug/2008-12/msg00010.php Really though, unless you're doing this as part of an academic paper you'll want to write your own test cases. It doesn't matter whether PostgreSQL is fast or slow on the tests above, what matters is how it performs *for your purposes*. The only way to test that is to generate the sort of data and workload that you plan to have. Oh, and it's very easy to end up with data that tells you nothing useful. Make sure your tests are long enough, and that they're not too sensitive to minor changes in configuration or load. HTH -- Richard Huxton Archonet Ltd
Re: [GENERAL] Appending \o output instead of overwriting the output file
Simply use '\o filename' as you are doing so. Write the queries as much as you want. It will automatically append the result in the specified file. Untill you use '\o' command again with new file name.
[GENERAL] Download link for 'Bristlecone'
Dear All, I searched a lot but failed to find any download link for Bristlecone. Kindly help me. Or let me know about any open source Load Tester for PostgreSQL based application. Ashish, according to my search Bristlecone is open source. Thanks in advance. Regards, Abdul Rehman.
[GENERAL] Load Testing
Hi all, Can any body tell me about tool for PostgreSQL load testing preferably freeware. Regards, Abdul Rehman.
Re: [GENERAL] password for postgres
Kindly let me know two things to answer you. First, Are you trying to start postgres service or psql prompt? second, what OS is in your use.
Re: [GENERAL] Multiple postgres.exe On Processes
Dear All, Thanks John R Pierce for replying fruitful text. I wold like to add some text in your reply from PostgreSQL document for further clarification. i.e. Each connection runs one process, plus the 3 master processes for the postmaster, the writer, etc. with two logins, I'd expect to see 5 processes. with 102 concurrent logins, 105 processes.[From Pierce] The PostgreSQL server can handle multiple concurrent connections from clients. For that purpose it starts (“forks”) a new process for each connection. From that point on, the client and the new server process communicate without intervention by the original postgres process. Thus, the master server process is always running, waiting for client connections, whereas client and associated server processes come and go.[From PostgreSQL Document] Thanks all. Regards, Abdul Rehman
[GENERAL] Multiple postgres.exe On Processes
Dear All, I have fear that sufficient increase in number of postgres.exe after one or two logins on servers may down the speed of the server or even server. Is there any solution or technique to overcome this overhead. Regards, Abdul Rehman.
Re: [GENERAL] Key Vs Index
I have found the answer. PostgreSQL creates index on primary key implicitly and can be seen via \d tablename; command on psql prompt. But PG_Admin-III does not show this index. Sorry to say that I faced several problems because of PG_Admin-III. And I advise you to use psql prompt instead of GUI. From: Abdul Rahman To: pgsql-general@postgresql.org Sent: Wednesday, February 11, 2009 12:09:25 PM Subject: Key Vs Index In Oracle, the index is automatically created during the creation of Primary Key. But in PostgreSQL either index is implicitly created of the user hast create it explicitly. I don't find any index against Primary Key and have to create index on this key.
[GENERAL] Key Vs Index
In Oracle, the index is automatically created during the creation of Primary Key. But in PostgreSQL either index is implicitly created of the user hast create it explicitly. I don't find any index against Primary Key and have to create index on this key.
Re: [GENERAL] Rollback of Query Cancellation
Well Jaime, I executed all the delete queries one by one. Now I am unable to understand that why it took sufficient time to run the last query before cancellation. i.e. delete from ci_cif_v where req_id='0824100207'; This morning it performed the delete operation and deleted certain number of rows within few seconds. Then what it was doing yesterday. Here it seems that it was performing something else (as guessed by Sim Zacks) before the execution of delete query. And when I canceled, the query was not executed till that time. Then why it didn't take sufficient amount of time to perform something else before the execution of same query today. From: Jaime Casanova To: Abdul Rahman Cc: pgsql-general@postgresql.org Sent: Wednesday, January 28, 2009 12:20:41 PM Subject: Re: Rollback of Query Cancellation On Wed, Jan 28, 2009 at 2:10 AM, Abdul Rahman wrote: > Thanks Jaime, > Plz consider the actual log files to explore the issue in detail. Because I > have pasted the log files of client machine, I am using (sorry). > > > 2009-01-27 18:29:25 STATEMENT: delete from ci_cin_type_v where > req_id='0824100207' > delete from ci_cust_type_v where req_id='0824100207' > delete from ci_dependents_v where req_id='0824100207' > delete from ci_employer_v where req_id='0824100207' > delete from ci_cor_sig_v where req_id='0824100207' > delete from ci_corporate_v where req_id='0824100207' > delete from ci_individual_v where req_id='0824100207' > delete from ci_cif_v where req_id='0824100207' then you have a lot of deletes, are there executing inside a transaction? are you calling a trigger? > 2009-01-27 18:29:41 ERROR: relation "ci_cust_type_v" does not exist this table does not exist > 2009-01-27 18:29:41 STATEMENT: delete from ci_cust_type_v where > req_id='0824100207' > 2009-01-27 18:52:08 LOG: could not receive data from client: No connection > could be made because the target machine actively refused it. > 2009-01-27 18:52:08 LOG: unexpected EOF on client connection > 2009-01-27 18:52:08 LOG: could not receive data from client: No connection > could be made because the target machine actively refused it. > 2009-01-27 18:52:08 LOG: unexpected EOF on client connection > guess this messages are received after the CANCEL QUERY if the series of deletes are all executed inside a transaction then they all were rollback if not only the last one (the one that generates the error) was rolledback -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
Re: [GENERAL] Rollback of Query Cancellation
Very nice! Most probably it was waiting for something else. This is the reason the query executed today and clearly showed certain number of rows deleted. But what ELSE? From: Sim Zacks To: Abdul Rahman Sent: Wednesday, January 28, 2009 12:08:28 PM Subject: Re: [GENERAL] Rollback of Query Cancellation -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Its very possible that the reason that the query was because there was a lock on the table. If you run select * from pg_stat_activity while the query is running there is a waiting flag that indicates whether your query is actually being executed or if it is waiting for something else. Sim Abdul Rahman wrote: > Dear All, > > Yesterday I canceled a running query because it was taking long time > (more than 12 minutes) to delete lots of records. Today when I executed > the same query it hardly took few seconds to finish. It clearly explores > that PostgreSQL does not perform rollback action. Is it true? > > Regards, > Abdul Rehman. > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkmABGwACgkQjDX6szCBa+oOzwCguiRslM90EAKY/wo34htqtXUH hWIAoLkALRcBYEJ7jW5ordKRX73jqyR9 =TqIi -END PGP SIGNATURE-
Re: [GENERAL] Rollback of Query Cancellation
Thanks Jaime, Plz consider the actual log files to explore the issue in detail. Because I have pasted the log files of client machine, I am using (sorry). 2009-01-27 18:29:25 STATEMENT: delete from ci_cin_type_v where req_id='0824100207' delete from ci_cust_type_v where req_id='0824100207' delete from ci_dependents_v where req_id='0824100207' delete from ci_employer_v where req_id='0824100207' delete from ci_cor_sig_v where req_id='0824100207' delete from ci_corporate_v where req_id='0824100207' delete from ci_individual_v where req_id='0824100207' delete from ci_cif_v where req_id='0824100207' 2009-01-27 18:29:41 ERROR: relation "ci_cust_type_v" does not exist 2009-01-27 18:29:41 STATEMENT: delete from ci_cust_type_v where req_id='0824100207' 2009-01-27 18:52:08 LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2009-01-27 18:52:08 LOG: unexpected EOF on client connection 2009-01-27 18:52:08 LOG: could not receive data from client: No connection could be made because the target machine actively refused it. 2009-01-27 18:52:08 LOG: unexpected EOF on client connection Here, I am talking about the last query (Bold_Italic). Now my question is still stands. Kindly continue to up your valuable text. From: Jaime Casanova To: Abdul Rahman Cc: pgsql-general@postgresql.org Sent: Wednesday, January 28, 2009 11:38:59 AM Subject: Re: Rollback of Query Cancellation On Wed, Jan 28, 2009 at 1:29 AM, Abdul Rahman wrote: > Welcome Jcasanov, > > Here is the output of the log files: > > 2009-01-27 09:24:18 FATAL: the database system is starting up > 2009-01-27 09:24:19 LOG: database system was shut down at 2009-01-26 > 18:34:53 > 2009-01-27 09:24:19 LOG: checkpoint record is at 0/1B9F92C8 > 2009-01-27 09:24:19 LOG: redo record is at 0/1B9F92C8; undo record is at > 0/0; shutdown TRUE > 2009-01-27 09:24:19 LOG: next transaction ID: 0/335372; next OID: 19380 > 2009-01-27 09:24:19 LOG: next MultiXactId: 1; next MultiXactOffset: 0 > 2009-01-27 09:24:19 LOG: database system is ready all these messages are 'cause the database is starting up > 2009-01-27 18:52:43 LOG: received fast shutdown request > 2009-01-27 18:52:44 LOG: shutting down > 2009-01-27 18:52:44 LOG: database system is shut down > 2009-01-27 18:52:44 LOG: logger shutting down > the database was shutting down > and > > 2009-01-28 09:42:14 FATAL: the database system is starting up > 2009-01-28 09:42:14 LOG: database system was shut down at 2009-01-27 > 18:52:44 > 2009-01-28 09:42:14 LOG: checkpoint record is at 0/1B9F9368 > 2009-01-28 09:42:14 LOG: redo record is at 0/1B9F9368; undo record is at > 0/0; shutdown TRUE > 2009-01-28 09:42:14 LOG: next transaction ID: 0/336490; next OID: 19380 > 2009-01-28 09:42:14 LOG: next MultiXactId: 1; next MultiXactOffset: 0 > 2009-01-28 09:42:15 LOG: database system is ready > 2009-01-28 09:42:15 FATAL: the database system is starting up > starting up again none of these are saying the time for some records being deleted, read my prior post about why is not possible that message (commit never executed) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
Re: [GENERAL] Rollback of Query Cancellation
Welcome Jcasanov, Here is the output of the log files: 2009-01-27 09:24:18 FATAL: the database system is starting up 2009-01-27 09:24:19 LOG: database system was shut down at 2009-01-26 18:34:53 2009-01-27 09:24:19 LOG: checkpoint record is at 0/1B9F92C8 2009-01-27 09:24:19 LOG: redo record is at 0/1B9F92C8; undo record is at 0/0; shutdown TRUE 2009-01-27 09:24:19 LOG: next transaction ID: 0/335372; next OID: 19380 2009-01-27 09:24:19 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2009-01-27 09:24:19 LOG: database system is ready 2009-01-27 18:52:43 LOG: received fast shutdown request 2009-01-27 18:52:44 LOG: shutting down 2009-01-27 18:52:44 LOG: database system is shut down 2009-01-27 18:52:44 LOG: logger shutting down and 2009-01-28 09:42:14 FATAL: the database system is starting up 2009-01-28 09:42:14 LOG: database system was shut down at 2009-01-27 18:52:44 2009-01-28 09:42:14 LOG: checkpoint record is at 0/1B9F9368 2009-01-28 09:42:14 LOG: redo record is at 0/1B9F9368; undo record is at 0/0; shutdown TRUE 2009-01-28 09:42:14 LOG: next transaction ID: 0/336490; next OID: 19380 2009-01-28 09:42:14 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2009-01-28 09:42:15 LOG: database system is ready 2009-01-28 09:42:15 FATAL: the database system is starting up
Re: [GENERAL] Rollback of Query Cancellation
Thanks Justin, Answers of your technical questions are as under: What does the sql statement look like? delete from ci_cif_v where req_id='0824100207'; Where was the statement run? On SQL pan of pgAdmin-III How was the statement killed? By clicking the Cancel Query button -> What do the logs show? Message just showed the time it took to delete certain number of records.
[GENERAL] Rollback of Query Cancellation
Dear All, Yesterday I canceled a running query because it was taking long time (more than 12 minutes) to delete lots of records. Today when I executed the same query it hardly took few seconds to finish. It clearly explores that PostgreSQL does not perform rollback action. Is it true? Regards, Abdul Rehman.
Re: [GENERAL] autovacuum daemon
Thanks Ray, Your solution of using ps command is for Linux but I am using WinXp. That is why it confused me. Regards, Abdul Rehman.
Re: [GENERAL] autovacuum daemon
Dear All, Thanks for fruitful replies. But I checked it by running ANALYZE on psql. First updated 1 rows in a table and got certain number of dead rows in result of ANALYZE. After few minutes the number of dead rows becomes zero which assured me that AUTOVACUUM is running in background. Now, kindly let me know the detail about the solution send by Ray, i.e. ps ax | grep postgres Regards, Abdul Rehman.
[GENERAL] autovacuum daemon
Deal All, I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not. Regards, Avdul Rehman.
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
That's it! Arora your document (http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than the best. The error was of postgress user rights and nothing else. After granting rights to postgres Its really running well. Thanks. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. Date: Wed, 26 Nov 2008 23:43:25 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc Date: Tue, 25 Nov 2008 02:32:46 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. Date: Mon, 24 Nov 2008 23:23:15 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it! Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
I have found via cmd prompt. My Computer (GUI) is not showing the path and file (pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in this file. - Forwarded Message From: Abdul Rahman <[EMAIL PROTECTED]> To: Vishal Arora <[EMAIL PROTECTED]>; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Friday, November 28, 2008 10:12:23 AM Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running I searched but didn't find any pgpass.conf file. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. Date: Wed, 26 Nov 2008 23:43:25 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc Date: Tue, 25 Nov 2008 02:32:46 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. Date: Mon, 24 Nov 2008 23:23:15 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it! Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
I searched but didn't find any pgpass.conf file. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Thursday, November 27, 2008 5:27:26 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Well in that case you need to check if you have relevant entries in pgpass.conf file. Date: Wed, 26 Nov 2008 23:43:25 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc Date: Tue, 25 Nov 2008 02:32:46 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. Date: Mon, 24 Nov 2008 23:23:15 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it! Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
Thanks Vishal, I followed the document and now the statistics of the job is appearing and showing successful but actually backup is not made via this job. In output tab it gives the following error: could not open the file "D:\xxx.backup":Permission denied. I tried to perform the task from both (normal & postgres) users of OS. But no benefit. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, November 26, 2008 10:25:11 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Try to follow the steps given in following link - http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc Date: Tue, 25 Nov 2008 02:32:46 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. Date: Mon, 24 Nov 2008 23:23:15 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now! Free up your senses. Experience reality up close on MSN video Try it!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
Service is running. After getting frustrated I dropped the pgagent schema and reworked. But the result is same. ???. Even entries in the concerned pga_tables is also very clear. Perhaps the trigger is not working . From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:08:05 PM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running Is the service running properly, try to schedule a new job and see the results. Date: Mon, 24 Nov 2008 23:23:15 -0800 From: [EMAIL PROTECTED] Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running To: [EMAIL PROTECTED]; [EMAIL PROTECTED] CC: pgsql-general@postgresql.org No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now! Calling TV buffs! Get TV listings, gossip on your fave stars and updates on hot new shows Try it now!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
No error message appeared. Because NOstatistics is available for the job. It reflects that it is not running. - Forwarded Message From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
Re: [GENERAL] [ADMIN] PgAgent Job Scehduler is NOT running
No error message appeared. Because statistics is available for the job. It reflects that it is not running. From: Vishal Arora <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 11:47:33 AM Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT running What is the error message you are getting. What is the interval you have set for scheduling the job. Date: Sun, 23 Nov 2008 23:51:46 -0800 From: [EMAIL PROTECTED] Subject: [ADMIN] PgAgent Job Scehduler is NOT running To: pgsql-general@postgresql.org CC: [EMAIL PROTECTED] Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman. Team India gets set to thwart Australia's quest for the final frontier. Catch the action on MSN Try it now!
[GENERAL] PgAgent Job Scehduler is NOT running
Dear all, I installed PgAgent and started its service and successfully scheduled a backup and got 100% result. Now the same Job is not working even I reinstalled PgAgent but failed to get result. Regards, Abdul Rehman.
Re: [GENERAL] Scheduling backup via PgAgent
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.
[GENERAL] 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
Re: [GENERAL] Replication with slony-I
TOO MANY THANKS RAY! I have got success in doing replication to an existing database. I did test on a dummy databases. But I am sure that I can implement to live project. Regards, Abdul Rehman.
Re: [GENERAL] Replication with slony-I
The detail of my work is as under: As I mentioned earlier that platform is windows xp and using postgres 8.2 in which Slony- I is included. And all databases are at localhost. After reading the document entitled “Replicating Your First Database” which is for Linux I optimized the instructions for windows and performed the following tasks: I didn’t find any line like tcpip_socket=true in my postgresql.conf. Because there is another option and i.e. listen_addresses = '*'. I changed it to listen_addresses = 'localhost'. In pg_hba.conf, I changed the line host all all 127.0.0.1/32 md5 To host all all 127.0.0.1/32 trust Then created 2 databases named: master and slave Executed the command pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME After optimizing it i.e.: pgbench -i -s 1 -U postgres -h localhost master Slony-I does not automatically copy table definitions from a master when a slave subscribes to it, so we need to import this data. I did this with pg_dump. pg_dump -s -U postgres -h localhost master > schema.sql psql -U postgres -h localhost slave < schema.sql Executed the command: pgbench -s 1 -c 5 -t 1000 -U postgres -h localhost master Optimized the given script (and used slonik to run this) as follows: cluster name = pgbench; node 1 admin conninfo = 'dbname=master host=localhost user=postgres'; node 2 admin conninfo = 'dbname=slave host=localhost user=postgres'; init cluster ( id=1, comment = 'Master Node'); table add key (node id = 1, fully qualified name = 'public.history'); create set (id=1, origin=1, comment='All pgbench tables'); set add table (set id=1, origin=1, id=1, fully qualified name = 'public.accounts', comment='accounts table'); set add table (set id=1, origin=1, id=2, fully qualified name = 'public.branches', comment='branches table'); set add table (set id=1, origin=1, id=3, fully qualified name = 'public.tellers', comment='tellers table'); set add table (set id=1, origin=1, id=4, fully qualified name = 'public.history', comment='history table', key = serial); store node (id=2, comment = 'Slave node'); store path (server = 1, client = 2, conninfo='dbname=master host=localhost user=postgres'); store path (server = 2, client = 1, conninfo='dbname=slave host=localhost user=postgres'); store listen (origin=1, provider = 1, receiver =2); store listen (origin=2, provider = 2, receiver =1); On MASTERHOST (localhost) the command to start the replication executed the command: slon pgbench "dbname=master user=postgres host=localhost" On SLAVEHOST (localhost) the command to start the replication executed the command: slon pgbench "dbname=slave user=postgres host=localhost" To start replicating the 4 pgbench tables (set 1) from the master (node id 1) the the slave (node id 2), executed the following script: cluster name = pgbench; node 1 admin conninfo = 'dbname=master host=localhost user=postgres'; node 2 admin conninfo = 'dbname=slave host=localhost user=postgres'; subscribe set ( id = 1, provider = 1, receiver = 2, forward = no); Got SUCCESS up to this point. Now I think this is pgbench which is responsible for replicating tables. Now my question is that how to include the tables which are already present in an existing database
Re: [GENERAL] Replication with slony-I
Ok Ray! I will send the detail of my work soon. Thanks to All participants.
Re: [GENERAL] Replication with slony-I
The link of the document, entitled "Replicating Your First Database" is as under: http://slony1.projects.postgresql.org/slony1-1.2.6/doc/adminguide/firstdb.html
Re: [GENERAL] Replication with slony-I
I followed the document entitled entitled "Replicating your first database" and got SUCCESS In implementing the given example. But, the implementation on existing database is not working for the tables already exists in the database. The replication is being only among four tables created via pgbench tool (accounts, history, branches, tellers). whats going on! --- On Tue, 10/28/08, Abdul Rahman <[EMAIL PROTECTED]> wrote: From: Abdul Rahman <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Replication with slony-I To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Date: Tuesday, October 28, 2008, 9:05 AM Thanks a lot Ray! I have found the document and going to follow this. If I face any difficulty then will prompt to archive. Regards, Abdul. --- On Mon, 10/27/08, Raymond O'Donnell <[EMAIL PROTECTED]> wrote: From: Raymond O'Donnell <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Replication with slony-I To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Date: Monday, October 27, 2008, 7:17 PM On 27/10/2008 11:17, Abdul Rahman wrote: > May any one support step by step procedure for the replication with > slony-I in windows xp. There's a pretty good step-by-step guide in the Slony documentation - I haven't it to hand, but it's entitled "Replicating your first database" or something like that. As I recall, it's based on a *nix setup, but Windows is mentioned too. Off the top of my head, the only major difference is that instead of running a separate slon daemon for each node, on Windows you run a single slon as a service, and then invoke it with "/addengine" for each node...it's all in the docs. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals --
Re: [GENERAL] Replication with slony-I
Thanks a lot Ray! I have found the document and going to follow this. If I face any difficulty then will prompt to archive. Regards, Abdul. --- On Mon, 10/27/08, Raymond O'Donnell <[EMAIL PROTECTED]> wrote: From: Raymond O'Donnell <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Replication with slony-I To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Date: Monday, October 27, 2008, 7:17 PM On 27/10/2008 11:17, Abdul Rahman wrote: > May any one support step by step procedure for the replication with > slony-I in windows xp. There's a pretty good step-by-step guide in the Slony documentation - I haven't it to hand, but it's entitled "Replicating your first database" or something like that. As I recall, it's based on a *nix setup, but Windows is mentioned too. Off the top of my head, the only major difference is that instead of running a separate slon daemon for each node, on Windows you run a single slon as a service, and then invoke it with "/addengine" for each node...it's all in the docs. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals --
[GENERAL] Replication with slony-I
May any one support step by step procedure for the replication with slony-I in windows xp.
Re: [GENERAL] Replication using slony-I
Dear all, Due to personal reason (to celebrate EID) I will rejoin my work from 06-Oct-2008. Regards, Abdul Rehman
Re: [GENERAL] Replication using slony-I
How will I get know that all slons are running? However in the replication "pgbench" properties the value of Slon PID is Not Running in each node. Yes, every node is listed with its path and listen. And what do you mean by "do you see the connections on each node". Thanks Glyn Astill. --- On Tue, 9/30/08, Glyn Astill <[EMAIL PROTECTED]> wrote: From: Glyn Astill <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Replication using slony-I To: pgsql-general@postgresql.org, [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Date: Tuesday, September 30, 2008, 1:36 PM > From: Abdul Rahman <[EMAIL PROTECTED]> > Dear All, > > I worked again from very start and faced the same problem > which encountered earlier. > In order to perform replication. I am following the steps > present in > > http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html > > and > successfully reached to step # 13. I have Slony-I > pgAdmin-III included > in postgresql-8.2 and the platform is WindowsXp. But here I > am not > getting the "NewSubscription" option when do > right click on > Subscription Set. > Are all the slons running, and do you see the connections on each node. Under the pgAdmin replication->nodes tab on every node do you see every node listed allong with it's paths and listens.
Re: [GENERAL] Replication using slony-I
Dear All, I worked again from very start and faced the same problem which encountered earlier. In order to perform replication. I am following the steps present in http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set. --- On Tue, 9/30/08, Abdul Rahman <[EMAIL PROTECTED]> wrote: From: Abdul Rahman <[EMAIL PROTECTED]> Subject: Re: [GENERAL] Replication using slony-I To: pgsql-general@postgresql.org Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Tuesday, September 30, 2008, 9:55 AM Thanks a lot for replying! Here is complete information for consideration: In order to perform replication. I am following the steps present in http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set. I also worked and found that the command in step # 4 >psql -U postgres slave1 < schema.sql is not working because I am not getting the tables in either slave. So, I suppose I have to run the command in step # 2 > pgbench -i -U postgres master for slave1 and slave2 instead of making sql script and running it. I am going to restart my work in this way. Glyn Astill you may explore slonik in detail that I may use it now. So many Thanks Again.
Re: [GENERAL] Replication using slony-I
Thanks a lot for replying! Here is complete information for consideration: In order to perform replication. I am following the steps present in http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set. I also worked and found that the command in step # 4 >psql -U postgres slave1 < schema.sql is not working because I am not getting the tables in either slave. So, I suppose I have to run the command in step # 2 > pgbench -i -U postgres master for slave1 and slave2 instead of making sql script and running it. I am going to restart my work in this way. Glyn Astill you may explore slonik in detail that I may use it now. So many Thanks Again.
Re: [GENERAL] Replication using slony-I
I am not getting the "New Subscription" option when do right click on subscription (0) on the master node.
[GENERAL] Replication using slony-I
Hi all, I am following the steps present in this link: http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html But failed to complete step # 13. Here I am unable to get CREATE NEW SUBSCRIPTION. Can any body guide me plz.