Postgres and backup/restore

[Lachlan Musicman]

Hola,

What are people's recommendations for postgres db backup solutions?

I've just installed django-dbbackup and will give it a try, but
thought I'd ask what others were using.

cheers
L.





--
From this perspective it is natural that anarchism be marked by
spontaneity, differentiation, and experimentation that it be marked by
an expressed affinity with chaos, if chaos is understood to be what
lies outside or beyond the dominant game or system. Because of the
resistance to definition and categorisation, the anarchist principle
has been variously interpreted as, rather than an articulated
position, “a moral attitude, an emotional climate, or even a mood”.
This mood hangs in dramatic tension between utopian hope or dystopian
nihilism...
-----
http://zuihitsu.org/godspeed-you-black-emperor-and-the-politics-of-chaos

[John DeRosa]

pg_dump is all you need, if your db is small enough. It generates a consistent backup.

pg_dump, zip, stash it in a cloud container named “backup" is what we do.

John

> --
> 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...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGBeqiMREb74W8jX-5wTFL4Btg7C4NYC6fipL%2B%3DXB91nqD7xKg%40mail.gmail.com.
> For more options, visit https://groups.google.com/groups/opt_out.

[Mike Dewhirst]

On 7/02/2014 10:07am, Lachlan Musicman wrote:
> Hola,
>
> What are people's recommendations for postgres db backup solutions?
>
> I've just installed django-dbbackup and will give it a try, but
> thought I'd ask what others were using.

Daily dump to a file which is backed up across the network.

http://www.postgresql.org/docs/9.3/static/app-pgdump.html

I'm planning to do something clever with the transaction log
continuously writing it to another machine but I haven't done that yet.

One day real soon now.

>
> cheers
> L.
>
>
>
>
>

[Simon Riggs]

Today is good. Streaming replication does exactly that.

http://www.postgresql.org/docs/9.3/static/warm-standby.html#STREAMING-REPLICATION

--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

[Mike Dewhirst]

On 7/02/2014 10:51am, Simon Riggs wrote:
> On 7 February 2014 00:31, Mike Dewhirst <mi...@dewhirst.com.au> wrote:
>> On 7/02/2014 10:07am, Lachlan Musicman wrote:
>>>
>>> Hola,
>>>
>>> What are people's recommendations for postgres db backup solutions?
>>>
>>> I've just installed django-dbbackup and will give it a try, but
>>> thought I'd ask what others were using.
>>
>>
>> Daily dump to a file which is backed up across the network.
>>
>> http://www.postgresql.org/docs/9.3/static/app-pgdump.html
>>
>> I'm planning to do something clever with the transaction log continuously
>> writing it to another machine but I haven't done that yet.
>>
>> One day real soon now.
>
> Today is good. Streaming replication does exactly that.
>
> http://www.postgresql.org/docs/9.3/static/warm-standby.html#STREAMING-REPLICATION

You are absolutely right and it is one of the primary reasons I chose
Postgres.

Streaming replication is in my project's future not only for backup but
also for read-only output from replication machines. We are not that far
advanced yet.

Earlier instead of "I haven't done that yet" I should have said "I
havn't hired a professional DBA yet" ;)

Thanks Simon

Mike






>