Re: [ADMIN] Replication, HA ...?

2008-06-16 Thread CZUCZY Gergely
server with postgresql. I would have a backup from this > database. It should also be possible to query this backup solution. > So I think slony would be a good choice. Am I right? > > Thanks for answers > Andreas -- Üdvölettel, Czuczy Gergely Harmless Digital Bt mailt

Re: [ADMIN] postgres, syslog and freeBSD

2008-05-30 Thread CZUCZY Gergely
1) syslog.conf: !postgres *.* /var/log/postgresql.log 2) in your root shell: touch /var/log/postgresql.log 3) don't forget newsyslog.conf 4) don't forget man syslog.conf On Thu, 29 May 2008 22:35:19 -0600 kevin kempter <[EMAIL PROTECTED]> wrote: > Hi list; > > I'm trying to get postgres

Re: [ADMIN] column: on update update?

2008-05-07 Thread CZUCZY Gergely
W.lastupdate = now(); RETURN NEW; END' LANGUAGE plpgsql; CREATE TRIGGER... the same. But both methods are fine. The only thing is, the function must return TRIGGER AFAIK. -- Üdvölettel, Czuczy Gergely Harmless Digital Bt mailto: [EMAIL PROTECTED] Tel: +36-30-9702963 signature.asc Description: PGP signature

Re: [ADMIN] postgresql is slow with larger table even it is in RAM

2008-03-26 Thread CZUCZY Gergely
ry about disk access ) > > If required i will give more information on this. -- Üdvölettel, Czuczy Gergely Harmless Digital Bt mailto: [EMAIL PROTECTED] Tel: +36-30-9702963 signature.asc Description: PGP signature