Hi All,
even with PITR not in place yet, how far is it possible to use the xlog to
restore a database (beyond redo-after-crash)? Suppose I lose my data
partition, but have an archive of my xlog and clog, and occasional pg_dumps,
it probably won't be as simple as restoring from the dump, stopping p
On Friday 21 May 2004 06:24 pm, Jeff Davis wrote:
> On Fri, 2004-05-21 at 14:33, Carl E. McMillin wrote:
> > Scenario:
> >
> > SELECT ... WHERE cart_id=X FOR UPDATE
> >
> > IF (NOT FOUND) THEN
> > BEGIN
> > --Here is where nothing is locked.
> > --No way to guarantee no one else will create a rec
At 07:19 PM 5/20/2004 -0700, Jeff Davis wrote:
Assuming my logic above is correct, there are two other ways I thought
to do it, but both seem considerably more redundant:
(1) I could just get rid of the "quantity" attribute and just insert a
record for each product, then do a view that aggregates t
Hi, everybody!
I already solved it. Thank you.
First of, I forgot to mention the version(), so FYI, 7.4.1.
I followed Tom's advice in
http://archives.postgresql.org/pgsql-general/2004-03/msg01073.php
I shut down the PG instance.
postgres -D $PG_DATA -O -P $DBNAME
=# REINDEX DATABASE tbc_gamma
