Thread: Database design software
Can anybody recommend any software for creating UML diagrams and generating the SQL necessary to create the database? Dia? __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2
Yes, I know of a good one. The pricing is a bit different. The price is on the hourly used basis. The cost is $100/ hour. But its an excellent system. It also makes coffee, attends meetings and stuff. Its called John Doe the DBA. Oh...it also has a builtin speech recognition and synthesizer feature... CSN wrote: >Can anybody recommend any software for creating UML >diagrams and generating the SQL necessary to create >the database? Dia? > >__________________________________________________ >Do you Yahoo!? >U2 on LAUNCH - Exclusive greatest hits videos >http://launch.yahoo.com/u2 > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > >
You try Oracle JDeveloper on otn.oracle.com regards Haris Peco On Thursday 07 November 2002 09:05 pm, CSN wrote: > Can anybody recommend any software for creating UML > diagrams and generating the SQL necessary to create > the database? Dia? > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
CSN wrote: > Can anybody recommend any software for creating UML > diagrams and generating the SQL necessary to create > the database? Dia? > I use Dia 0.90 and tedia2sql Perl script (http://tedia2sql.tigris.org) to translate diagrams in sql scripts. It does a lot of things and if you can Perl, lucky you! A nice project is uml2sql from http://sourceforge.net/projects/uml2sql but unfortunately it's stopped. Regards, lwd.
What is the command to launch a trace i try postmaster -i -D .... -d 10 >logfile but the file is create but nothing are in why? thanks
On 8 Nov 2002 at 9:42, Florian Litot wrote: > What is the command to launch a trace > i try postmaster -i -D .... -d 10 >logfile > but the file is create but nothing are in why? Try postmaster -i -D .... -d 10 >logfile 2>&1 HTH Bye Shridhar -- MIT: The Georgia Tech of the North
yes it's good but can i have the date with each line? At 10:14 08/11/02, Shridhar Daithankar wrote: >On 8 Nov 2002 at 9:42, Florian Litot wrote: > > > What is the command to launch a trace > > i try postmaster -i -D .... -d 10 >logfile > > but the file is create but nothing are in why? > >Try postmaster -i -D .... -d 10 >logfile 2>&1 > >HTH > > >Bye > Shridhar > >-- >MIT: The Georgia Tech of the North > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
On 8 Nov 2002 at 11:03, Florian Litot wrote: > yes it's good but can i have the date with each line? Err.. I don't think so. Sounds like a good addition to me. Any ideas? Bye Shridhar -- Absentee, n.: A person with an income who has had the forethought to remove himself from the sphere of exaction. -- Ambrose Bierce, "The Devil's Dictionary"
Use syslog... It's documented on the website and in the manual... Assuming you are running on Linux then adding/editing: syslog = 1 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' to $PGDATA/postgresql.conf and: local0.* /var/log/postgresql to /etc/syslog.conf and then doing: /etc/init.d/syslog restart /etc/init.d/postgresql restart should give you the log you're looking for at: /var/log/postgresql I'll leave it to you to translate this to your flavour of UNIX (or Linux)... Lee. Florian Litot writes: > yes it's good but can i have the date with each line? > At 10:14 08/11/02, Shridhar Daithankar wrote: > >On 8 Nov 2002 at 9:42, Florian Litot wrote: > > > What is the command to launch a trace > > > i try postmaster -i -D .... -d 10 >logfile > > > but the file is create but nothing are in why? > >Try postmaster -i -D .... -d 10 >logfile 2>&1
nobody know if it is possible to have the date in th e same time eache line ? At 11:14 08/11/02, Shridhar Daithankar wrote: >On 8 Nov 2002 at 11:03, Florian Litot wrote: > > > yes it's good but can i have the date with each line? > >Err.. I don't think so. Sounds like a good addition to me. > >Any ideas? > >Bye > Shridhar > >-- >Absentee, n.: A person with an income who has had the forethought to >remove >himself from the sphere of exaction. -- Ambrose Bierce, "The >Devil's >Dictionary" > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster
On Friday 08 November 2002 04:42 pm, you wrote: > nobody know if it is possible to have the date in th e same time eache line I guess there was a reply to syslog. I am sure it's documented in postgresql manual. Missed that last time.. Shridhar
Florian Litot <flitot@besancon.sema.slb.com> writes: > yes it's good but can i have the date with each line? If you turn it on in postgresql.conf. See the manual: http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html#LOGGING regards, tom lane
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes: > On 8 Nov 2002 at 11:03, Florian Litot wrote: > > yes it's good but can i have the date with each line? > > Err.. I don't think so. Try the log_timestamp GUC option. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
I have noted similar problems when attempting to manipulate stdin, stdout, stderr of postmaster. So I use pg_ctl -l log See pg_ctl(1) to see how they do it there..... Florian Litot wrote: > What is the command to launch a trace > i try postmaster -i -D .... -d 10 >logfile > but the file is create but nothing are in why? > thanks > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org