[ADMIN] Online Backups with 8.0 -- Confused

2005-03-31 Thread Jason DiCioccio
Greetings, I am having some trouble figuring out exactly what I'm supposed to be doing to successfully recover from an online backup. I am not in a critical situation or anything, simply doing some testing to make sure that my backup system would work. Here's the problem: I do a 'SELECT pg_s

Re: [ADMIN] Online Backups with 8.0 -- Confused

2005-03-31 Thread Jason DiCioccio
Simon, On Mar 31, 2005 7:29 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > In retrospect, there is a slight timing error between end backup and > archival of next WAL log. The first-release design for PITR didn't fully > cover lower traffic situations, so in those cases the timing error > becomes

[ADMIN] PITR/Online Backups? When can I delete archived WAL logs?

2005-04-02 Thread Jason DiCioccio
n it said not to. Also, am I doing this right at all? Does anyone have a script they are using for this? Thanks in advance, Jason DiCioccio ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send &

Re: [ADMIN] PITR/Online Backups? When can I delete archived WAL logs?

2005-04-02 Thread Jason DiCioccio
Tom,   Sorry.. I sent this a while ago (before my previous message).  It was just sitting in the moderation queue because I was not subscribed to the list at the time.   Please disregard it :) Regards, -JD-

Re: [ADMIN] is this normal?

2005-04-04 Thread Jason DiCioccio
Greetings, On Apr 4, 2005 9:27 AM, Chuming Chen <[EMAIL PROTECTED]> wrote: > Dear all, > > I have a postgresql database. > > "du -ks /var/lib/pgsql/data" gives me the following disk usage > 45592808/var/lib/pgsql/data (about 44G) > > But after I did a pg_dump, the dump file only has the siz