X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AE8FA9DC943 for ; Tue, 27 Dec 2005 07:29:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70022-05 for ; Tue, 27 Dec 2005 07:29:06 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 63D629DC81E for ; Tue, 27 Dec 2005 07:29:01 -0400 (AST) Received: from sobha_mail.renaissance-it.com (unknown [164.164.87.55]) by svr4.postgresql.org (Postfix) with ESMTP id A55985AFC01 for ; Tue, 27 Dec 2005 11:29:03 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C60AD9.21933E8D" Subject: How to run a posgresql function/procedure thro crontab in Linux ES 4.0 Date: Tue, 27 Dec 2005 17:01:51 +0530 Message-ID: <038D31443AEF2040BC33D56D85DFD49A0118CE2D@sobha_mail.renaissance-it.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to run a posgresql function/procedure thro crontab in Linux ES 4.0 Thread-Index: AcYK2SA4XiAxRg95QPap0SwlCPjbmg== From: "Murugan G" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/319 X-Sequence-Number: 20039 This is a multi-part message in MIME format. ------_=_NextPart_001_01C60AD9.21933E8D Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 SGVsbG8sDQpJZiBhbnlib2R5IHRyaWVkLCBwbGVhc2UgbGV0IG1lIGtub3cgaG93IHRvIHJ1biBh IHBvc3RncmVzUUwgZnVuY3Rpb24vcHJvY2VkdXJlIHRocm8gY3JvbnRhYiBpbiBMaW51eCBFUyA0 LjANCg0KVGhhbmtzIGFuZCByZWdhcmRzLA0KRy5NdXJ1Z2FuLA0KU3IuIFNvZnR3YXJlIEVuZ2lu ZWVyLg0KRXh0bi4gMTY1OA0KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQpTb2JoYSBSZW5haXNzYW5jZSBJ bmZvcm1hdGlvbiBUZWNobm9sb2d5IFByaXZhdGUgTGltaXRlZA0KQW4gU0VJLUNNTSAmIFAtQ01N IExldmVsIDUgQ29tcGFueQ0KV29ybGQncyAxc3QgU1NFLUNNTSBMZXZlbCA1IENvbXBhbnkNCkJT IDc3OTkgY2VydGlmaWVkIGJ5IEJyaXRpc2ggU3RhbmRhcmRzIEluc3RpdHV0ZQ0KSVNPIDkwMDE6 MjAwMCBDZXJ0aWZpZWQgYnkgVMOcViBSaGVpbmxhbmQvQmVybGluLUJyYW5kZW5idXJnDQpBIFNp eCBTaWdtYSBQcmFjdGljZSBDb21wYW55IA0KVGVsOiArIDkxIDgwIDUxOTUxOTk5OyBGYXg6ICsg OTEgODAgNTE1MjMzMDA7IFZpZGVvIENvbmZlcmVuY2U6ICsgOTEgODAgNTEyNTIyMjIgDQpFbWFp bCA6IG11cnVnYW4uZ0ByZW5haXNzYW5jZS1pdC5jb207IFdlYjogd3d3LnJlbmFpc3NhbmNlLWl0 LmNvbQ0KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09DQpUaGUgaW5mb3JtYXRpb24gdHJhbnNtaXR0ZWQgaXMg aW50ZW5kZWQgb25seSBmb3IgdGhlIHBlcnNvbiBvciBlbnRpdHkgdG8gd2hpY2ggaXQgaXMgYWRk cmVzc2VkIGFuZCBtYXkgY29udGFpbiBjb25maWRlbnRpYWwgYW5kL29yIHByaXZpbGVnZWQgbWF0 ZXJpYWwuIEFueSByZXZpZXcsIHJldHJhbnNtaXNzaW9uLCBkaXNzZW1pbmF0aW9uIG9yIG90aGVy IHVzZSBvZiwgb3IgdGFraW5nIG9mIGFueSBhY3Rpb24gaW4gcmVsaWFuY2UgdXBvbiwgdGhpcyBp bmZvcm1hdGlvbiBieSBwZXJzb25zIG9yIGVudGl0aWVzIG90aGVyIHRoYW4gdGhlIGludGVuZGVk IHJlY2lwaWVudCBpcyBwcm9oaWJpdGVkLiBJZiB5b3UgcmVjZWl2ZWQgdGhpcyBpbiBlcnJvciwg cGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVsZXRlIGFsbCBjb3BpZXMgZnJvbSBhbnkg Y29tcHV0ZXIuDQoNCg0K ------_=_NextPart_001_01C60AD9.21933E8D Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0iTVMg RXhjaGFuZ2UgU2VydmVyIHZlcnNpb24gNi4wLjY2MDMuMCI+DQo8VElUTEU+SG93IHRvIHJ1biBh IHBvc2dyZXNxbCBmdW5jdGlvbi9wcm9jZWR1cmUgdGhybyBjcm9udGFiIGluIExpbnV4IEVTIDQu MDwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCjwhLS0gQ29udmVydGVkIGZyb20gdGV4dC9ydGYg Zm9ybWF0IC0tPg0KDQo8UD48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPkhlbGxvLDwvRk9OVD4N Cg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+SWYgYW55Ym9keSB0cmllZCwgcGxlYXNl IGxldCBtZSBrbm93IGhvdyB0byBydW4gYSBwb3N0Z3Jlc1FMIGZ1bmN0aW9uL3Byb2NlZHVyZSB0 aHJvIGNyb250YWIgaW4gTGludXggRVMgNC4wPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBDT0xP Uj0iIzAwMDAwMCIgU0laRT0yIEZBQ0U9IkFyaWFsIj5UaGFua3MgYW5kIHJlZ2FyZHMsPC9GT05U Pg0KDQo8QlI+PEZPTlQgQ09MT1I9IiMwMDAwMDAiIFNJWkU9MiBGQUNFPSJBcmlhbCI+Ry5NdXJ1 Z2FuLDxCUj4NClNyLiBTb2Z0d2FyZSBFbmdpbmVlci48L0ZPTlQ+DQoNCjxCUj48Rk9OVCBDT0xP Uj0iIzAwMDAwMCIgU0laRT0yIEZBQ0U9IkFyaWFsIj5FeHRuLiAxNjU4PC9GT05UPg0KDQo8QlI+ PEZPTlQgQ09MT1I9IiMwMDAwMDAiIFNJWkU9MiBGQUNFPSJBcmlhbCI+PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PEJSPg0KU29iaGEgUmVuYWlzc2FuY2UgSW5mb3JtYXRpb24gVGVjaG5vbG9neSBQcml2YXRl IExpbWl0ZWQ8QlI+DQo8L0ZPTlQ+PEZPTlQgQ09MT1I9IiMwMDAwMDAiIFNJWkU9MiBGQUNFPSJB cmlhbCI+QW4gU0VJLUNNTSAmYW1wOyBQLUNNTSBMZXZlbCA1IENvbXBhbnk8L0ZPTlQ+DQoNCjxC Uj48Rk9OVCBDT0xPUj0iIzAwMDAwMCIgU0laRT0yIEZBQ0U9IkFyaWFsIj5Xb3JsZCdzIDE8U1VQ PnN0PC9TVVA+IFNTRS1DTU0gTGV2ZWwgNSBDb21wYW55PC9GT05UPg0KDQo8QlI+PEZPTlQgQ09M T1I9IiMwMDAwMDAiIFNJWkU9MiBGQUNFPSJBcmlhbCI+QlMgNzc5OSBjZXJ0aWZpZWQgYnkgQnJp dGlzaCBTdGFuZGFyZHMgSW5zdGl0dXRlPC9GT05UPg0KDQo8QlI+PEZPTlQgQ09MT1I9IiMwMDAw MDAiIFNJWkU9MiBGQUNFPSJBcmlhbCI+SVNPIDkwMDE6MjAwMCBDZXJ0aWZpZWQgYnkgVMOcViBS aGVpbmxhbmQvQmVybGluLUJyYW5kZW5idXJnPC9GT05UPg0KDQo8QlI+PEZPTlQgQ09MT1I9IiMw MDAwMDAiIFNJWkU9MiBGQUNFPSJBcmlhbCI+QSBTaXggU2lnbWEgUHJhY3RpY2UgQ29tcGFueSA8 L0ZPTlQ+DQoNCjxCUj48Rk9OVCBDT0xPUj0iIzAwMDAwMCIgU0laRT0yIEZBQ0U9IkFyaWFsIj5U ZWw6ICsgOTEgODAgNTE5NTE5OTk7IEZheDogKyA5MSA4MCA1MTUyMzMwMDsgVmlkZW8gQ29uZmVy ZW5jZTogKyA5MSA4MCA1MTI1MjIyMjxCUj4NCkVtYWlsIDogbXVydWdhbi5nPC9GT05UPjxGT05U IFNJWkU9MiBGQUNFPSJBcmlhbCI+QHJlbmFpc3NhbmNlLWl0LmNvbTwvRk9OVD48Rk9OVCBDT0xP Uj0iIzAwMDAwMCIgU0laRT0yIEZBQ0U9IkFyaWFsIj47IFdlYjo8L0ZPTlQ+PFU+IDxGT05UIENP TE9SPSIjMDAwMEZGIiBTSVpFPTIgRkFDRT0iQXJpYWwiPnd3dy5yZW5haXNzYW5jZS1pdC5jb208 L0ZPTlQ+PC9VPjxCUj4NCjxGT05UIENPTE9SPSIjMDAwMDAwIiBTSVpFPTIgRkFDRT0iQXJpYWwi Pj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PTxCUj4NCjwvRk9OVD48Rk9OVCBDT0xPUj0iIzAwMDAwMCIgU0la RT0xIEZBQ0U9IkFyaWFsIj5UaGUgaW5mb3JtYXRpb24gdHJhbnNtaXR0ZWQgaXMgaW50ZW5kZWQg b25seSBmb3IgdGhlIHBlcnNvbiBvciBlbnRpdHkgdG8gd2hpY2ggaXQgaXMgYWRkcmVzc2VkIGFu ZCBtYXkgY29udGFpbiBjb25maWRlbnRpYWwgYW5kL29yIHByaXZpbGVnZWQgbWF0ZXJpYWwuIEFu eSByZXZpZXcsIHJldHJhbnNtaXNzaW9uLCBkaXNzZW1pbmF0aW9uIG9yIG90aGVyIHVzZSBvZiwg b3IgdGFraW5nIG9mIGFueSBhY3Rpb24gaW4gcmVsaWFuY2UgdXBvbiwgdGhpcyBpbmZvcm1hdGlv biBieSBwZXJzb25zIG9yIGVudGl0aWVzIG90aGVyIHRoYW4gdGhlIGludGVuZGVkIHJlY2lwaWVu dCBpcyBwcm9oaWJpdGVkLiBJZiB5b3UgcmVjZWl2ZWQgdGhpcyBpbiBlcnJvciwgcGxlYXNlIGNv bnRhY3QgdGhlIHNlbmRlciBhbmQgZGVsZXRlIGFsbCBjb3BpZXMgZnJvbSBhbnkgY29tcHV0ZXIu PC9GT05UPjwvUD4NCjxCUj4NCg0KPC9CT0RZPg0KPC9IVE1MPg== ------_=_NextPart_001_01C60AD9.21933E8D--