[GENERAL] High availability and load balancing ...

Hi, I need to do the setup for High availability function. Also want to implement load balancing for 02 nodes. I think PGPool will be require for that. Can I use PGPool without cost. Can I get the basic steps to do this setup? Database-- Postgresql 9.1

Re: [GENERAL] Re-sync slave server

On 06/07/2016 03:22 PM, Patrick B wrote: One more question guys... Does the pg_basebackup re-write the data? or do I have to have free space? Like.. the DB is 2 TB.. do I have to have more 2TB? or it will use those 2TB that already are there? I would suggest taking a tour of:

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

Thanks Adrian... it's working ;)

Re: [GENERAL] Re-sync slave server

One more question guys... Does the pg_basebackup re-write the data? or do I have to have free space? Like.. the DB is 2 TB.. do I have to have more 2TB? or it will use those 2TB that already are there? cheers

[GENERAL] BDR Custom Conflict Handler

There appears to be absolutely zero documentation regarding the expected format of a custom conflict handler function. I'm attempting to define a custom conflict handler for a test bdr cluster. When I tried to register a generic function with no parameters I get a somewhat useful error message

Re: [GENERAL] Re-sync slave server

Anyway.. will do the pg_basebackup and see how it goes... cheers guys Patrick 2016-06-08 8:41 GMT+12:00 Patrick B : > yep.. pg_basebackup the problem is that the servers are in a > different country.. and the DB is 2TB > > the pg_basebackup will probably fail and

Re: [GENERAL] Re-sync slave server

yep.. pg_basebackup the problem is that the servers are in a different country.. and the DB is 2TB the pg_basebackup will probably fail and I'll have to do a DUMP as I've already done with another slave time ago

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

John R Pierce wrote: > On 6/6/2016 4:09 PM, Alvaro Herrera wrote: > >I have no idea about Windows filesystems but you may be able to > >"undelete" the files, as long as you don't touch the partition for > >anything else; search the web for "undelete ntfs". Once you undelete > >you will need to

Re: [GENERAL] Re-sync slave server

On Mon, Jun 6, 2016 at 5:32 PM, Patrick B wrote: > My set up: > > > Master --> slave01 (streaming replication) --> slave02 (streaming > replication) > Master --> slave03 (wal_files 4 days old, not streaming replication) > > The wal_files are stored into each server. >

Re: [GENERAL] Re-sync slave server

On 06/06/2016 05:32 PM, Patrick B wrote: My set up: Master --> slave01 (streaming replication) --> slave02 (streaming replication) Master --> slave03 (wal_files 4 days old, not streaming replication) The wal_files are stored into each server. But when the slave03 was down, the wal_files

Re: [GENERAL] PL/PGSQL + inserts+updates+limit - Postgres 9.3

On 06/06/2016 09:01 PM, Patrick B wrote: Ok so guys CREATE or REPLACE FUNCTION function_data_1() RETURNS SETOF bigint AS $$ declare row record; BEGIN [...] FOR row IN EXECUTE ' SELECT

[GENERAL] 2 node bdr setup gives error in replication slots

I am getting below error in my 2 node BDR setup. postgres going down. any idea? <35382016-06-07 10:16:59 GMT%LOG: database system was interrupted; last known up at 2016-06-07 09:06:44 GMT <35382016-06-07 10:16:59 GMT%PANIC: replication slot file