Re: [GENERAL] Interest in database-based email?

Hi Tino; I hadn't been aware of dbmail, and I will have to further check this out. I started with tpop3d because I found it to be extensible (I can also write a driver to authenticate against the HERMES database itself, if I so desire), compact, and the code easy to read. It would, however, be n

Re: [GENERAL] Seaching without accents

Augusto Cesar Castoldi wrote: How can I configure postgreSQL to search without acents? Table “test” Clumns: name , values: Test Test tést Tést Since those are actually different characters that only look the same, you would have to use another approach: select * from test where name like '

[GENERAL] Seaching without accents

How can I configure postgreSQL to search without acents?   Like:   Table “test” Clumns: name , values: Test Test tést Tést     SELECT * FROM test WHERE name LIKE “tes%”   And it should return values “tést, test”   Thanks,   Augusto

Re: [GENERAL] Logging all queries (almost there)

Hi All, I have set [log_statement=true] in the postgresql.conf file and now I have all the statements logged. But, there is a problem: Once I have more than one database, I had to know in which database a statement was executed on. The log file is full of: "select * from stuff", but as I have mo

Re: [GENERAL] Logging all queries

Hi Franco, If I set 'log_statement=true', will *all* the queries sent to the backend be logged??? In which table will it be used to do this log?? Regards, Marcelo --- Franco Bruno Borghesi <[EMAIL PROTECTED]> escreveu: > you can set the log_statement parameter to true in > the configuration >

Re: [GENERAL] Fw: postgres DB duplication

Cheer, If you want to make a cold backup, be carreful if you have distributed your database on different disks with symbolic links or by using the initloaction command as a tar or cpio won't save the symbolic tree . Otherwise you can save all your $PGDATA directory and copy it on your new machin

Re: [GENERAL] Interest in database-based email?

Hi Chris, Chris Travers wrote: Hi all; Just as an anouncement, I am working on developing a PostgreSQL-based mailbox driver for tpop3d (a GPL'd POP3 server). My general plan is to use this as a connector to the email components for my CRM software (HERMES). Eventually I will be adding IMAP and S

Re: [GENERAL] Help, I've killed my system?

Dean Grubb <[EMAIL PROTECTED]> writes: > I have a debian server running postgresql 7.03 from the packages > and also postgresql 7.1.3 from source. After doing an upgrade to some > system files (ahrr...apt-get is good but I like freeBSD ports) I > find that I no longer have the postgresql 7.03 >

[GENERAL] Interest in database-based email?

Hi all; Just as an anouncement, I am working on developing a PostgreSQL-based mailbox driver for tpop3d (a GPL'd POP3 server). My general plan is to use this as a connector to the email components for my CRM software (HERMES). Eventually I will be adding IMAP and SMTP support as well. Do people

Re: [GENERAL] Help, I've killed my system?

On Wed, Jan 28, 2004 at 05:01:32PM +1100, Dean Grubb wrote: > Hi, > > I have a debian server running postgresql 7.03 from the packages > and also postgresql 7.1.3 from source. After doing an upgrade to some > system files (ahrr...apt-get is good but I like freeBSD ports) I > find that I no lon

[GENERAL] Help, I've killed my system?

Hi, I have a debian server running postgresql 7.03 from the packages and also postgresql 7.1.3 from source. After doing an upgrade to some system files (ahrr...apt-get is good but I like freeBSD ports) I find that I no longer have the postgresql 7.03 installation but a miss matched 7.2 part in