Re: [ADMIN] question about wal and point in time recovery

2005-04-18 Thread Bruce Momjian
Tom Lane wrote: > > can the log be modified before recovery occurs. > > Not easily. If you were to hack any one log entry, you'd have to > recompute the CRC checksum for it, and there's no way at all to make > a change that would involve changing the size of a log entry. So > really the only use

Re: [ADMIN] question about wal and point in time recovery

2005-04-13 Thread lst_hoe01
Zitat von "Mohan, Ross" <[EMAIL PROTECTED]>: Thank you! ( would send this to yer eddress directly, but it's decided my biz email is a spam address, or somesuch: http://www.five-ten-sg.com/blackhole.php? ) I guess it is the IP you are sending from : http://openrbl.org/ip/64/74/47/121.htm Regards A

Re: [ADMIN] question about wal and point in time recovery

2005-04-13 Thread Mohan, Ross
ss Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] question about wal and point in time recovery "Mohan, Ross" <[EMAIL PROTECTED]> writes: > In any case, do you have a pointer to this R&R WAL tool? I haven't posted it anywhere, but here is the 8.0 version. Yo

Re: [ADMIN] question about wal and point in time recovery

2005-04-13 Thread Tom Lane
"Mohan, Ross" <[EMAIL PROTECTED]> writes: > In any case, do you have a pointer to this R&R WAL tool? I haven't posted it anywhere, but here is the 8.0 version. You'd build it something like this: PGSQL=(location of PG source tree) CC=gcc CFLAGS=-Wall -O -I $(PGSQL)/src/include xlogdump: xlogdum

Re: [ADMIN] question about wal and point in time recovery

2005-04-13 Thread Mohan, Ross
2005 12:29 AM To: Alex Zendel Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] question about wal and point in time recovery "Alex Zendel" <[EMAIL PROTECTED]> writes: > ... i've been reading up on the wal and point in time recovery in > the online postgre manual. bu

Re: [ADMIN] question about wal and point in time recovery

2005-04-12 Thread Tom Lane
"Alex Zendel" <[EMAIL PROTECTED]> writes: > ... i've been reading up on the wal and point in time recovery in > the online postgre manual. but i have a question about using it: [ obligatory gripe: it's postgres or postgresql, not postgre ] > is it possible to visually read the entries in the log

[ADMIN] question about wal and point in time recovery

2005-04-12 Thread Alex Zendel
hello all, i work in an organization that has a handful of people accessing a few ms access database files. i'm strongly considering porting everything to postgre (as the backend for access) for a number of obvious reasons, one of the most prominent ones would be the availability of a back up v