Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
Bang on Tom. As you can see from the snippet of my mail below, I had it pg_port. Oh well, make distclean again I suppose Thanks. Tom Lane wrote: "skennedy" <[EMAIL PROTECTED]> writes: If I configured the server to user 5433 before building (using --with-pg_port=5

Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
piled using 5433, (according to "which" anyway) :) Everything seems to work now anyway but it would be interesting/useful to know what I did wrong.  Is there a trace/log of some sort which might hold the answer? Stephen Kennedy. Tom Lane wrote: "skennedy" &

[ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
Hi.. I have a Solaris 2.8 machine on which I have Postgresql 7.2.4 postgres listening on port 5432. This works fine. I have a user who needs a newer version and has asked specifically for 7.3. I have compiled and installed a 7.3.4 successfully, using ./configure --prefix=/usr/local/p_sql734 -

Re: [ADMIN] Report Generator Proposal

2003-09-15 Thread skennedy
Oracle have something similar: RDA which generates  HTML reports for the hardware, SO, and database. It doesn't do explains but does show which SQLs are the most expensive, etc. It could be worth having a look at that for ideas on what and how to report it. Stephen. Somasekhar Bangalore wrot