[GENERAL] Scheduled back up

2003-07-18 Thread Kallol Nandi
How to go about scheduled backup in Postgresql. What are the exact steps to be followed? Does anyone know this?   Thanks and Regards, Kallol.  

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Shridhar Daithankar
On 18 Jul 2003 at 15:58, Kallol Nandi wrote: > How to go about scheduled backup in Postgresql. You need to use cron and pgdump. Man pages for both of them will give you what you want. Bye Shridhar -- Cohen's Law:There is no bottom to worse. ---(end of broadcast)--

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Viorel Dragomir
AIL PROTECTED]> To: "Pgsql-General" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 1:35 PM Subject: Re: [GENERAL] Scheduled back up > On 18 Jul 2003 at 15:58, Kallol Nandi wrote: > > How to go about scheduled backup in Postgresql. > > You need to use cron and pgdu

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Tino Wildenhain
IL PROTECTED]> Sent: Friday, July 18, 2003 1:35 PM Subject: Re: [GENERAL] Scheduled back up On 18 Jul 2003 at 15:58, Kallol Nandi wrote: How to go about scheduled backup in Postgresql. You need to use cron and pgdump. Man pages for both of them will give you what you want. Bye Sh

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Viorel Dragomir
Wildenhain" <[EMAIL PROTECTED]> To: "Viorel Dragomir" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Pgsql-General" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 4:23 PM Subject: Re: [GENERAL] Scheduled back up > Hi Viorel, > > what are th

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Andrew Sullivan
On Fri, Jul 18, 2003 at 01:39:19PM +0300, Viorel Dragomir wrote: > As i experienced with pg_dump it looks like in ver.7.3 requires interactive > enter password for *custom users*. I don't know what a custom user is, but if you put the password in ~/.pgpass, authentication happens automatically. T

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Viorel Dragomir
- Original Message - From: "Andrew Sullivan" <[EMAIL PROTECTED]> To: "Pgsql-General" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 2:45 PM Subject: Re: [GENERAL] Scheduled back up > On Fri, Jul 18, 2003 at 01:39:19PM +0300, Viorel Dragomir wrote: &

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Tom Lane
"Viorel Dragomir" <[EMAIL PROTECTED]> writes: >> I don't know what a custom user is, but if you put the password in >> ~/.pgpass, authentication happens automatically. That's a new >> feature in 7.3.x. > But I can't do that, the users that are granted to use the database don't > have any user id

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Viorel Dragomir
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Viorel Dragomir" <[EMAIL PROTECTED]> Cc: "Andrew Sullivan" <[EMAIL PROTECTED]>; "Pgsql-General" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 4:41 PM Subjec

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Csaba Nagy
On Fri, 2003-07-18 at 15:49, Viorel Dragomir wrote: > > No, .pgpass is sought in the home directory of the user running pg_dump > > (or any other client program). It's not a server-side file. > > In my case the user is apache. > I dunno for sure but the apache doesn't have a home directory. > If

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Viorel Dragomir
- Original Message - From: "Csaba Nagy" <[EMAIL PROTECTED]> To: "Viorel Dragomir" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Andrew Sullivan" <[EMAIL PROTECTED]>; "Pgsql-General" <[EMAIL PROTECTED]&

Re: [GENERAL] Scheduled back up

2003-07-18 Thread Andrew Sullivan
On Fri, Jul 18, 2003 at 02:56:53PM +0300, Viorel Dragomir wrote: > > I'm sorry for *custom users*. > The project it's kind of cpanel. > A user can create and grant access for his databases. > And thx to pg_dump he can export & import databases. > So any user that have a db might want to export his