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: some snippage On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver adrian.kla...@aklaver.com 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

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 adrian.kla...@aklaver.com wrote: On 01/12/2015 08:10 AM, Antony Gelberg wrote: some snippage On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 01/12/2015 07:20 AM, Antony Gelberg wrote: pg_basebackup: could

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 htf...@gmail.com wrote: On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson melvin6...@gmail.com 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

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 adrian.kla...@aklaver.com wrote: On 01/12/2015 08:40 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 01/12/2015 08:10 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 5:31 PM,

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

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 adrian.kla...@aklaver.com wrote: On 01/12/2015 08:40 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 6:23 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 01/12/2015 08:10 AM, Antony Gelberg

[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

[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

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 bob.futre...@gmail.com 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 adrian.kla...@aklaver.com wrote: On 01/12/2015 02:16 PM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 7:08 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 01/12/2015 08:40 AM, Antony Gelberg wrote: On Mon, Jan 12, 2015 at 6:23

[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_basebackup:

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

2015-01-12 Thread Antony Gelberg
some snippage On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver adrian.kla...@aklaver.com 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

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 -Z9

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

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 adrian.kla...@aklaver.com wrote: On 01/12/2015 08:10 AM, Antony Gelberg wrote: some snippage On Mon, Jan 12, 2015 at 5:31 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 01/12/2015 07:20 AM,