From gunartha.nyoman@ptjas.co.id Thu Jun 21 08:55:41 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 925ED9FB3DA for ; Thu, 21 Jun 2007 05:55:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 64810-08 for ; Thu, 21 Jun 2007 05:55:33 -0300 (ADT) X-Greylist: delayed 00:18:37.510158 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 016AE9FB611 for ; Thu, 21 Jun 2007 05:55:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.ptjas.co.id (unknown [202.152.3.67]) by svr4.postgresql.org (Postfix) with ESMTP id BA8345AF039 for ; Thu, 21 Jun 2007 08:36:55 +0000 (GMT) Received: from [178.16.0.253] (helo=idas) by kurawa.ptjas.co.id with smtp (Exim 4.43) id 1I1ILj-00024b-Hg for pgsql-admin@postgresql.org; Thu, 21 Jun 2007 15:49:07 +0700 Message-ID: <015701c7b3e7$92b3e970$fd0010b2@idas> Reply-To: "gunartha.nyoman" From: "gunartha.nyoman" To: Subject: back up maintenance schedule Date: Thu, 21 Jun 2007 16:35:57 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0154_01C7B422.3ECDA220" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.045 tagged_above=0 required=5 tests=AWL=-0.387, BAYES_60=1, HTML_MESSAGE=0.001, RCVD_IN_WHOIS_BOGONS=2.43 X-Spam-Level: *** X-Archive-Number: 200706/216 X-Sequence-Number: 25884 This is a multi-part message in MIME format. ------=_NextPart_000_0154_01C7B422.3ECDA220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi guys, I just trying to install postgres 8.2 in windows xp and success. But I don't know to create schedule backup. Could you like to help me to = solve my problem Many thank for your kindly attention Regards, Nyoman/bali ------=_NextPart_000_0154_01C7B422.3ECDA220 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi guys,
 
I just trying to install postgres = 8.2 in=20 windows xp and success.
But I don't know to create = schedule backup.=20 Could you like to help me to solve my problem
 
Many thank for your kindly=20 attention

Regards,
Nyoman/bali
 
