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)
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 |