Re: [GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

2015-01-12 Thread Michael Nolan
On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle wrote: > You should be able to find a cloud provider that could give you many TB. > Or so they like to claim. > > > Nope, but you probably find one willing to SELL you access to many TB. -- Mike Nolan

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Sameer Kumar
​​ On Tue, Jan 13, 2015 at 7:04 AM, Adrian Klaver wrote: > On 01/12/2015 02:16 PM, Antony Gelberg wrote: > >> On Mon, Jan 12, 2015 at 7:08 PM, Adrian Klaver >> wrote: >> >>> >>> On 01/12/2015 08:40 AM, Antony Gelberg wrote: >>> On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver wrot

[GENERAL] Re: Stuck trying to backup large database - best practice? How about a cloud service?

2015-01-12 Thread Bob Futrelle
You should be able to find a cloud provider that could give you many TB. Or so they like to claim. - Bob

[GENERAL] SSO Windows-to-unix

2015-01-12 Thread Jeremy Palmer
Hi All, I'm just investigating the option for configuring SSO for windows clients connecting to a PostgreSQL 9.3 server installed on Ubuntu 14.04. Our windows environment uses a Windows 2012 domain controller. The best information I could find on this subject was http://www.hagander.net/talks/

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Adrian Klaver
On 01/12/2015 02:16 PM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 7:08 PM, Adrian Klaver wrote: On 01/12/2015 08:40 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver wrote: On 01/12/2015 08:10 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 5:31 PM, Adrian K

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Joseph Kregloh
I apologize if it has already been suggested. I already deleted the previous emails in this chain. Have you looked into Barman? My current database is just a tad over 1TB. I have one master, two slaves, and another machine running Barman. The slaves are there for redundancy purposes. Master fails,

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Antony Gelberg
On Mon, Jan 12, 2015 at 7:08 PM, Adrian Klaver wrote: > > On 01/12/2015 08:40 AM, Antony Gelberg wrote: >> >> On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver >> wrote: >>> >>> On 01/12/2015 08:10 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver wrote: >>> pg

Re: [GENERAL] How to analyze a slowdown in 9.3.5?

2015-01-12 Thread Joe Van Dyk
On Sun, Jan 11, 2015 at 8:07 AM, Michael Nolan wrote: > > > On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson > wrote: > >> Just curious. Have you checked that the tables are being vacuum/analyzed >> periodically and that the statistics are up to date? Try running the >> following query to verify

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Bosco Rama
On 01/12/15 08:40, Antony Gelberg wrote: >> In addition are you talking about a single database or the Postgres database >> cluster? > > We only have one database in the cluster, so it's the same thing. Not exactly. For example, with pg_dump you would also need to dump the 'global' context separ

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Adrian Klaver
On 01/12/2015 08:40 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver wrote: On 01/12/2015 08:10 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver wrote: On 01/12/2015 07:20 AM, Antony Gelberg wrote: pg_basebackup: could not get transacti

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Antony Gelberg
On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver wrote: > On 01/12/2015 08:10 AM, Antony Gelberg wrote: >> >> >> >> On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver >> wrote: >>> >>> >>> On 01/12/2015 07:20 AM, Antony Gelberg wrote: pg_basebackup: could not get transaction log end pos

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Adrian Klaver
On 01/12/2015 08:10 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver wrote: On 01/12/2015 07:20 AM, Antony Gelberg wrote: pg_basebackup: could not get transaction log end position from server: ERROR: requested WAL segment 00042B9F00B4 has already been re

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Antony Gelberg
On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver wrote: > > On 01/12/2015 07:20 AM, Antony Gelberg wrote: >> >> pg_basebackup: could not get transaction log end position from server: >> ERROR: requested WAL segment 00042B9F00B4 has already been >> removed >> >> This attempted backup re

Re: [GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Adrian Klaver
On 01/12/2015 07:20 AM, Antony Gelberg wrote: Hi, We have a postgres 9.3.x box, with 1.3TB free space, and our database of around 1.8TB. Unfortunately, we're struggling to back it up. When we try a compressed backup with the following command: pg_basebackup -D "$BACKUP_PATH/$TIMESTAMP" -Ft -Z

[GENERAL] Stuck trying to backup large database - best practice?

2015-01-12 Thread Antony Gelberg
Hi, We have a postgres 9.3.x box, with 1.3TB free space, and our database of around 1.8TB. Unfortunately, we're struggling to back it up. When we try a compressed backup with the following command: pg_basebackup -D "$BACKUP_PATH/$TIMESTAMP" -Ft -Z9 -P -U "$DBUSER" -w we get error: pg_baseback