Database design software

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:

You try Oracle JDeveloper on otn.oracle.com
regards
Haris Peco

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:

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:

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"

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 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

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.

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: