try something like: su postgres createuser -A -D dbmail su postgres psql -d template1 -c "create database dbmail with owner dbmail;" zcat /usr/share/doc/dbmail2-pgsql/examples/create_tables.pgsql.gz | \ sudo -u dbmail psql -d dbmail
Ozgur Karatas wrote: > I used debian 3.1 sarge version. i installed dbmail from apt stores. > however, tables on PostgreSQL didn't come up. Can you send me the sql > script to form these tables and the virtual domain tables. > > Error messaging: > > test:/etc/dbmail# tail -f /var/log/mail.log > May 31 13:31:20 test dbmail/imap4d[9457]: db.c,db_check_version: database > incompatible. You may need to run the conversion script > > test:~# cat /etc/dbmail/dbmail.conf > [DBMAIL] > # Database settings > host=test.tr.cisco.com > user=dbmail > pass=dbmail > db=dbmail > sqlport=5432 > #sqlsocket= > # trace level for dbmail-maintenance > TRACE_LEVEL=1 > .... > .... > > test:~# psql -U dbmail -h test.tr.cisco.com -W dbmail > Şifre: > psql 7.4.7 PostgreSQL etkileşimli arayüzüne hoşgeldiniz. > > \copyright dağıtım koşulları için > \h SQL komutları hakkında yardım için > \? psql dahili komutların yardımı için > \g veya noktalı virgül sorguyu çalıştırmak için > \q çıkmak için > > dbmail=# \d > Obje bulunamadı. (Not found Object) > dbmail=# > > test:~# netstat -plutn|grep postmaster > tcp 0 0 194.242.32.18:5432 0.0.0.0:* LISTEN 2249/postmaster > test:~# > > > ,''`. Ozgur Karatas > : :' : [EMAIL PROTECTED] > `. `' http://www.ozgurkaratas.com > `- Powered By Debian GNU\Linux > > > > > ---------------------------------------------------------------------- > *** Bu mail Antivirus taramasindan gecmistir (ISTANBUL UNIVERSITESI) > *** This e-mail was scanned by Antivirus. (ISTANBUL UNIVERSITY) > ---------------------------------------------------------------------- > > > ------------------------------------------------------------------------ > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
