Replication to tmpfs mount

From: Stu <stu(at)roadtrip2001(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Replication to tmpfs mount
Date: 2013-06-02 22:10:23
Message-ID: CAMQAHpoKP6zVt+WysKcXBG7Yv46Tgp4n38ZD+xsw_Dmsq0W5Ow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I'm having a curious problem, I have set up 3 servers - a master and two
slaves using the built in replication options. Everything works as
expected, when I make changes on the master and the slaves automatically
are updated. My next task was to have one of the slave databases running in
memory only - I mounted a tmpfs to /home/faster on one slave and left
/home/faster as a regular folder on the master and slave.

When creating a database using the new Namespace the slave without the
tmpfs mount works fine however the one using the tmpfs does not, I get a
message telling my the namespaces subdirectory is not found. Indeed when I
look on the server it has not replicated anything to the tmpfs share -
other databases using the default namespace continue to work as expected.

Workaround - I scped the namespace as a tarball from the master to the
slave and extracted it into the tmpfs mount. This somehow fixes the problem
as once that has been done I can create other databases in that Namespace,
make changes etc. Everything appears to replicate after I do the SCP.

Anyone have any experience with this - I am a beginner so could be missing
something obvious without realising it.There does not appear to be any
helpful syslog messages.

Thanks in advance for any help,

Version = 9.2.4-1PGDG.rhel6
(Red Hat 6.4 x64)

Browse pgadmin-support by date

  From Date Subject
Next Message Tomasz Wrzodak 2013-06-03 07:46:37 Lost characters when typing
Previous Message Milan Perovic 2013-06-02 19:46:20 Re: SQL window in 1.16.1