Sorry if this is a question that has been answered in some form or another,
but I need to know if there is a toold of some description that will help me
get a diagram of my 7.2.1 database with the relationships. I've done various
searching on google but found nothing ( but I may be searching with
Le jeu 18/07/2002 à 09:47, Geoff a écrit :
> Sorry if this is a question that has been answered in some form or another,
> but I need to know if there is a toold of some description that will help me
> get a diagram of my 7.2.1 database with the relationships. I've done various
> searching on goog
--- Geoff <[EMAIL PROTECTED]> wrote:
> Sorry if this is a question that has been answered
> in some form or another,
> but I need to know if there is a toold of some
> description that will help me
> get a diagram of my 7.2.1 database with the
> relationships.
-- There is a tool call ERWin (by
Hi,
I'm developing a little project management tool in which you have contacts
related to a customer, and contacts related to the project. Both contacts
contains the same data for now, but for my test, I made the asumption that I
would link the contacts directly with the tables customer and proj
>
> You can try DbVisualizer :
> http://www.minq.se/products/dbvis/
>
Does anybody know whether it is possible to visualize table dependencies
with this tool?
It worked fine with Oracle but with postgresql, DbVisualizer did not
show any reference even though there where many.
I tried org.so
Le jeu 18/07/2002 à 12:02, Stefan Holzheu a écrit :
> >
> > You can try DbVisualizer :
> > http://www.minq.se/products/dbvis/
> >
>
> Does anybody know whether it is possible to visualize table dependencies
> with this tool?
AFAIK, it is.
>
> It worked fine with Oracle but with postgresql, Db
Bom
dia,
Quando
executo o camando abaixo, aparece todas estas mensagens, o que devo fazer para
resolver isto?
[martins@tlmk martins]$ pg_dump -c televendas | gzip > televendas.db.dz
WARNING:
owner of type 'capitais' appears to be invalid
Hi
-*- Nathan Mueller <[EMAIL PROTECTED]> [ 2002-07-18 00:18 ]:
> You won't lose data from disk if you use RAID.
Well... rm, anyone ? :)
RAID protects you from drive failures, sure, but not many other factors such as human
mistake, software errors, compromised box etc.
I personally do a loc
Hi everybody!
I´ve noticed that dumped file through pg_dump by -Fc OR Ft options
turn corrupted after a
binary ftp transfer. I say corrupted because pg_restore says: header
corrupted.
Have anyone seen that so far?
Regards,
Elielson Fontanezi
---(
Hi!
I would like to know if anyone knows some other software like dbvis
which be free.
I am working in a project where all projects must be free.
I have just looked for some and could not find nothing about it!
Maybe anyone of you have just seen something anywhere
Hello,
I am new to Linux and Postgresql. I would like to
start a database and on installation of Red Hat 7.2 installed SQL server which
is Postgres. I do not know where to go from here. I have taken some classes in
using SQL usually at the prompt in class I would type "psql myname" and was
Hi
Is there a possibility to shut down the Auto-Commit-Funktion?
Thanks
CU Roger
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
Hi everybody,
I'm quite a new guy on the Linux World and I have a tremendous problem
with ProstgreSQL, the problem is that after changing the name of the
host (via Network Manager in KDE) and restarting the server, the
PosgreSQL (and other things like XWindow) stopped working.
I tried to restore
Hi.
I have been using PostgreSQL v 7.1.3 without
problems for a year.
I installed the latest version (7.2.1) a week ago and
I have had some problems with a particular query:
///* QUERY *///
SELECT date_part('year', fechaacta) AS "Año de
donación", sexo AS "Sexo", count(*) AS "Cantidad
Hi,
I'm developing a little project management tool in which you have contacts
related to a customer, and contacts related to the project. Both contacts
contains the same data for now, but for my test, I made the asumption that I
would link the contacts directly with the tables customer and proj
> I'm quite a new guy on the Linux World and I have a tremendous problem
> with ProstgreSQL, the problem is that after changing the name of the
> host (via Network Manager in KDE) and restarting the server, the
> PosgreSQL (and other things like XWindow) stopped working.
>
> I tried to restore th
The Postgresql start up script is in /etc/rc.d/init.d/postgresql
if you strace service postgresql start you might see why it won't start.
It won't have anything to do with the hba.conf yet - but it may later (once
the daemon is actually up and running )
Gareth
-Original Message-
From:
Maybe you have to recompile the postgres files with the new hostname!
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: quarta-feira, 17 de julho de 2002 16:55
Para: [EMAIL PROTECTED]
Assunto: [ADMIN] PostgreSQL not starting after changing Hostname
Hi ever
No
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Elielson Fontanezi
Sent: 18 July 2002 13:28
To: '[EMAIL PROTECTED]'
Cc: Pgsql-Admin (E-mail)
Subject: RES: [ADMIN] PostgreSQL not starting after changing Hostname
Maybe you have to recompile the postgre
Hi
There is a free tool that does the schema from a DIA (A gnome drawing tool)
which writes the diagram in XML, the address is http://tedia2sql.tigris.org
This is a perl script that just do that, but is very handy, You are asking for
something that converts from the database to a XML File(an
Hi.
I've been using PostgreSQL 7.1.3 for a year without
problems.
Last week I installed a new server with Red Hat 7.2
and PostgreSQL 7.2.1
I've copied my database by using "pg_dumpall" from my
old server to the new one.
But now the following query doesn't work:
SELECT date_part('year', fecha
Few questions:
What's the largest number of records anyone's got currently?
What are the advantages of Postgres over other RDBMSs?
not for me - just need to know opinions
Gareth
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Juan Pablo
Sent: 18 July
I have misunderstood me.
What I have tried to say is: Is there any free software like ERWIN to
PostGres?
Elielson,
-Mensagem original-
De: Jesus Sandoval [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 18 de julho de 2002 10:12
Cc: Pgsql-Admin (E-mail)
Assunto: Re: RES: [ADMIN] Data
You might try looking into DLT technology. DLT tape drives will give
you 80Gb storage with ~6-12MB/s throughput. They are an industry
standard supported by the heavyweights (HP/IBM/Dell) but a little more
pricey than your current DDS technology.
If you are looking for speed AND storage, I would
I have heard several folks on the list using DBDesigner and dia2sql
succesfully, though I have little experience with either myself. There
is a more comprhensive list at
http://techdocs.postgresql.org/oresources.php look under ERD and
Database Design sections
Robert Treat
On Thu, 2002-07-18 at 0
On Thu, 18 Jul 2002, Kurt Gunderson wrote:
> You might try looking into DLT technology. DLT tape drives will give
> you 80Gb storage with ~6-12MB/s throughput. They are an industry
> standard supported by the heavyweights (HP/IBM/Dell) but a little more
> pricey than your current DDS technology.
On Wed, 17 Jul 2002, Juan Pablo wrote:
> SELECT date_part('year', fechaacta) AS "Año de
> donación", sexo AS "Sexo", count(*) AS "Cantidad de
> donantes"
> FROM "Capital"
> WHERE
> date_part('year', age(timestamp(fechanacimiento)))
> BETWEEN 1 AND 100
> AND "fecha" BETWEEN '2001/01/01' AND '2002/
On Wed, 17 Jul 2002, Robb Fenwick wrote:
> I am new to Linux and Postgresql. I would like to start a database and
> on installation of Red Hat 7.2 installed SQL server which is Postgres.
> I do not know where to go from here. I have taken some classes in
> using SQL usually at the prompt in class
Hi folks!
Has anyone installed Alzabo free data modeling software.
It seens so hard to do so!
Is it good?
Elielson,
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-no
Hi.
I am running postgresql 7.1 on Red Hat Linux, kernel
build 2.4.2-2. I am in the process of updating
postresql to the latest version.
When I dump my database using all the compressions
tricks in:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/backup.html#BACKUP-DUMP-LARGE
my d
Hi all,
I installed Postgresql from RHLinux7.3.
I modified pg_hba.conf as
local alltrust
host all 192.168.0.0 255.255.0.0 trust
I have crated a user 'sreedhar' with password 'sreedhar'
If tried to install dat
> I have heard several folks on the list using DBDesigner and dia2sql
> succesfully, though I have little experience with either myself.
Can anyone tell me what working with DBDesigner is like? Looking at the
screenshots, it looks a little... odd.
BTW:
dbdesigner: http://dbdesigner.sourceforge.
Thanks everyone. I think I'll go with one of the tape solutions (DLT,
Exabyte VXA-2, or AIT) after all. If I can get the 80G native/160 Gig
compressed, then I can probably get buy with one or two tapes. That
should make my single-file restores a little less onerous.
-Tony
[EMAIL PROTECTED] (K
> I have misunderstood me.
> What I have tried to say is: Is there any free software like ERWIN to
> PostGres?
Apparently, dbdesigner is closest to ER/Win. It spews forth SQL DDL
straight from the tool.
Personally, I've been happy laying out tables in Dia. Enough that I wrote
a tool to turn the
At 07:43 PM 7/17/02 , Curt Sampson wrote:
>if you're using tape, you really should be verifying you can read every
>single one you write
Professional quality tape drives do read-after-write with a separate head
during the same pass, so the tape has already been read.
If you're using quarter-in
I recommend that you buy the rather excellent book
"DBA's guide to databases on Linux"
published by Syngress
written by
David Egan and Paul Zikopoulos
ISBN: 1-928994-04-0
It covers PG setup on Linux and loads of other handy things (it also
covers a large number of other DBs, both comme
At 05:06 AM 7/18/02 , Elielson Fontanezi wrote:
>I would like to know if anyone knows some other software like dbvis which
>be free. I am working in a project where all projects must be free. I have
>just looked for some and could not find nothing about it!
Go visit http://www.minq.se/
They ha
--- Roger Mathis <[EMAIL PROTECTED]> wrote:
> Hi
>
> Is there a possibility to shut down the
> Auto-Commit-Funktion?
> Thanks
Use "BEGIN WORK" or "BEGIN TRANSACTION" statement
before typing other SQL statements. This will ensure
that the database will only commit if you type
"COMMIT"
ludwig.
38 matches
Mail list logo
