Re: [GENERAL] Logging at schema level

Schema = tenant. So basically tenant level logging. On 21-Jul-2017 11:21 AM, "Andreas Kretschmer" <andr...@a-kretschmer.de> wrote: > On 21 July 2017 07:10:42 GMT+02:00, Nikhil <nikhilsme...@gmail.com> wrote: > >Hello, > > > >I am using postgresql s

[GENERAL] Logging at schema level

Hello, I am using postgresql schema feature for multi-tenancy. can we get postgresql logs at schema level. Currently it is for the whole database server (pg_log) Best Regards, Nikhil

[GENERAL] BDR - Ignore already exists error during DDL replay

. Best Regards, Nikhil GMT%ERROR: trigger "truncate_trigger" for relation "provisionsettings_server_boundary" already e xists <283032016-07-12 15:51:58 GMT%CONTEXT: during DDL replay of ddl statement: CREATE TRIGGER truncate_trigger AFTER TRUNCATE ON public.provisions

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

I think its caused by hard reboots (may b hyper visor itself is rebooted!) . Is there any setting which can reduce such problems ? On Tue, Jun 7, 2016 at 5:30 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 7 June 2016 at 18:24, Nikhil <nikhilsme...@gmail.com> wrote: > >

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

pg_replslot/bdr_16389_6293051490331141125_2_16389__/state" has wrong magic 4522536 instead of 17112225 <35352016-06-07 10:16:59 GMT%LOG: startup process (PID 3538) was terminated by signal 6: Abort trap <35352016-06-07 10:16:59 GMT%LOG: aborting startup due to startup process failure Best Regards, Nikhil

Re: [GENERAL] BDR to ignore table exists error

Thanks a lot Martin for your replies. On Sun, May 29, 2016 at 11:50 PM, Martín Marqués <mar...@2ndquadrant.com> wrote: > Hi, > > El 29/05/16 a las 06:01, Nikhil escribió: > > > > *​Nik>> skip_ddl_locking is set to True in my configuration. As t

Re: [GENERAL] BDR to ignore table exists error

Please see my replies inline. On Sat, May 28, 2016 at 8:08 PM, Martín Marqués <mar...@2ndquadrant.com> wrote: > El 28/05/16 a las 08:57, Nikhil escribió: > > Once the node which was down is brought back the replication slot is not > > turned active. The reason being repli

Re: [GENERAL] BDR to ignore table exists error

-2016 4:56 PM, "Martín Marqués" <mar...@2ndquadrant.com> wrote: > El 27/05/16 a las 06:33, Nikhil escribió: > > Hello, > > > > > > I have a BDR setup with two nodes. If I bring one node down i am seeing > that > > the replication slot is becoming

[GENERAL] BDR to ignore table exists error

8462016-05-25 23:58:20 GMT%ERROR: relation "af_npx_device_l3_16_149_10" already exists Thanks & Regards, Nikhil

Re: [GENERAL] BDR replication slots

n each node's log after enablibg interfaces? > > Regards, > > Alvaro Aguayo > Jefe de Operaciones > Open Comb Systems E.I.R.L. > > Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: > (+51) 954183248 > Website: www.ocs.pe > > Sent from my Sony Xperia™ sm

[GENERAL] BDR replication slots

stops. Any idea why automatically its not re-established ? Best Regards, Nikhil

Re: [GENERAL] Custom conflict handlers

Can someone help with bdr conflict handlers? What is ch_proc ..? On 13-Feb-2016 8:11 pm, "Nikhil" <nikhilsme...@gmail.com> wrote: > This is for system that use BDR (Bi-Directional Replication). BDR > documentation > http://bdr-project.org/docs/next/functions-conflict-ha

[GENERAL] Custom conflict handlers

Hello, Is there any documentation with details of how to custom conflict handlers? Wanted to write update-update conflict handler. Any help is highly appreciated. Best Regards, Nikhil

Re: [GENERAL] Custom conflict handlers

This is for system that use BDR (Bi-Directional Replication). BDR documentation http://bdr-project.org/docs/next/functions-conflict-handlers.html talks about postgresql functions. I am looking for samples. Best Regards, Nikhil On Sat, Feb 13, 2016 at 5:31 PM, Nikhil <nikhilsme...@gmail.

[GENERAL] BDR replication

that i replicate. I am ok if some logs are lost in replication. journal entries must not be lost in replication. Best Regards, Nikhil

[GENERAL] BDR with postgres 9.5

Hello All, What is the timeline for BDR with postgres 9.5 released version. Best Regards, Nikhil

[GENERAL] Postgres BDR bdr_init_copy fails

hello , I am trying to setup 2 -node bdr group. i have 5 databases in node 1. i created groups for each db in node-1. then did pg_basebackup from node -2 and started bdr_init_copy. Its giving below error. *bdr_init_copy* bdr_init_copy: starting ... Getting remote server identification ...

[GENERAL] BDR and synchronous replication

this setup? Best Regards, Nikhil

[GENERAL] To increase RAM or not

