X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC60ADA470 for ; Sat, 15 Oct 2005 23:21:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94726-07 for ; Sun, 16 Oct 2005 02:21:29 +0000 (GMT) Received: from secure.internetverket.se (unknown [62.65.105.10]) by svr1.postgresql.org (Postfix) with ESMTP id A41A6DA463 for ; Sat, 15 Oct 2005 23:21:31 -0300 (ADT) Received: from rogercud6b5ksq (host-83-166-7-170.serva.net [83.166.7.170]) (authenticated bits=0) by secure.internetverket.se (8.12.10/8.12.10) with ESMTP id j9G2KkxI006008 for ; Sun, 16 Oct 2005 04:20:47 +0200 Message-ID: <003901c5d1f8$9c89d360$03997483@rogercud6b5ksq> From: "Roger Strandberg / Hamsta" To: Subject: Table Space and mfs file system Date: Sun, 16 Oct 2005 04:23:34 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0036_01C5D209.5F3E6370" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.078 required=5 tests=[FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/175 X-Sequence-Number: 19247 This is a multi-part message in MIME format. ------=_NextPart_000_0036_01C5D209.5F3E6370 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I have a need for a table to be placed on a mfs disk. And my question is: In case of a reboot, how can i rebuild the table on the tablespace that = was lost? My configuration is and more: HTML_MASTER DB -> Slony -> HTML_SLAVE DB HTML_MASTER DB sits on one site to create the data for HTML access HTML_SLAVE sits on the apache server. I have also a HTML_MEMORY DB with will have peace loaded in memory for = quick search. My thinking was to let slony forward data from HTML_SLAVE to = HTML_MEMORY. But now i start to think to dump the HTML_SLAVE once per night and load = it as HTML_MEMORY.... Any sugestions on how i can recover from a reboot or power failure..... Best Regards Roger Strandberg ------=_NextPart_000_0036_01C5D209.5F3E6370 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi
 
I have a need for a table to be placed = on a mfs=20 disk.
 
And my question is:
 
In case of a reboot, how can i rebuild = the table on=20 the tablespace that was lost?
 
 
 
 
My configuration is and = more:
 
HTML_MASTER DB -> Slony -> = HTML_SLAVE=20 DB
 
HTML_MASTER DB sits on one site to = create the data=20 for HTML access
HTML_SLAVE sits on the apache = server.
 
I have also a HTML_MEMORY DB with will = have peace=20 loaded in memory for quick search.
 
My thinking was to let slony = forward data from=20 HTML_SLAVE to HTML_MEMORY.
 
But now i start to think to dump the = HTML_SLAVE=20 once per night and load it as HTML_MEMORY....
 
Any sugestions on how i can recover = from a reboot=20 or power failure.....
 
Best Regards
Roger = Strandberg
------=_NextPart_000_0036_01C5D209.5F3E6370--