PostgreSQL Backup Booklet

Started by Shaun Thomasabout 13 years ago9 messagesgeneral
Jump to latest
#1Shaun Thomas
sthomas@optionshouse.com

Hey!

So, Packt approached me a few months ago and asked me to put together a
very basic series of short step-by-step instructions on backing up
PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-to."

I tried to cover all of the basic approaches used by most admins, and I
tested it on a guy at work who's a SQL Server DBA but recently took over
care and feeding of a PG database. He said it was easier to understand
than the documentation, at least for just getting everything working and
sorting out more advanced details later.

I know it's not exactly Greg Smith's performance book, but I'm glad to
contribute how I can. I'm not entirely sure it's worth adding to the
book page:

http://www.postgresql.org/docs/books/

But if it is, I'll provide any help or extra information necessary. If
anyone has questions, I'm here to answer them. :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Carlos Mennens
carlos.mennens@gmail.com
In reply to: Shaun Thomas (#1)
Re: PostgreSQL Backup Booklet

Based on Amazon reviews and others in the PG community, I would 100% get
something like this. High Availability / Fail Over are my biggest concerns
with PostgreSQL Database.

Thanks so much for sharing and good luck!!!

On Wed, Apr 3, 2013 at 10:09 AM, Shaun Thomas <sthomas@optionshouse.com>wrote:

Hey!

So, Packt approached me a few months ago and asked me to put together a
very basic series of short step-by-step instructions on backing up
PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-to."

I tried to cover all of the basic approaches used by most admins, and I
tested it on a guy at work who's a SQL Server DBA but recently took over
care and feeding of a PG database. He said it was easier to understand than
the documentation, at least for just getting everything working and sorting
out more advanced details later.

I know it's not exactly Greg Smith's performance book, but I'm glad to
contribute how I can. I'm not entirely sure it's worth adding to the book
page:

http://www.postgresql.org/**docs/books/&lt;http://www.postgresql.org/docs/books/&gt;

But if it is, I'll provide any help or extra information necessary. If
anyone has questions, I'm here to answer them. :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________**________________

See http://www.peak6.com/email_**disclaimer/&lt;http://www.peak6.com/email_disclaimer/&gt;for terms and conditions related to this email

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-general&lt;http://www.postgresql.org/mailpref/pgsql-general&gt;

--
Carlos Mennens

#3Igor Neyman
ineyman@perceptron.com
In reply to: Shaun Thomas (#1)
Re: PostgreSQL Backup Booklet

-----Original Message-----
From: Shaun Thomas [mailto:sthomas@optionshouse.com]
Sent: Wednesday, April 03, 2013 10:09 AM
To: PostgreSQL General
Subject: PostgreSQL Backup Booklet

Hey!

So, Packt approached me a few months ago and asked me to put together a
very basic series of short step-by-step instructions on backing up
PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-
to."

I tried to cover all of the basic approaches used by most admins, and I
tested it on a guy at work who's a SQL Server DBA but recently took
over care and feeding of a PG database. He said it was easier to
understand than the documentation, at least for just getting everything
working and sorting out more advanced details later.

I know it's not exactly Greg Smith's performance book, but I'm glad to
contribute how I can. I'm not entirely sure it's worth adding to the
book page:

http://www.postgresql.org/docs/books/

But if it is, I'll provide any help or extra information necessary. If
anyone has questions, I'm here to answer them. :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions
related to this email

Shaun,

Is there plans for e-book edition?

Regards,
Igor Neyman

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Shaun Thomas
sthomas@optionshouse.com
In reply to: Igor Neyman (#3)
Re: PostgreSQL Backup Booklet

On 04/03/2013 12:49 PM, Igor Neyman wrote:

Is there plans for e-book edition?

I believe there already is one. Packt sells it directly, and it's also
listed on Amazon. Way cheaper than the print version, I think. About
five bucks, as opposed to 20.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5Igor Neyman
ineyman@perceptron.com
In reply to: Shaun Thomas (#4)
Re: PostgreSQL Backup Booklet

-----Original Message-----
From: Shaun Thomas [mailto:sthomas@optionshouse.com]
Sent: Wednesday, April 03, 2013 1:51 PM
To: Igor Neyman
Cc: PostgreSQL General
Subject: Re: PostgreSQL Backup Booklet

On 04/03/2013 12:49 PM, Igor Neyman wrote:

Is there plans for e-book edition?

I believe there already is one. Packt sells it directly, and it's also
listed on Amazon. Way cheaper than the print version, I think. About
five bucks, as opposed to 20.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

Just got it from Packt for $5.09.
Amazon has only paperback edition.

Thank you,
Igor Neyman

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#6Joe Van Dyk
joe@tanga.com
In reply to: Shaun Thomas (#1)
Re: PostgreSQL Backup Booklet

On Wed, Apr 3, 2013 at 7:09 AM, Shaun Thomas <sthomas@optionshouse.com>wrote:

Hey!

So, Packt approached me a few months ago and asked me to put together a
very basic series of short step-by-step instructions on backing up
PostgreSQL. The title is "Instant PostgreSQL Backup and Restore How-to."

Links for those who are interested:

http://www.amazon.com/Instant-PostgreSQL-Backup-Restore-How/dp/1782169105

http://www.packtpub.com/how-to-postgresql-backup-and-restore/book

#7Shaun Thomas
sthomas@optionshouse.com
In reply to: Joe Van Dyk (#6)
Re: PostgreSQL Backup Booklet

On 04/03/2013 01:07 PM, Joe Van Dyk wrote:

Links for those who are interested:

Not sure why it's not showing up with the paperback, but the Kindle edition:

http://www.amazon.com/Instant-PostgreSQL-Backup-Restore-ebook/dp/B00C26J204

I've never ordered a kindle eBook since I prefer epub, but there ya go.
Maybe it takes a while to associate them.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#8François Beausoleil
francois@teksol.info
In reply to: Shaun Thomas (#7)
Re: PostgreSQL Backup Booklet

Le 2013-04-03 à 14:10, Shaun Thomas a écrit :

On 04/03/2013 01:07 PM, Joe Van Dyk wrote:

Links for those who are interested:

Not sure why it's not showing up with the paperback, but the Kindle edition:

http://www.amazon.com/Instant-PostgreSQL-Backup-Restore-ebook/dp/B00C26J204

I've never ordered a kindle eBook since I prefer epub, but there ya go. Maybe it takes a while to associate them.

4.90 $CDN

Thanks for that!

François Beausoleil

Attachments:

smime.p7sapplication/pkcs7-signature; name=smime.p7sDownload
#9Quentin Hartman
qhartman@direwolfdigital.com
In reply to: François Beausoleil (#8)
Re: PostgreSQL Backup Booklet

Also, Packt has a deal on their site where if you buy 2 ebooks, you get
them both for half off. This one seems to qualify, so I Was able to get it
for $3, while also getting another book I've been wanting for half what I
was expecting to pay.

Hooray!

QH