Quoting Tom Lane [EMAIL PROTECTED]:
Ciprian Popovici [EMAIL PROTECTED] writes:
That is, a 8.0 which started on a 7.4.2 repository. After noticing,
I switched back to 7.4.2, but now it gives this error and won't start:
I think you are omitting some relevant information, like what you did
Oh, and FWIW, when I try a pg_dump on the database recovered with
pg_resetxlog, I get this:
pg_dump: missing pg_database entry for database db
--
Ciprian Popovici
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL
that is. :) True, I haven't been able
to recover that repository. Fortunately, the setback was minor, since I did
have a recent enough backup. Once again, the absolute rule is always make
a backup.
--
Ciprian Popovici
---(end of broadcast)---
TIP 7
.
-
Then I use -f and it resets, but to no use.
I also tried recompiling 7.4.2 (I install it from source anyway) but
no use.
I did a backup of the repository before I attempted the reset.
Is there any other way I can try to recover the database?
--
Ciprian Popovici
for the entire table, but you need something like a serial restricted
to just a group of rows.
--
Ciprian Popovici
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Sun, 19 Dec 2004 13:51:39 + Ragnar Hafsta [EMAIL PROTECTED] wrote:
On Sun, 2004-12-19 at 15:02 +0200, Ciprian Popovici wrote:
On Sat, 18 Dec 2004 11:07:37 -0600 Bruno Wolff III [EMAIL PROTECTED]
wrote:
On Fri, Dec 17, 2004 at 11:10:12 -,
Filip Wuytack [EMAIL PROTECTED] wrote
don't seem to have something useful. The arguments to the
trigger could help, but can they be made dynamical? Is there any way
of identifying the affected rows?
--
Ciprian Popovici
---(end of broadcast)---
TIP 2: you can get off all lists at once
Ignore my previous question. The special variable OLD is defined
for DELETE fired triggers as well.
--
Ciprian Popovici
---(end of broadcast)---
TIP 8: explain analyze is your friend
you're trying to do?
No, you understood right. Yes, I will have to go with triggers instead.
Thanks for the input.
--
Ciprian Popovici
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
in the common table? I expect
that would break the whole referential integrity thingy, but that would be
useful right about now. Really, I don't want the entire referential
integrity thing, I just want the automatic delete/update half.
--
Ciprian Popovici
---(end of broadcast
10 matches
Mail list logo
