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

2004-01-28 Thread Martijn van Oosterhout
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 longer

[GENERAL] Interest in database-based email?

2004-01-28 Thread Chris Travers
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?

2004-01-28 Thread Tom Lane
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

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

2004-01-28 Thread Tino Wildenhain
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

Re: [GENERAL] Fw: postgres DB duplication

2004-01-28 Thread Thierry Missimilly
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

Re: [GENERAL] Logging all queries

2004-01-28 Thread MaRCeLO PeReiRA
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] Logging all queries (almost there)

2004-01-28 Thread MaRCeLO PeReiRA
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

[GENERAL] Seaching without accents

2004-01-28 Thread Augusto Cesar Castoldi
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] Seaching without accents

2004-01-28 Thread James M Moe
Augusto Cesar Castoldi wrote: How can I configure postgreSQL to search without acents? Table test Clumns: name , values: Test Test tst Tst Since those are actually different characters that only look the same, you would have to use another approach: select * from test where name like

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

2004-01-28 Thread Chris Travers
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