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
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
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 &
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-
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