[GENERAL] cascading replication and replication slots.

2015-06-23 Thread Leif Gunnar Erlandsen
Is it possible to use a replication_slot for a downstream-server when setting up cascading replication on 9.4 Leif G.

Re: [GENERAL] cascading replication and replication_slots

2015-06-23 Thread Leif Gunnar Erlandsen
>Fra: Michael Paquier >Sendt: 23. juni 2015 13:32 >On Tue, Jun 23, 2015 at 8:18 PM, Leif Gunnar Erlandsen > wrote: >> Is it possible to use a replication_slot for a downstream-server when >> setting up cascading replication on 9.4 >Yes. Just be careful that r

[GENERAL] cascading replication and replication_slots

2015-06-23 Thread Leif Gunnar Erlandsen
Is it possible to use a replication_slot for a downstream-server when setting up cascading replication on 9.4 Leif G. Vennlig hilsen/ Best regards -- LEIF GUNNAR ERLANDSEN Senior Database Consultant BASEFARM | Nydalen Allé 37a | 0484 Oslo | Norway Phone: +47 4000 4100 | Mobile: +47

Re: [GENERAL] Slow query and using wrong index, how to fix? Probably naive question..

2013-05-22 Thread Leif Gunnar Erlandsen
om history where (lookup = 'phone' and lookupid = '672') union select history.id, history.created, creator, contact, history.type, lookup, lookupid, value from history where creator = '790' Leif Gunnar Erlandsen

Re: [GENERAL] Can't Drop Role

2013-03-08 Thread Leif Gunnar Erlandsen
You should alter owner of the functions. Try "alter function function_name owner to new_owner; Leif Gunnar Erlandsen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] alter table set tablespace

2010-07-27 Thread Leif Gunnar Erlandsen
question is the largest one approximately 90GB. Thanks Leif Gunnar Erlandsen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general