Thread: back up maintenance schedule
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
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" <gunartha.nyoman@ptjas.co.id> >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >To: <pgsql-admin@postgresql.org> >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
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" <gunartha.nyoman@ptjas.co.id> >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >To: <pgsql-admin@postgresql.org> >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
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" <aroravishal22@hotmail.com> To: <gunartha.nyoman@ptjas.co.id> Cc: <pgsql-admin@postgresql.org> 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" <gunartha.nyoman@ptjas.co.id> >>Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >>To: <pgsql-admin@postgresql.org> >>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 >
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" <gunartha.nyoman@ptjas.co.id> >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >To: <pgsql-admin@postgresql.org> >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" ><aroravishal22@hotmail.com> >To: <gunartha.nyoman@ptjas.co.id> >Cc: <pgsql-admin@postgresql.org> >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" <gunartha.nyoman@ptjas.co.id> >>>Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >>>To: <pgsql-admin@postgresql.org> >>>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
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" <gunartha.nyoman@ptjas.co.id> >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >To: <pgsql-admin@postgresql.org> >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 materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
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" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><gunartha.nyoman@ptjas.co.id> >CC: <pgsql-admin@postgresql.org> >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" <gunartha.nyoman@ptjas.co.id> > >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> > >To: <pgsql-admin@postgresql.org> > >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
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" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><gunartha.nyoman@ptjas.co.id> >CC: <pgsql-admin@postgresql.org> >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" <gunartha.nyoman@ptjas.co.id> > >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> > >To: <pgsql-admin@postgresql.org> > >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 materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
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" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><gunartha.nyoman@ptjas.co.id> >CC: <pgsql-admin@postgresql.org> >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" <Jayakumar_Mukundaraju@satyam.com> > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > ><gunartha.nyoman@ptjas.co.id> > >CC: <pgsql-admin@postgresql.org> > >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" <gunartha.nyoman@ptjas.co.id> > > >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> > > >To: <pgsql-admin@postgresql.org> > > >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
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. 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" <Jayakumar_Mukundaraju@satyam.com> >To: "Vishal Arora" <aroravishal22@hotmail.com>, ><gunartha.nyoman@ptjas.co.id> >CC: <pgsql-admin@postgresql.org> >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" <Jayakumar_Mukundaraju@satyam.com> > >To: "Vishal Arora" <aroravishal22@hotmail.com>, > ><gunartha.nyoman@ptjas.co.id> > >CC: <pgsql-admin@postgresql.org> > >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" <gunartha.nyoman@ptjas.co.id> > > >Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> > > >To: <pgsql-admin@postgresql.org> > > >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 materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
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" <Jayakumar_Mukundaraju@satyam.com> >> To: "Vishal Arora" <aroravishal22@hotmail.com>, >> <gunartha.nyoman@ptjas.co.id> >> CC: <pgsql-admin@postgresql.org> >> 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" <Jayakumar_Mukundaraju@satyam.com> >>> To: "Vishal Arora" <aroravishal22@hotmail.com>, >>> <gunartha.nyoman@ptjas.co.id> >>> CC: <pgsql-admin@postgresql.org> >>> 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" <gunartha.nyoman@ptjas.co.id> >>>> Reply-To: "gunartha.nyoman" <gunartha.nyoman@ptjas.co.id> >>>> To: <pgsql-admin@postgresql.org> >>>> 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 materialthat is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distributionor forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intendedrecipient, 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/