restoring a shadow

From: Turbo Fredriksson <turbo(at)bayour(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: restoring a shadow
Date: 2001-12-07 10:32:46
Message-ID: 87vgfj9v75.fsf@papadoc.bayour.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In my attempts of trying to increase performance and redundancy, I
have trying to get rServ replication to work.

I have successfully been able to replicate between two databases on
localhost.

test -> Main db
test_slave -> Slave db

The 'test' database is located in PGDATA (/var/lib/pgsql/data), and
'test_slave' in PGDATA2 (/var/lib/pgsql/data2). Works fine (although
I'm a little unhappy about the replication speed).

Now, I'd like to have PGDATA in a ram disk (we're only expecting a
maximum of 10-15Mb of data). The problem is if the machine is being
reset (hardware vice) or if it crashes. Then the ram disk is
lost. This is where PGDATA2 comes into play...

I've been experimenting with renitialize the PGDATA directory
structure, and doing a

insert into pg_database values
('test_slave', 26, 0, 'f', 't', 18539, 'PGDATA2');

Also, a link from PGDATA2/base/709432 -> PGDATA/base/709432 is made
(this is what the 'original' PGDATA directory/pg_database table have).

Unfortunatly this give me:

FATAL 1: Database "test_slave" does not exist.
The database subdirectory '/var/lib/pgsql/data/base/18720' is missing.

--
Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just
^^^^^ / /(_)_ __ _ ___ __ selective about who its friends are
/ / | | '_ \| | | \ \/ / Debian Certified Linux Developer
_ /// / /__| | | | | |_| |> < Turbo Fredriksson turbo(at)bayour(dot)com
\\\/ \____/_|_| |_|\__,_/_/\_\ Gothenburg/Sweden

domestic disruption Albanian [Hello to all my fans in domestic
surveillance] Iran toluene Noriega Nazi 767 plutonium colonel Serbian
Panama cryptographic radar subway
[See http://www.aclu.org/echelonwatch/index.html for more about this]

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Turbo Fredriksson 2001-12-07 11:43:29 Re: restoring a shadow
Previous Message Nicolas Verger 2001-12-07 09:45:05 Patch : Re: JDBC improvements