Re: pg data backup from vps

2017-12-01 Thread John R Pierce
On 12/1/2017 12:44 PM, basti wrote: Replication is no backup. Its more like a RAID. That mean tubles that are delete on master by a mistake there are also delete on slave. correct me if i'am wrong. a wal archive plus occasional basebackups lets you restore to any point in time (PITR) covered

Problems with triggers and table lock

2017-12-01 Thread Job
Dear guys, we are using Postgresql 9.6.1 with Rubyrep in order to replicate some tables across two different, and remote, database servers. Since few weeks sometimes when inserting/updating some rows, the statement remains waiting and table seems locked for insert/updates. When i issue "select

Re: pg data backup from vps

2017-12-01 Thread Rory Campbell-Lange
On 01/12/17, support-tiger (supp...@tigernassau.com) wrote: > To diversify risk, we would like to have a daily or weekly data backup > stored in another location besides the VPS service we are using - pg_dump is > great for the backup but transferring a growing db across the internet to a > local m

Re: pg data backup from vps

2017-12-01 Thread basti
Replication is no backup. Its more like a RAID. That mean tubles that are delete on master by a mistake there are also delete on slave. correct me if i'am wrong. Best regards, basti On 01.12.2017 21:10, Melvin Davidson wrote: > > > On Fri, Dec 1, 2017 at 3:07 PM, Rob Sargent

Re: PostgreSQL and Data Warehouse optimizations

2017-12-01 Thread legrand legrand
Hi, Parallel Queries are now available and development is very active for Declarative Partitioning (arrived with pg 10), many new features are currently developped in pg 11, (for exemple hash partition, partition wise ... most regarding partition usage optimizations) see https://commitfest.postgre

Re: pg data backup from vps

2017-12-01 Thread Joshua D. Drake
On 12/01/2017 11:56 AM, support-tiger wrote: To diversify risk, we would like to have a daily or weekly data backup stored in another location besides the VPS service we are using - pg_dump is great for the backup but transferring a growing db across the internet to a local machine disk seems s

Re: pg data backup from vps

2017-12-01 Thread Melvin Davidson
On Fri, Dec 1, 2017 at 3:07 PM, Rob Sargent wrote: > > > On 12/01/2017 12:56 PM, support-tiger wrote: > >> To diversify risk, we would like to have a daily or weekly data backup >> stored in another location besides the VPS service we are using - pg_dump >> is great for the backup but transferrin

Re: pg data backup from vps

2017-12-01 Thread Rob Sargent
On 12/01/2017 12:56 PM, support-tiger wrote: To diversify risk, we would like to have a daily or weekly data backup stored in another location besides the VPS service we are using - pg_dump is great for the backup but transferring a growing db across the internet to a local machine disk seems

pg data backup from vps

2017-12-01 Thread support-tiger
To diversify risk, we would like to have a daily or weekly data backup stored in another location besides the VPS service we are using - pg_dump is great for the backup but transferring a growing db across the internet to a local machine disk seems slow - how are others handling this with postg

Re: large numbers of inserts out of memory strategy

2017-12-01 Thread Steven Lembark
On Thu, 30 Nov 2017 08:43:32 -0600 Ted Toth wrote: > What is the downside of using a DO block? I'd have to do a nextval on > each sequence before I could use currval, right? Or I could do 'select > last_value from '. You are creating a piece of code that has to be parsed, tokenized, and compiled

Sv: Re: Re: Removing INNER JOINs

2017-12-01 Thread Andreas Joseph Krogh
På fredag 01. desember 2017 kl. 03:53:29, skrev David Rowley < david.row...@2ndquadrant.com >: On 1 December 2017 at 15:34, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote:  Can someone please explain, in layman-terms, what the problems with FKs are rela