On 2 July 2013 05:49, Mike Dewhirst wrote:
On Monday, July 1, 2013 10:32:53 PM UTC+10, si...@2ndquadrant.com wrote:

On 1 July 2013 13:02, Mike Dewhirst wrote:

On 1/07/2013 9:35pm, Tom Evans wrote:

On Sun, Jun 30, 2013 at 11:24 PM, Mike Dewhirst <mi...@dewhirst.com.au>
mulianto and Avraham

Thanks for your suggestions. Dumping data isn't the entire problem -
is this:

There will be an *ongoing* need to add new data from tables in one
to the same-named tables in another database on a remote machine. Two
of the
tables are in a m2m relationship.
You can use direct access via "foreign tables" the name of the Postgres
distributed database feature.

I read the sql-**createforeigntable<http://www.postgresql.org/docs/devel/static/sql-createforeigntable.html> page
and I think I know what a distributed database is versus a replicated
database. But I have no idea why I would choose one over the other. Can you
Distributed access is more dynamic but likely somewhat slower when access
required. Replication could be thought of as pre-cacheing the data you want
to see.

In any case, I'm 99% sure I should "refactor" (if that's the right word)
the reference tables out of the database into a separate database and get
to that data via a Django router.
Why take them out and then bring them back in? Why not leave where they are
and copy elsewhere?

Not sure how I'll do that just yet but it has to come ahead of a
distribute/replicate solution.
  Simon Riggs http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 11 of 12 | next ›
Discussion Overview
groupdjango-users @
categoriesdjango, python
postedJun 30, '13 at 7:39a
activeJul 2, '13 at 7:13a



site design / logo © 2021 Grokbase