I've been experiencing this same problem and think I've finally determined
cause.
In our case, this happens after restoring a database with the script that
results from a pg_dumpall with "clean" option. If we have any triggers
that call functions, the tirggering SQL will always result in a "Cach
=
bbye - ashwini
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I had a hardware error on my server and lost the WAL files. I can
restore my data, but because of the size of the database that'll take at
least 12 hours. Is there any way to start the server without the
transaction logs?
--Nate
---(end of broadcast)---
I had a hardware error on my server and lost the WAL files. I can
restore my data, but because of the size of the database that'll take at
least 12 hours. Is there any way to start the server without the
transaction logs?
--Nate
---(end of broadcast)--
yes, but i can't wait the next release, it's possible to make a module or
something else ?
i think, the postgres TEAM have to make a clustering system like fiber
channel switch
well, i will find more informations about that ...
regards,
michael.
- Original Message -
From: "Adam Erick
>From what I've heard and read postgres does not internally support
replication. Their are 3rd party tools to do it though. I've also heard
they're rather slow.
I was told replication is slated for the next major release (either 7.3 or
8) but I haven't heard anything official. Has anybody else
it is possible to make a database cluster with
postgresql ?
Best regards,
Vergoz Michael
