Michael Adler wrote:
On many occasions, I've noticed that some PostgreSQL activity takes far longer than it previously did and that disabling syslogd addresses the symptoms.
Most recently, it took 20-60 seconds to VACUUM a small, heavily updated table, while it used to take a fraction of a secon
On Tue, Jan 13, 2004 at 11:36:19PM -0500, Tom Lane wrote:
> Michael Adler <[EMAIL PROTECTED]> writes:
> > On many occasions, I've noticed that some PostgreSQL activity takes
> > far longer than it previously did and that disabling syslogd addresses
> > the symptoms.
> > ...
> > This evidence normal
James Neville <[EMAIL PROTECTED]> writes:
> Only recently, we have noticed the abscence of any schemas.
It's not possible that the database contains *no* schemas. You are
being way too imprecise in describing the problem.
> The product issues queries like:
> SELECT * FROM dbname.public.users;
>
Peter Eisentraut wrote:
You don't need to create any tables, just schemas.
Thanks for the help Peter, i've since resolved the problem.
The production install was in fact, 7.2.3, not 7.3.2 as I stated
earlier, my bad.
It appears that PG only started supporting schemas since 7.3.x.
I was assummin
Juan Miguel wrote:
Greetings!
pg_autodoc
http://www.rbt.ca/autodoc/index.html
can produce .dot files that can be charted using
graphviz.
http://www.graphviz.org/
It works pretty well for medium sized databases
but for large it tends to produce a spaghetti.
Check the "Related Sites" in graphviz
James Neville wrote:
> Peter Eisentraut wrote:
> >Well, perhaps you have simply dropped them? You can just recreate
> > them.
>
> Well, thats a relief, but what tables do I need to recreate, and what
> are their schemas?
You don't need to create any tables, just schemas.
> I'm also rather curiou
Peter Eisentraut wrote:
Well, perhaps you have simply dropped them? You can just recreate them.
Well, thats a relief, but what tables do I need to recreate, and what
are their schemas?
I'm also rather curious as to how/why someone would have dropped a
system table.
Thanks,
James.
James Neville wrote:
> Does anyone have a clue as to how this may have happened, and an
> approach to remedying the problem with a reinstall?
Well, perhaps you have simply dropped them? You can just recreate them.
---(end of broadcast)---
TIP 3: i
Hi,
We've got a rather odd problem with our PG 7.3.2 production installation.
Everything is working fine on the surface, and has been for quite some
time.
Only recently, we have noticed the abscence of any schemas.
We're at a complete loss as to how this happened, or even when.
The databases we
Guten Tag Juan Miguel,
Hi Juan,
JM> Hi, I use MS Visio Professional, and it works (not very good), but it works.
JM> I ever wondered if there is a opensource tool, that let me create an
JM> automatic ER-Model diagram from an existing DB, like MS Visio.
JM> Do you know if this tool exists ?
Unfor
Hi,
For a small schema, i've used PGACESS. There is a graphical editor which help
you to draw boxes with the foreign keys.
Thierry
Juan Miguel wrote:
> Hi, I use MS Visio Professional, and it works (not very good), but it works.
> I ever wondered if there is a opensource tool, that let me creat
I'd be interested in anything you hear. Have a similar, but not identical problem.
You could also set up Oracle with it's heterogeneous services capability. There are
ODBC drivers available for most platforms.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
F
Hi Gurus,
Is anyone using Oracle Reports on Postgresql? I am trying to build
reports using Oracle9i report builder on a postgresql database but I
can't figure out how to connect to the database from the Report builder.
Please help if you can. Thanks
---(end of broadcast)---
Hi, I use MS Visio Professional, and it works (not very good), but it works.
I ever wondered if there is a opensource tool, that let me create an
automatic ER-Model diagram from an existing DB, like MS Visio.
Do you know if this tool exists ?
Thanks
Hi Tony,
TR> It occured to me that perhaps pr
Hi Tony,
TR> It occured to me that perhaps programs existed which simply parsed the
TR> table definitions and plotted the graphs for you.
If I need to create an [E]ER-Modell from an existing databasae,
I mostly use MS Visio professional. It can reverse engineer via
ODBC lots of DBS.
Rico
---
15 matches
Mail list logo
