Re: [GENERAL] logger table

2012-12-25 Thread Philipp Kraus
Am 25.12.2012 17:19, schrieb Jason Dusek: 2012/12/24 Philipp Kraus : I need some ideas for creating a PG based logger. I have got a job, which can run more than one time. So the PK is at the moment jobid & cycle number. The inserts in this table are in parallel with the same username from diffe

Re: [GENERAL] logger table

2012-12-25 Thread Jason Dusek
2012/12/24 Philipp Kraus : > I need some ideas for creating a PG based logger. I have got a > job, which can run more than one time. So the PK is at the > moment jobid & cycle number. The inserts in this table are in > parallel with the same username from different host > (clustering). The user ca

Re: [GENERAL] logger table

2012-12-23 Thread John R Pierce
On 12/23/2012 7:01 PM, Philipp Kraus wrote: I don't know how can I create a good PK value. IMHO a sequence can be create problems that I'm logged in with the same user on multiple hosts, why is that a reason ? sequences work no matter how many clients there are. PK is at the moment jobid

Re: [GENERAL] logger table

2012-12-23 Thread Alejandro Carrillo
Did you use pg_audit? https://github.com/jcasanov/pg_audit > > De: Philipp Kraus >Para: pgsql-general@postgresql.org >Enviado: Domingo 23 de diciembre de 2012 22:01 >Asunto: [GENERAL] logger table > >Hello, > >I need some ideas for creating a PG based logger.