bricklen wrote:
> On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra wrote:
>> --all you need to do is switch master and slave so that "master"
>> is the one box you are currently on
>
> That probably isn't a reasonable solution, considering the OP
> mentioned that she was not a professional DBA. Set
>A pg_dump from one system or the other will effectively overwrite the
database it is restored to, so any changes in one system or the other will
be lost
yes, as said, the pre-condition is that she is the one and only possible
data producer.
On 9 August 2013 16:24, bricklen wrote:
> On Fri, Aug
On Fri, Aug 9, 2013 at 8:12 AM, Bèrto ëd Sèra wrote:
> or you can just take a full dump from one box and import it on the other
> any time you switch. If it's not a big db it should probably be quicker
> than any alternative approach.
>
A pg_dump from one system or the other will effectively over
or you can just take a full dump from one box and import it on the other
any time you switch. If it's not a big db it should probably be quicker
than any alternative approach.
On 9 August 2013 16:10, Bèrto ëd Sèra wrote:
> not sure having to write stuff any time you do even the smallest thing o
not sure having to write stuff any time you do even the smallest thing on
your table is more reasonable of taking the pain to write (or ask friends
to help you writing) a couple of bash scripts that will do the job forever.
But then again, this is true if and only if she is the one and only user
wh
On Fri, Aug 9, 2013 at 7:36 AM, Bèrto ëd Sèra wrote:
> --all you need to do is switch master and slave so that "master" is the
> one box you are currently on
>
That probably isn't a reasonable solution, considering the OP mentioned
that she was not a professional DBA. Setting up a hot/warm standb
sorry, half asleep and typing rubbish.
--all you need to do is switch master and slave so that "master" is the one
box you are currently on
On 9 August 2013 15:35, Bèrto ëd Sèra wrote:
> if it's only you using it, all you need to do is switch master and server
> so that "server" is the one box
if it's only you using it, all you need to do is switch master and server
so that "server" is the one box you are currently on. If both boxes produce
data at the same time you need a lot of work to manage row versioning.
On 9 August 2013 15:27, Paula Kirsch wrote:
> Hi. I'm looking for suggesti
