On Wed, Oct 11, 2006 at 11:13:21AM +0700, Luki Rustianto wrote:
> ... so what if the database size is above 20 GB, do we have to do
> pg_dump each at periodics time to get reliable backup?
No, you can also use Point In Time Recovery (PITR).
--
Jim Nasby
> The pg_dump backup is a better bet.
>
> If you are really desperate to recover the latest changes, try
> pg_resetxlog then pg_dump, and diff the dump file against your good
> pg_dump to see which changes you want to believe and apply. But I'd
> still say you want to initdb and restore from the
... so what if the database size is above 20 GB, do we have to do
pg_dump each at periodics time to get reliable backup?
On 10/11/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> I found the correct log file.
> 2006-10-10 04:57:45 PDT% LOG: could not op
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> I found the correct log file.
> 2006-10-10 04:57:45 PDT% LOG: could not open file
> "pg_xlog/00010055"
>(log file 0, segment 85): No such file or
> directory
> 2006-10-10 04:57:45 PDT% LOG: could
On Tue, Oct 10, 2006 at 05:31:08PM -0700, Richard Broersma Jr wrote:
> My test server's sw/raid array recently died where I kept my PostgreSQL data
> directory. I have
> both a full dump of the database and a file system back-up of the data
> directory.
>
> I tried to restore my file system bac
> oops, my mistake the exit code is 0 not 127.
> > My test server's sw/raid array recently died where I kept my PostgreSQL
> > data directory. I
> have
> > both a full dump of the database and a file system back-up of the data
> > directory.
> >
> > I tried to restore my file system back-up fir
oops, my mistake the exit code is 0 not 127.
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> My test server's sw/raid array recently died where I kept my PostgreSQL data
> directory. I have
> both a full dump of the database and a file system back-up of the data
> directory.
>
> I tried
My test server's sw/raid array recently died where I kept my PostgreSQL data
directory. I have
both a full dump of the database and a file system back-up of the data
directory.
I tried to restore my file system back-up first since it is a "fresher" copy.
However, I am
unable to start postgres
