Re: Postgres and backup/restore

[Mike Dewhirst]

On 7/02/2014 10:51am, Simon Riggs wrote:

On 7 February 2014 00:31, Mike Dewhirst  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










--
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+unsubscr...@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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/52F4786C.9080407%40dewhirst.com.au.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Postgres and backup/restore

[Simon Riggs]

On 7 February 2014 00:31, Mike Dewhirst  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

-- 
 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+unsubscr...@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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CA%2BU5nMLJ6AbC7AdF5ixV0ni_HPfzEZ2XpmPwXoKRdwV2vnSQDA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Postgres and backup/restore

[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.







--
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+unsubscr...@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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/52F41B3D.5010407%40dewhirst.com.au.
For more options, visit https://groups.google.com/groups/opt_out.

Re: Postgres and backup/restore

[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

On Feb 6, 2014, at 3:07 PM, 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.
> 
> 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
> 
> -- 
> 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+unsubscr...@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.
> 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.

-- 
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+unsubscr...@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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/507345A1-916B-4DC8-8233-6073CB64F184%40ipstreet.com.
For more options, visit https://groups.google.com/groups/opt_out.

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

-- 
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+unsubscr...@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.
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.