Thread: back up maintenance schedule

back up maintenance schedule

From
"gunartha.nyoman"
Date:
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
 

Re: back up maintenance schedule

From
"Vishal Arora"
Date:
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


Re: back up maintenance schedule

From
"Srinivas Kotapally"
Date:
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


Re: back up maintenance schedule

From
"gunartha.nyoman"
Date:
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
>


Re: back up maintenance schedule

From
"Vishal Arora"
Date:
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


Re: back up maintenance schedule

From
"Jayakumar_Mukundaraju"
Date:
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.

Re: back up maintenance schedule

From
"Vishal Arora"
Date:
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


Re: back up maintenance schedule

From
"Jayakumar_Mukundaraju"
Date:
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.

Re: back up maintenance schedule

From
"Vishal Arora"
Date:
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


Re: back up maintenance schedule

From
"Jayakumar_Mukundaraju"
Date:
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.

Re: back up maintenance schedule

From
"Joshua D. Drake"
Date:
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/