------=_NextPart_000_0154_01C7B422.3ECDA220-- From aroravishal22@hotmail.com Thu Jun 21 10:58:16 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DB0309FC07F for ; Thu, 21 Jun 2007 07:58:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 22885-03 for ; Thu, 21 Jun 2007 07:58:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc2-s15.bay0.hotmail.com (bay0-omc2-s15.bay0.hotmail.com [65.54.246.151]) by postgresql.org (Postfix) with ESMTP id A10119FC064 for ; Thu, 21 Jun 2007 07:58:12 -0300 (ADT) Received: from hotmail.com ([207.46.11.108]) by bay0-omc2-s15.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Thu, 21 Jun 2007 03:58:10 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 21 Jun 2007 03:58:11 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Thu, 21 Jun 2007 10:58:05 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <015701c7b3e7$92b3e970$fd0010b2@idas> From: "Vishal Arora" To: gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: back up maintenance schedule Date: Thu, 21 Jun 2007 10:58:05 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 21 Jun 2007 10:58:11.0035 (UTC) FILETIME=[0ED0FAB0:01C7B3F3] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.09 tagged_above=0 required=5 tests=AWL=-0.633, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200706/217 X-Sequence-Number: 25885 Hi You can do it with the pgAdmin III Please check the following link - http://www.pgadmin.org/docs/dev/pgagent.html PgAgent can help in scheduling jobs for you. - vishal >From: "gunartha.nyoman" >Reply-To: "gunartha.nyoman" >To: >Subject: [ADMIN] back up maintenance schedule >Date: Thu, 21 Jun 2007 16:35:57 +0700 > >hi guys, > >I just trying to install postgres 8.2 in windows xp and success. >But I don't know to create schedule backup. Could you like to help me to >solve my problem > >Many thank for your kindly attention > >Regards, >Nyoman/bali _________________________________________________________________ Need a break? Find your escape route with Live Search Maps. http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=1118863&encType=1&FORM=MGAC01 From ksrinivas@bisil.com Thu Jun 21 11:02:55 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7165E9FBF8F for ; Thu, 21 Jun 2007 08:02:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81568-06-5 for ; Thu, 21 Jun 2007 08:02:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247]) by postgresql.org (Postfix) with ESMTP id CE7819FB89D for ; Thu, 21 Jun 2007 08:02:45 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so98249ana for ; Thu, 21 Jun 2007 04:02:44 -0700 (PDT) Received: by 10.100.107.2 with SMTP id f2mr996673anc.1182423764493; Thu, 21 Jun 2007 04:02:44 -0700 (PDT) Received: from srinilaptop ( [72.94.185.146]) by mx.google.com with ESMTP id c14sm2647773ana.2007.06.21.04.02.43 (version=SSLv3 cipher=RC4-MD5); Thu, 21 Jun 2007 04:02:43 -0700 (PDT) Reply-To: From: "Srinivas Kotapally" To: "'Vishal Arora'" , Cc: References: <015701c7b3e7$92b3e970$fd0010b2@idas> Subject: Re: back up maintenance schedule Date: Thu, 21 Jun 2007 07:02:41 -0400 Organization: BISIL NA Inc Message-ID: <016901c7b3f3$b0765b80$0401a8c0@srinilaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acez82NvgYIWXH5NR8OSGVRbFxh0HAAACWpA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/218 X-Sequence-Number: 25886 You can also use the pg_dump utility and put it on a cron (in Linux) to schedule backups. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora Sent: Thursday, June 21, 2007 6:58 AM To: gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] back up maintenance schedule Hi You can do it with the pgAdmin III Please check the following link - http://www.pgadmin.org/docs/dev/pgagent.html PgAgent can help in scheduling jobs for you. - vishal >From: "gunartha.nyoman" >Reply-To: "gunartha.nyoman" >To: >Subject: [ADMIN] back up maintenance schedule >Date: Thu, 21 Jun 2007 16:35:57 +0700 > >hi guys, > >I just trying to install postgres 8.2 in windows xp and success. >But I don't know to create schedule backup. Could you like to help me >to solve my problem > >Many thank for your kindly attention > >Regards, >Nyoman/bali _________________________________________________________________ Need a break? Find your escape route with Live Search Maps. http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park&cp=33.8 32922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=1118863&encType= 1&FORM=MGAC01 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend From gunartha.nyoman@ptjas.co.id Fri Jun 22 01:28:29 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 72D349FB48D for ; Thu, 21 Jun 2007 22:28:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 04523-09 for ; Thu, 21 Jun 2007 22:28:20 -0300 (ADT) X-Greylist: delayed 16:51:45.98673 by SQLgrey-1.7.5 Received: from mail.ptjas.co.id (unknown [202.152.3.67]) by postgresql.org (Postfix) with ESMTP id E5E479FB432 for ; Thu, 21 Jun 2007 22:28:24 -0300 (ADT) Received: from [178.16.0.253] (helo=idas) by kurawa.ptjas.co.id with smtp (Exim 4.43) id 1I1Y91-00039B-94 for pgsql-admin@postgresql.org; Fri, 22 Jun 2007 08:41:03 +0700 Message-ID: <000401c7b474$f001e310$fd0010b2@idas> Reply-To: "gunartha.nyoman" From: "gunartha.nyoman" To: References: Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 09:27:53 +0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.609 tagged_above=0 required=5 tests=AWL=0.178, BAYES_50=0.001, RCVD_IN_WHOIS_BOGONS=2.43 X-Spam-Level: ** X-Archive-Number: 200706/229 X-Sequence-Number: 25897 Dear Vishal, I have installed pgAgent as a services on windows and then I open the pgAdmin III but I cannot read Jobs(1) like image pgAgent's help. Could you like to help me again, how to connect pgAdmin III and pgAgent to create a schedule Thank you for your help. Regards, Nyoman/Bali ----- Original Message ----- From: "Vishal Arora" To: Cc: Sent: Thursday, June 21, 2007 5:58 PM Subject: RE: [ADMIN] back up maintenance schedule > > Hi > > You can do it with the pgAdmin III > > Please check the following link - > http://www.pgadmin.org/docs/dev/pgagent.html > > PgAgent can help in scheduling jobs for you. > > - vishal > >>From: "gunartha.nyoman" >>Reply-To: "gunartha.nyoman" >>To: >>Subject: [ADMIN] back up maintenance schedule >>Date: Thu, 21 Jun 2007 16:35:57 +0700 >> >>hi guys, >> >>I just trying to install postgres 8.2 in windows xp and success. >>But I don't know to create schedule backup. Could you like to help me to >>solve my problem >> >>Many thank for your kindly attention >> >>Regards, >>Nyoman/bali > > _________________________________________________________________ > Need a break? Find your escape route with Live Search Maps. > http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=1118863&encType=1&FORM=MGAC01 > From aroravishal22@hotmail.com Fri Jun 22 04:32:56 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0D3A19FB47C for ; Fri, 22 Jun 2007 01:32:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18513-09 for ; Fri, 22 Jun 2007 01:32:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s15.bay0.hotmail.com (bay0-omc3-s15.bay0.hotmail.com [65.54.246.215]) by postgresql.org (Postfix) with ESMTP id 59D859FB1E8 for ; Fri, 22 Jun 2007 01:32:07 -0300 (ADT) Received: from hotmail.com ([207.46.11.113]) by bay0-omc3-s15.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Thu, 21 Jun 2007 21:29:59 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 21 Jun 2007 21:29:58 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Fri, 22 Jun 2007 04:29:57 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <000401c7b474$f001e310$fd0010b2@idas> From: "Vishal Arora" To: gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 04:29:57 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Jun 2007 04:29:58.0871 (UTC) FILETIME=[FE048E70:01C7B485] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/234 X-Sequence-Number: 25902 Did you run the SQL script in postgres database or anywhere else. When I tried to run that pgagent.sql in some other database I did not find jobs in pgAdminIII. If you try to run it in postgres database (default one created while installation). I think this should work for you. - Vishal >From: "gunartha.nyoman" >Reply-To: "gunartha.nyoman" >To: >Subject: Re: [ADMIN] back up maintenance schedule >Date: Fri, 22 Jun 2007 09:27:53 +0700 > >Dear Vishal, > >I have installed pgAgent as a services on windows and then I open the >pgAdmin III but I cannot read Jobs(1) like image pgAgent's help. >Could you like to help me again, how to connect pgAdmin III and pgAgent to >create a schedule > >Thank you for your help. >Regards, >Nyoman/Bali > > >----- Original Message ----- From: "Vishal Arora" > >To: >Cc: >Sent: Thursday, June 21, 2007 5:58 PM >Subject: RE: [ADMIN] back up maintenance schedule > > >> >>Hi >> >>You can do it with the pgAdmin III >> >>Please check the following link - >>http://www.pgadmin.org/docs/dev/pgagent.html >> >>PgAgent can help in scheduling jobs for you. >> >>- vishal >> >>>From: "gunartha.nyoman" >>>Reply-To: "gunartha.nyoman" >>>To: >>>Subject: [ADMIN] back up maintenance schedule >>>Date: Thu, 21 Jun 2007 16:35:57 +0700 >>> >>>hi guys, >>> >>>I just trying to install postgres 8.2 in windows xp and success. >>>But I don't know to create schedule backup. Could you like to help me to >>>solve my problem >>> >>>Many thank for your kindly attention >>> >>>Regards, >>>Nyoman/bali >> >>_________________________________________________________________ >>Need a break? Find your escape route with Live Search Maps. >>http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=1118863&encType=1&FORM=MGAC01 >> > > >---------------------------(end of broadcast)--------------------------- >TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate _________________________________________________________________ Hotmail to go? Get your Hotmail, news, sports and much more! http://mobile.msn.com From Jayakumar_Mukundaraju@satyam.com Fri Jun 22 05:22:03 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B25329FB63A for ; Fri, 22 Jun 2007 02:22:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26723-01-2 for ; Fri, 22 Jun 2007 02:21:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hydmail1.satyam.com (hydmail1.satyam.com [124.30.170.13]) by postgresql.org (Postfix) with ESMTP id 5F4D99FB839 for ; Fri, 22 Jun 2007 02:14:55 -0300 (ADT) Received: from hyd.satyam.com (hyd.satyam.com [204.252.161.226]) by hydmail1.satyam.com (8.13.4/8.13.4) with ESMTP id l5M5DGH3010690 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 22 Jun 2007 10:43:17 +0530 Received: from Disclaimerhyd.corp.satyam.ad (hhtbh.satyam.com [172.16.186.212]) by hyd.satyam.com (8.13.1/8.13.1) with ESMTP id l5M5CWxN017317; Fri, 22 Jun 2007 10:42:32 +0530 Received: from hcsmsg002.corp.satyam.ad ([172.16.129.211]) by Disclaimerhyd.corp.satyam.ad with Microsoft SMTPSVC(6.0.3790.211); Fri, 22 Jun 2007 10:44:51 +0530 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Importance: normal Content-Transfer-Encoding: quoted-printable Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 10:44:50 +0530 Message-ID: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEEA5E@hcsmsg002.corp.satyam.ad> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] back up maintenance schedule thread-index: Acez84ukcZipSRz6TDGht9vDSrKUHwAl3LzA From: "Jayakumar_Mukundaraju" To: "Vishal Arora" , Cc: X-OriginalArrivalTime: 22 Jun 2007 05:14:51.0015 (UTC) FILETIME=[42A92170:01C7B48C] X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on hyd.satyam.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL=0.103, BAYES_40=-0.185, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/236 X-Sequence-Number: 25904 Hi, I want to Install postgresql server in windows platform, kindly any one help for this. Thanks & Regards Jayakumar M -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora Sent: Thursday, June 21, 2007 4:28 PM To: gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] back up maintenance schedule Hi You can do it with the pgAdmin III Please check the following link -=20 http://www.pgadmin.org/docs/dev/pgagent.html PgAgent can help in scheduling jobs for you. - vishal >From: "gunartha.nyoman" >Reply-To: "gunartha.nyoman" >To: >Subject: [ADMIN] back up maintenance schedule >Date: Thu, 21 Jun 2007 16:35:57 +0700 > >hi guys, > >I just trying to install postgres 8.2 in windows xp and success. >But I don't know to create schedule backup. Could you like to help me to=20 >solve my problem > >Many thank for your kindly attention > >Regards, >Nyoman/bali _________________________________________________________________ Need a break? Find your escape route with Live Search Maps.=20 http://maps.live.com/default.aspx?ss=3DRestaurants~Hotels~Amusement%20Par= k &cp=3D33.832922~-117.915659&style=3Dr&lvl=3D13&tilt=3D-90&dir=3D0&alt=3D-= 1000&scene=3D 1118863&encType=3D1&FORM=3DMGAC01 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend DISCLAIMER: This email (including any attachments) is intended for the sole use of = the intended recipient/s and may contain material that is CONFIDENTIAL = AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or = copying or distribution or forwarding of any or all of the contents in = this message is STRICTLY PROHIBITED. If you are not the intended = recipient, please contact the sender by email and delete all copies; = your cooperation in this regard is appreciated. From aroravishal22@hotmail.com Fri Jun 22 07:03:50 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E5B6D9FB909 for ; Fri, 22 Jun 2007 04:03:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42701-07 for ; Fri, 22 Jun 2007 04:03:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s12.bay0.hotmail.com (bay0-omc3-s12.bay0.hotmail.com [65.54.246.212]) by postgresql.org (Postfix) with ESMTP id 1EC319FB93E for ; Fri, 22 Jun 2007 04:03:45 -0300 (ADT) Received: from hotmail.com ([207.46.11.91]) by bay0-omc3-s12.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 22 Jun 2007 00:03:45 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 22 Jun 2007 00:03:42 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Fri, 22 Jun 2007 07:03:41 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEEA5E@hcsmsg002.corp.satyam.ad> From: "Vishal Arora" To: Jayakumar_Mukundaraju@satyam.com, gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 07:03:41 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Jun 2007 07:03:42.0264 (UTC) FILETIME=[7796A380:01C7B49B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/237 X-Sequence-Number: 25905 Kindly install this package from the following link. It is an installer file which would do everything for you. http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip Run one of the windows installer packages from the zip file. Package would guide you through the procedure. - Vishal >From: "Jayakumar_Mukundaraju" >To: "Vishal Arora" , > >CC: >Subject: Re: [ADMIN] back up maintenance schedule >Date: Fri, 22 Jun 2007 10:44:50 +0530 > >Hi, > >I want to Install postgresql server in windows platform, kindly any one >help for this. > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: pgsql-admin-owner@postgresql.org >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora >Sent: Thursday, June 21, 2007 4:28 PM >To: gunartha.nyoman@ptjas.co.id >Cc: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] back up maintenance schedule > > >Hi > >You can do it with the pgAdmin III > >Please check the following link - >http://www.pgadmin.org/docs/dev/pgagent.html > >PgAgent can help in scheduling jobs for you. > >- vishal > > >From: "gunartha.nyoman" > >Reply-To: "gunartha.nyoman" > >To: > >Subject: [ADMIN] back up maintenance schedule > >Date: Thu, 21 Jun 2007 16:35:57 +0700 > > > >hi guys, > > > >I just trying to install postgres 8.2 in windows xp and success. > >But I don't know to create schedule backup. Could you like to help me >to > >solve my problem > > > >Many thank for your kindly attention > > > >Regards, > >Nyoman/bali > >_________________________________________________________________ >Need a break? Find your escape route with Live Search Maps. >http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park >&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene= >1118863&encType=1&FORM=MGAC01 > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate _________________________________________________________________ PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 From Jayakumar_Mukundaraju@satyam.com Fri Jun 22 07:24:09 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B5A939FB48D for ; Fri, 22 Jun 2007 04:24:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 00700-05 for ; Fri, 22 Jun 2007 04:24:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hydmail1.satyam.com (hydmail1.satyam.com [124.30.170.13]) by postgresql.org (Postfix) with ESMTP id 0B89D9FB485 for ; Fri, 22 Jun 2007 04:24:02 -0300 (ADT) Received: from hyd.satyam.com (hyd.satyam.com [204.252.161.226]) by hydmail1.satyam.com (8.13.4/8.13.4) with ESMTP id l5M7MPd9006291 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 22 Jun 2007 12:52:26 +0530 Received: from Disclaimerhyd.corp.satyam.ad (hhtbh.satyam.com [172.16.186.212]) by hyd.satyam.com (8.13.1/8.13.1) with ESMTP id l5M7LfWN008565; Fri, 22 Jun 2007 12:51:41 +0530 Received: from hcsmsg002.corp.satyam.ad ([172.16.129.211]) by Disclaimerhyd.corp.satyam.ad with Microsoft SMTPSVC(6.0.3790.211); Fri, 22 Jun 2007 12:54:01 +0530 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Importance: normal Content-Transfer-Encoding: quoted-printable Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 12:52:14 +0530 Message-ID: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEECCA@hcsmsg002.corp.satyam.ad> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] back up maintenance schedule thread-index: Ace0m6VYTpZ9RByzSTCly8sNb+hP0wAAaOvw From: "Jayakumar_Mukundaraju" To: "Vishal Arora" , Cc: X-OriginalArrivalTime: 22 Jun 2007 07:24:01.0187 (UTC) FILETIME=[4E1F8730:01C7B49E] X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on hyd.satyam.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/238 X-Sequence-Number: 25906 Hi Vishanl, Thanks for the timely reply... I downloaded the software and installed it in windows XP.. And now I want to give the permission(client)to access to this database to others. what are the config files I have to modify? Kindly give me the solution. Thanks & Regards Jayakumar M -----Original Message----- From: Vishal Arora [mailto:aroravishal22@hotmail.com]=20 Sent: Friday, June 22, 2007 12:34 PM To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] back up maintenance schedule Kindly install this package from the following link. It is an installer file=20 which would do everything for you. http://wwwmaster.postgresql.org/download/mirrors-ftp?file=3D%2Fbinary%2Fv= 8 .2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip Run one of the windows installer packages from the zip file. Package would=20 guide you through the procedure. - Vishal >From: "Jayakumar_Mukundaraju" >To: "Vishal Arora" ,=20 > >CC: >Subject: Re: [ADMIN] back up maintenance schedule >Date: Fri, 22 Jun 2007 10:44:50 +0530 > >Hi, > >I want to Install postgresql server in windows platform, kindly any one >help for this. > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: pgsql-admin-owner@postgresql.org >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora >Sent: Thursday, June 21, 2007 4:28 PM >To: gunartha.nyoman@ptjas.co.id >Cc: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] back up maintenance schedule > > >Hi > >You can do it with the pgAdmin III > >Please check the following link - >http://www.pgadmin.org/docs/dev/pgagent.html > >PgAgent can help in scheduling jobs for you. > >- vishal > > >From: "gunartha.nyoman" > >Reply-To: "gunartha.nyoman" > >To: > >Subject: [ADMIN] back up maintenance schedule > >Date: Thu, 21 Jun 2007 16:35:57 +0700 > > > >hi guys, > > > >I just trying to install postgres 8.2 in windows xp and success. > >But I don't know to create schedule backup. Could you like to help me >to > >solve my problem > > > >Many thank for your kindly attention > > > >Regards, > >Nyoman/bali > >_________________________________________________________________ >Need a break? Find your escape route with Live Search Maps. >http://maps.live.com/default.aspx?ss=3DRestaurants~Hotels~Amusement%20Pa= r k >&cp=3D33.832922~-117.915659&style=3Dr&lvl=3D13&tilt=3D-90&dir=3D0&alt=3D= -1000&scene =3D >1118863&encType=3D1&FORM=3DMGAC01 > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the=20 >intended recipient/s and may contain material that is CONFIDENTIAL AND=20 >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or=20 >distribution or forwarding of any or all of the contents in this message is=20 >STRICTLY PROHIBITED. If you are not the intended recipient, please contact=20 >the sender by email and delete all copies; your cooperation in this regard=20 >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate _________________________________________________________________ PC Magazine's 2007 editors' choice for best Web mail-award-winning Windows=20 Live Hotmail.=20 http://imagine-windowslive.com/hotmail/?locale=3Den-us&ocid=3DTXT_TAGHM_m= igr ation_HM_mini_pcmag_0507 DISCLAIMER: This email (including any attachments) is intended for the sole use of = the intended recipient/s and may contain material that is CONFIDENTIAL = AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or = copying or distribution or forwarding of any or all of the contents in = this message is STRICTLY PROHIBITED. If you are not the intended = recipient, please contact the sender by email and delete all copies; = your cooperation in this regard is appreciated. From aroravishal22@hotmail.com Fri Jun 22 08:43:24 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A10A29FA4F0 for ; Fri, 22 Jun 2007 05:43:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02022-08 for ; Fri, 22 Jun 2007 05:43:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from bay0-omc1-s35.bay0.hotmail.com (bay0-omc1-s35.bay0.hotmail.com [65.54.246.107]) by postgresql.org (Postfix) with ESMTP id 9FF3E9FB40D for ; Fri, 22 Jun 2007 05:43:19 -0300 (ADT) Received: from hotmail.com ([207.46.11.96]) by bay0-omc1-s35.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 22 Jun 2007 01:43:18 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 22 Jun 2007 01:43:18 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Fri, 22 Jun 2007 08:43:15 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEECCA@hcsmsg002.corp.satyam.ad> From: "Vishal Arora" To: Jayakumar_Mukundaraju@satyam.com, gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 08:43:15 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Jun 2007 08:43:18.0295 (UTC) FILETIME=[61949A70:01C7B4A9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/241 X-Sequence-Number: 25909 I think this would be a good start - http://www.postgresql.org/docs/8.2/interactive/client-authentication.html Modify your pg_hba.conf file according to your requirements. - Vishal >From: "Jayakumar_Mukundaraju" >To: "Vishal Arora" , > >CC: >Subject: Re: [ADMIN] back up maintenance schedule >Date: Fri, 22 Jun 2007 12:52:14 +0530 > >Hi Vishanl, > >Thanks for the timely reply... I downloaded the software and installed >it in windows XP.. And now I want to give the permission(client)to >access to this database to others. what are the config files I have to >modify? Kindly give me the solution. > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Friday, June 22, 2007 12:34 PM >To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id >Cc: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] back up maintenance schedule > >Kindly install this package from the following link. It is an installer >file >which would do everything for you. > >http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8 >.2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip > >Run one of the windows installer packages from the zip file. Package >would >guide you through the procedure. > >- Vishal > > > >From: "Jayakumar_Mukundaraju" > >To: "Vishal Arora" , > > > >CC: > >Subject: Re: [ADMIN] back up maintenance schedule > >Date: Fri, 22 Jun 2007 10:44:50 +0530 > > > >Hi, > > > >I want to Install postgresql server in windows platform, kindly any one > >help for this. > > > >Thanks & Regards > >Jayakumar M > > > > > >-----Original Message----- > >From: pgsql-admin-owner@postgresql.org > >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora > >Sent: Thursday, June 21, 2007 4:28 PM > >To: gunartha.nyoman@ptjas.co.id > >Cc: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] back up maintenance schedule > > > > > >Hi > > > >You can do it with the pgAdmin III > > > >Please check the following link - > >http://www.pgadmin.org/docs/dev/pgagent.html > > > >PgAgent can help in scheduling jobs for you. > > > >- vishal > > > > >From: "gunartha.nyoman" > > >Reply-To: "gunartha.nyoman" > > >To: > > >Subject: [ADMIN] back up maintenance schedule > > >Date: Thu, 21 Jun 2007 16:35:57 +0700 > > > > > >hi guys, > > > > > >I just trying to install postgres 8.2 in windows xp and success. > > >But I don't know to create schedule backup. Could you like to help me > >to > > >solve my problem > > > > > >Many thank for your kindly attention > > > > > >Regards, > > >Nyoman/bali > > > >_________________________________________________________________ > >Need a break? Find your escape route with Live Search Maps. > >http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Par >k > >&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene >= > >1118863&encType=1&FORM=MGAC01 > > > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 6: explain analyze is your friend > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying or > >distribution or forwarding of any or all of the contents in this >message is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 7: You can help support the PostgreSQL project by donating at > > > > http://www.postgresql.org/about/donate > >_________________________________________________________________ >PC Magazine's 2007 editors' choice for best Web mail-award-winning >Windows >Live Hotmail. >http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr >ation_HM_mini_pcmag_0507 > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend _________________________________________________________________ Get a preview of Live Earth, the hottest event this summer - only on MSN http://liveearth.msn.com?source=msntaglineliveearthhm From Jayakumar_Mukundaraju@satyam.com Fri Jun 22 13:32:23 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1EF079FC287 for ; Fri, 22 Jun 2007 10:32:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 13256-03 for ; Fri, 22 Jun 2007 10:32:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hydmail1.satyam.com (hydmail1.satyam.com [124.30.170.13]) by postgresql.org (Postfix) with ESMTP id 9E1589FC28D for ; Fri, 22 Jun 2007 10:32:16 -0300 (ADT) Received: from hyd.satyam.com (hyd.satyam.com [204.252.161.226]) by hydmail1.satyam.com (8.13.4/8.13.4) with ESMTP id l5MDUYEH029573 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 22 Jun 2007 19:00:35 +0530 Received: from Disclaimerhyd.corp.satyam.ad (hhtbh.satyam.com [172.16.186.212]) by hyd.satyam.com (8.13.1/8.13.1) with ESMTP id l5MDTnWg021533; Fri, 22 Jun 2007 18:59:49 +0530 Received: from hcsmsg002.corp.satyam.ad ([172.16.129.211]) by Disclaimerhyd.corp.satyam.ad with Microsoft SMTPSVC(6.0.3790.211); Fri, 22 Jun 2007 19:02:13 +0530 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Importance: normal Content-Transfer-Encoding: quoted-printable Subject: Re: back up maintenance schedule Date: Fri, 22 Jun 2007 18:58:11 +0530 Message-ID: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEF185@hcsmsg002.corp.satyam.ad> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] back up maintenance schedule thread-index: Ace0qY0U6tog7U/TQ925pHWl4i4GjAAJztQw From: "Jayakumar_Mukundaraju" To: "Vishal Arora" , Cc: X-OriginalArrivalTime: 22 Jun 2007 13:32:13.0081 (UTC) FILETIME=[BDEB0890:01C7B4D1] X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on hyd.satyam.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/244 X-Sequence-Number: 25912 Hi All, I need a clarification of Procedures in postgres. My question is procedures can support postgres. If we write functions it is stored in function procedure only. Kindly clarify this.=20 Thanks & Regards Jayakumar M =20 -----Original Message----- From: Vishal Arora [mailto:aroravishal22@hotmail.com]=20 Sent: Friday, June 22, 2007 2:13 PM To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] back up maintenance schedule I think this would be a good start - http://www.postgresql.org/docs/8.2/interactive/client-authentication.htm l Modify your pg_hba.conf file according to your requirements. - Vishal >From: "Jayakumar_Mukundaraju" >To: "Vishal Arora" ,=20 > >CC: >Subject: Re: [ADMIN] back up maintenance schedule >Date: Fri, 22 Jun 2007 12:52:14 +0530 > >Hi Vishanl, > >Thanks for the timely reply... I downloaded the software and installed >it in windows XP.. And now I want to give the permission(client)to >access to this database to others. what are the config files I have to >modify? Kindly give me the solution. > >Thanks & Regards >Jayakumar M > > >-----Original Message----- >From: Vishal Arora [mailto:aroravishal22@hotmail.com] >Sent: Friday, June 22, 2007 12:34 PM >To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id >Cc: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] back up maintenance schedule > >Kindly install this package from the following link. It is an installer >file >which would do everything for you. > >http://wwwmaster.postgresql.org/download/mirrors-ftp?file=3D%2Fbinary%2F= v 8 >.2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip > >Run one of the windows installer packages from the zip file. Package >would >guide you through the procedure. > >- Vishal > > > >From: "Jayakumar_Mukundaraju" > >To: "Vishal Arora" , > > > >CC: > >Subject: Re: [ADMIN] back up maintenance schedule > >Date: Fri, 22 Jun 2007 10:44:50 +0530 > > > >Hi, > > > >I want to Install postgresql server in windows platform, kindly any one > >help for this. > > > >Thanks & Regards > >Jayakumar M > > > > > >-----Original Message----- > >From: pgsql-admin-owner@postgresql.org > >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora > >Sent: Thursday, June 21, 2007 4:28 PM > >To: gunartha.nyoman@ptjas.co.id > >Cc: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] back up maintenance schedule > > > > > >Hi > > > >You can do it with the pgAdmin III > > > >Please check the following link - > >http://www.pgadmin.org/docs/dev/pgagent.html > > > >PgAgent can help in scheduling jobs for you. > > > >- vishal > > > > >From: "gunartha.nyoman" > > >Reply-To: "gunartha.nyoman" > > >To: > > >Subject: [ADMIN] back up maintenance schedule > > >Date: Thu, 21 Jun 2007 16:35:57 +0700 > > > > > >hi guys, > > > > > >I just trying to install postgres 8.2 in windows xp and success. > > >But I don't know to create schedule backup. Could you like to help me > >to > > >solve my problem > > > > > >Many thank for your kindly attention > > > > > >Regards, > > >Nyoman/bali > > > >_________________________________________________________________ > >Need a break? Find your escape route with Live Search Maps. > >http://maps.live.com/default.aspx?ss=3DRestaurants~Hotels~Amusement%20Pa= r >k > >&cp=3D33.832922~-117.915659&style=3Dr&lvl=3D13&tilt=3D-90&dir=3D0&alt=3D= -1000&scene >=3D > >1118863&encType=3D1&FORM=3DMGAC01 > > > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 6: explain analyze is your friend > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying or > >distribution or forwarding of any or all of the contents in this >message is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 7: You can help support the PostgreSQL project by donating at > > > > http://www.postgresql.org/about/donate > >_________________________________________________________________ >PC Magazine's 2007 editors' choice for best Web mail-award-winning >Windows >Live Hotmail. >http://imagine-windowslive.com/hotmail/?locale=3Den-us&ocid=3DTXT_TAGHM_= mig r >ation_HM_mini_pcmag_0507 > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the=20 >intended recipient/s and may contain material that is CONFIDENTIAL AND=20 >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or=20 >distribution or forwarding of any or all of the contents in this message is=20 >STRICTLY PROHIBITED. If you are not the intended recipient, please contact=20 >the sender by email and delete all copies; your cooperation in this regard=20 >is appreciated. > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend _________________________________________________________________ Get a preview of Live Earth, the hottest event this summer - only on MSN http://liveearth.msn.com?source=3Dmsntaglineliveearthhm DISCLAIMER: This email (including any attachments) is intended for the sole use of = the intended recipient/s and may contain material that is CONFIDENTIAL = AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or = copying or distribution or forwarding of any or all of the contents in = this message is STRICTLY PROHIBITED. If you are not the intended = recipient, please contact the sender by email and delete all copies; = your cooperation in this regard is appreciated. From jd@commandprompt.com Fri Jun 22 13:46:24 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B66549FB9AA for ; Fri, 22 Jun 2007 10:46:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16431-01-10 for ; Fri, 22 Jun 2007 10:46:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 765F99FB71D for ; Fri, 22 Jun 2007 10:46:19 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l5MDkH2v019984; Fri, 22 Jun 2007 06:46:17 -0700 Message-ID: <467BD2F3.4040003@commandprompt.com> Date: Fri, 22 Jun 2007 06:47:31 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: Jayakumar_Mukundaraju CC: Vishal Arora , gunartha.nyoman@ptjas.co.id, pgsql-admin@postgresql.org Subject: Re: back up maintenance schedule References: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEF185@hcsmsg002.corp.satyam.ad> In-Reply-To: <8BE2E1772BEE8D40B0FB9E59DF2A645E06BEF185@hcsmsg002.corp.satyam.ad> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 22 Jun 2007 06:46:18 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/245 X-Sequence-Number: 25913 Jayakumar_Mukundaraju wrote: > Hi All, > > I need a clarification of Procedures in postgres. My question is > procedures can support postgres. If we write functions it is stored in > function procedure only. Kindly clarify this. I am not sure I understand what you are saying here but I will give it a shot. Procedures and Functions in postgresql are the same thing. Functions when written in postgresql only work in postgresql, although you can use many different languages to write them in. Joshua D. Drake > > Thanks & Regards > Jayakumar M > > > -----Original Message----- > From: Vishal Arora [mailto:aroravishal22@hotmail.com] > Sent: Friday, June 22, 2007 2:13 PM > To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] back up maintenance schedule > > I think this would be a good start - > > http://www.postgresql.org/docs/8.2/interactive/client-authentication.htm > l > > Modify your pg_hba.conf file according to your requirements. > > - Vishal > >> From: "Jayakumar_Mukundaraju" >> To: "Vishal Arora" , >> >> CC: >> Subject: Re: [ADMIN] back up maintenance schedule >> Date: Fri, 22 Jun 2007 12:52:14 +0530 >> >> Hi Vishanl, >> >> Thanks for the timely reply... I downloaded the software and installed >> it in windows XP.. And now I want to give the permission(client)to >> access to this database to others. what are the config files I have to >> modify? Kindly give me the solution. >> >> Thanks & Regards >> Jayakumar M >> >> >> -----Original Message----- >> From: Vishal Arora [mailto:aroravishal22@hotmail.com] >> Sent: Friday, June 22, 2007 12:34 PM >> To: Jayakumar_Mukundaraju; gunartha.nyoman@ptjas.co.id >> Cc: pgsql-admin@postgresql.org >> Subject: Re: [ADMIN] back up maintenance schedule >> >> Kindly install this package from the following link. It is an installer >> file >> which would do everything for you. >> >> http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv > 8 >> .2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip >> >> Run one of the windows installer packages from the zip file. Package >> would >> guide you through the procedure. >> >> - Vishal >> >> >>> From: "Jayakumar_Mukundaraju" >>> To: "Vishal Arora" , >>> >>> CC: >>> Subject: Re: [ADMIN] back up maintenance schedule >>> Date: Fri, 22 Jun 2007 10:44:50 +0530 >>> >>> Hi, >>> >>> I want to Install postgresql server in windows platform, kindly any > one >>> help for this. >>> >>> Thanks & Regards >>> Jayakumar M >>> >>> >>> -----Original Message----- >>> From: pgsql-admin-owner@postgresql.org >>> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora >>> Sent: Thursday, June 21, 2007 4:28 PM >>> To: gunartha.nyoman@ptjas.co.id >>> Cc: pgsql-admin@postgresql.org >>> Subject: Re: [ADMIN] back up maintenance schedule >>> >>> >>> Hi >>> >>> You can do it with the pgAdmin III >>> >>> Please check the following link - >>> http://www.pgadmin.org/docs/dev/pgagent.html >>> >>> PgAgent can help in scheduling jobs for you. >>> >>> - vishal >>> >>>> From: "gunartha.nyoman" >>>> Reply-To: "gunartha.nyoman" >>>> To: >>>> Subject: [ADMIN] back up maintenance schedule >>>> Date: Thu, 21 Jun 2007 16:35:57 +0700 >>>> >>>> hi guys, >>>> >>>> I just trying to install postgres 8.2 in windows xp and success. >>>> But I don't know to create schedule backup. Could you like to help > me >>> to >>>> solve my problem >>>> >>>> Many thank for your kindly attention >>>> >>>> Regards, >>>> Nyoman/bali >>> _________________________________________________________________ >>> Need a break? Find your escape route with Live Search Maps. >> http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Par >> k >> >> &cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene >> = >>> 1118863&encType=1&FORM=MGAC01 >>> >>> >>> ---------------------------(end of >> broadcast)--------------------------- >>> TIP 6: explain analyze is your friend >>> >>> >>> >>> DISCLAIMER: >>> This email (including any attachments) is intended for the sole use > of >> the >>> intended recipient/s and may contain material that is CONFIDENTIAL > AND >>> PRIVATE COMPANY INFORMATION. Any review or reliance by others or >> copying or >>> distribution or forwarding of any or all of the contents in this >> message is >>> STRICTLY PROHIBITED. If you are not the intended recipient, please >> contact >>> the sender by email and delete all copies; your cooperation in this >> regard >>> is appreciated. >>> >>> ---------------------------(end of >> broadcast)--------------------------- >>> TIP 7: You can help support the PostgreSQL project by donating at >>> >>> http://www.postgresql.org/about/donate >> _________________________________________________________________ >> PC Magazine's 2007 editors' choice for best Web mail-award-winning >> Windows >> Live Hotmail. >> http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_mig > r >> ation_HM_mini_pcmag_0507 >> >> >> >> >> DISCLAIMER: >> This email (including any attachments) is intended for the sole use of > the >> intended recipient/s and may contain material that is CONFIDENTIAL AND >> PRIVATE COMPANY INFORMATION. Any review or reliance by others or > copying or >> distribution or forwarding of any or all of the contents in this > message is >> STRICTLY PROHIBITED. If you are not the intended recipient, please > contact >> the sender by email and delete all copies; your cooperation in this > regard >> is appreciated. >> >> ---------------------------(end of > broadcast)--------------------------- >> TIP 6: explain analyze is your friend > > _________________________________________________________________ > Get a preview of Live Earth, the hottest event this summer - only on MSN > > http://liveearth.msn.com?source=msntaglineliveearthhm > > > > > DISCLAIMER: > This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/