Re: [ADMIN] Backup Scheduler...

2007-08-06 Thread Jayakumar_Mukundaraju
Dear Richard, Thanks for the timely help... I did same as u sent.. Now it is working fine... Once again thankyou, Thanks & Regards Jayakumar M India. From: Richard Broersma Jr [mailto:[EMAIL PROTECTED] Sent: Thu 7/26/2007 7:30 PM To: Jayakumar_Mukundaraju; V

Re: [ADMIN] PITR with rsync

2007-08-06 Thread Srinivas Kotapally
Would a simple diff between 2 pg_dumps work if only data is being added in the database (i.e. no alters or tables are added)? So say I do a pg_dump once a day and one every 3 hrs there after and in the script I do a diff and store as a PITR dump. Will that work, or is it too simplistic? -Ori

Re: [ADMIN] PITR with rsync

2007-08-06 Thread Tom Lane
David Bear <[EMAIL PROTECTED]> writes: > On Mon, Aug 06, 2007 at 08:27:13PM -0400, Tom Lane wrote: >> I suppose you could, but what's the point? Copying a single file that >> doesn't currently exist on the destination plays to none of rsync's >> strengths. > well, I was using rysnc so I could cop

Re: [ADMIN] PITR with rsync

2007-08-06 Thread David Bear
On Mon, Aug 06, 2007 at 08:27:13PM -0400, Tom Lane wrote: > David Bear <[EMAIL PROTECTED]> writes: > > I'm still uncomfortable with using the file system style backup method > > in PITR and am very interested in ' more information ' on how others > > may be doing backups. Specifically, I assume tha

Re: [ADMIN] PITR with rsync

2007-08-06 Thread Tom Lane
David Bear <[EMAIL PROTECTED]> writes: > I'm still uncomfortable with using the file system style backup method > in PITR and am very interested in ' more information ' on how others > may be doing backups. Specifically, I assume that PITR methods would > also be accompanied with some combination o

[ADMIN] PITR with rsync

2007-08-06 Thread David Bear
I've been looking at the pages on PITR and am wondering if anyone has tried using rsync to accomplish this. I'm still uncomfortable with using the file system style backup method in PITR and am very interested in ' more information ' on how others may be doing backups. Specifically, I assume that

Re: [ADMIN] WAL segment question

2007-08-06 Thread Donald Fraser
- Original Message - From: Chander Ganesan > DRBD is a synchronous method of transferring data - it's not asynchronous. Assuming you are using Protocol C you should find that both are always in sync. If you are using protocol B then things will be in sync so long as the remote system did

Re: [ADMIN] Recovery from Current WAL (8.2)

2007-08-06 Thread Chander Ganesan
j a wrote: From my reading, I can use PITR recovery to restore my database to its state just prior to a recent change (not even an hour ago). The erroneous change resulted from an UPDATE with no WHERE on a small table (<700 rows); I mention this only in case there is a simpler recovery techniq

Re: [ADMIN] WAL segment question

2007-08-06 Thread Chander Ganesan
Donald Fraser wrote: Our company has two sites, a master and a disaster recovery site. I am trying to assess whether data has been lost during a fail-over, due to the asynchronous method of transporting WAL file data between sites (we use DRBD). Disaster recovery node start-up log: user= pid=

Re: [ADMIN] libpq.dll as part of PGDB module: access to PostgreSQL from Python

2007-08-06 Thread ekzept
Thanks, Ryan. That worked. Seems to me that either the doc needs to be better on this point, or the installation should do this properly. - jt On Aug 6, 9:47 am, [EMAIL PROTECTED] (Ryan Davis) wrote: > Python is looks for them on a path, and I'm a little fuzzy on which path > it was looking in

Re: [ADMIN] libpq.dll as part of PGDB module: access to PostgreSQL from Python

2007-08-06 Thread Ryan Davis
Python is looks for them on a path, and I'm a little fuzzy on which path it was looking in, so I just copied the postgres DLLs into site-packages. I got this working by copying the following DLLs from C:\Program Files\pgAdmin III\1.6 to C:\Python25\Lib\site-packages: * comerr32.dll * krb5