(Please reply to the list so everyone can keep track of the thread)
You’ll need to look at the table definitions to work out what the data should
look like, and if it doesn’t look like that – then it’s probably part of the
corrupt data…
-Original Message-
From: Anibal David Aco
Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit :
> We are setting up a new database system that is going to act as our
> central database. We are planning to have a Master/Slave setup,
> originally with one slave but there is a strong possibility of adding a
> second slave at our second si
Hi,
On Sat, Oct 20, 2007 at 10:36:00AM -, yogesh wrote:
> I have to install the Postgres SQL on the Suse
> LinuxGuide me with suitable steps to take..which version i
> ave to use for postgres.
Quick and simple: Use RPMs provided by SuSE.
Still stimple: Use the latest 8.
On 10/22/07, cho <[EMAIL PROTECTED]> wrote:
>
> Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit:
>
> > We are setting up a new database system that is going to act as our
> > central database. We are planning to have a Master/Slave setup,
> > originally with one slave but there is a strong p
cho wrote:
Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit :
Have a look at pgpool-I or pgpool-II in replication mode.
Pgpool proxies SQL requests, so that requests on one server are replayed
on the other. pgpool-I is limited to two nodes, whereas pgpool-II is not.
Latency is importan
Really all file content after
object definitions looks like "Encoded/Encrypted" and when I do a
restore all table data are restored successfully (except one, that is
in the "corrupted sector"). So, maybe the pg_dump do a encrypt or
something like that over the DATA content.
Thanks.
Phillip
On 10/22/07, Anibal David Acosta <[EMAIL PROTECTED]> wrote:
>
> Really all file content after object definitions looks like
> "Encoded/Encrypted" and when I do a restore all table data are restored
> successfully (except one, that is in the "corrupted sector"). So, maybe the
> pg_dump do a encrypt
I'm running on 7.4.5 (pre bgwriter) and moving to 8.2 in 3 weeks. I turn
fsync off on my testing server. When I update a table I expect the file in
the base directory to remain the same size until the next syncpoint when it
would then update. But it increases immediately. I thought updates remain i
Thanks Tom, every piece of new information adds to my education.
I'm going to put to bed this effort of trying to verify BGWRITER,
knowing that it works in 8.2 and move on.
Regards,
Mark Steben
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, October 22, 2007 2:
"Mark Steben" <[EMAIL PROTECTED]> writes:
> I'm running on 7.4.5 (pre bgwriter) and moving to 8.2 in 3 weeks. I turn
> fsync off on my testing server. When I update a table I expect the file in
> the base directory to remain the same size until the next syncpoint when it
> would then update. But it
10 matches
Mail list logo