Folks, I have set about 12GB RAM (shared buffers) for our Postgresql instance. How do I know if this is actually being used? And is there a way to know by how much should I increase it, if it is not enough? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

I could face if I move to an unofficial one. Thanks! Nikhil On 07-06-2013 04:18, Scott Marlowe wrote: On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake j...@commandprompt.com wrote: Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because

[GENERAL] How to know the exact time to which the database was recovered

the exact time till when the database was recovered. How do I get this timestamp? Thanks. Nikhil -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to check if Postgresql files are OK

Folks, I was using PostgreSQL 8.x in development environment when one day I started getting all kinds of low-level errors while running queries and eventually had to reinstall. Maybe it was salvageable but since it was a test database anyway it didn't matter. We use PostgreSQL 9 on our

[GENERAL] Error while vacuuming table

Hello, When I run vacuum, I get: vacuumdb: vacuuming of database pm50 failed: ERROR: catalog is missing 1 attribute(s) for relid 4210163 How do I go about debugging this? I have googled around and tried a few things to no avail. Any pointers will be appreciated. Thanks. Nikhil -- Sent

Re: [GENERAL] PostgreSQL Performance issue

Most likely you are inserting one per transaction. Set autocommit to false and commit only after all the inserts are done. -n. On 27-04-2010 13:41, a.bhattacha...@sungard.com wrote: Dear All Experts, I am using in PostgreSQL 8.3.5 database on windows 64 bit OS. However, I have a batch

[GENERAL] Postgresql on EC2/EBS in production?

Folks, I was wondering if any of you are using (or tried to use) PG+EC2/EBS on a production system. Are any best-practices. Googling didn't help much. A few articles I came across scared me a bit. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] 1-Click installer problems

On 07-04-2010 10:04, Craig Ringer wrote: Nikhil G. Daddikar wrote: I have tried earlier versions of 8.4 installer on Vista x32 and they'd failed too. But let me try the latest installer again. I will let you know. Any luck with the call? Or are we still at it doesn't work on your

Re: [GENERAL] 1-Click installer problems

as well as in the default directory 7. Enabled the Administrator user in Vista, logged in as that user and installed If you want me to try anything else, I can do that too. Thanks, Nikhil On 06-04-2010 09:31, Craig Ringer wrote: Nikhil, Any movement on collecting some system

Re: [GENERAL] 1-Click installer problems

I have tried earlier versions of 8.4 installer on Vista x32 and they'd failed too. But let me try the latest installer again. I will let you know. -n. On 06-04-2010 10:09, Craig Ringer wrote: Nikhil G. Daddikar wrote: Hi Craig, I have a call with EDB folks in an hour. I will post

Re: [GENERAL] 1-Click installer problems

In about 30 seconds I found the following unanswered threads relating to installation on Windows Vista. If anybody is interested I can find more. And I can tell you that a lot of our customers are facing the same problem with this 1-click gimmicky installer.. something that they never faced

Re: [GENERAL] 1-Click installer problems

On 01-04-2010 12:39, Thomas Kellerer wrote: Nikhil G. Daddikar, 01.04.2010 08:04: In about 30 seconds I found the following unanswered threads relating to installation on Windows Vista. If anybody is interested I can find more. The problem with this kind of statistics is that you

Re: [GENERAL] 1-Click installer problems

Maybe I'm missing something, but I see 5 responses from 2 of our engineers over the last 2 days on that thread, all asking valid questions and trying to figure out why this is failing for you, when it does not for the vast majority of other users. I appreciate that you do not want to do a

Re: [GENERAL] 1-Click installer problems

Folks, I received a call from EnterpriseDB trying to understand what the problem is. We are scheduled to meet on Monday. I will post the findings as soon as I have something concrete. Thank you all. -n. Unless you are prepared to help us understand exactly what is unique about your systems

Re: [GENERAL] 1-Click installer problems

Peter, Are you sure about that? Have you actually tested that? Even if you find that the old 8.3 pginstaller works where the EDB installer failed, that doesn't actually demonstrate that pginstaller is inherently superior to the EDB installer. It is likely due to a fluke. Perhaps it is down to

[GENERAL] 1-Click installer problems

. Regards, Nikhil -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] 1-Click installer problems

would like from EDB is a list of instructions on how to install it on Vista or Windows 7. I've asked this in the forum but I have not received any response. Is this too much to ask? -Nikhil PS: It is the users that make or break the software not its developers. So please think twice before

[GENERAL] Segementation fault in PQgetvalue()

This is what I'm trying to: char lmt_str[100]; sprintf(lmt_str,%s,PQgetvalue(res, 0, nFields-1)); //the last field is of type timestamp This is giving segmentation fault. I'm confused -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Reliability Stability of PgSQL it's JDBC driver

Nathan, Thanks for your response. It is great to know that Postgres is working out fine. However, I don't understand what "Vaccum of the DB" means nor what the "WAL" functionality is. If you could briefly explain these, that would be great. Thanks again! -ngd. The main problem that you have