public inbox for
 help / color / mirror / Atom feed
From: Fernando Nasser <>
To: Paul Leung <>
Subject: Re: RHDB 2.1 ISO not working
Date: Sun, 12 Jan 2003 17:40:00 -0000	[thread overview]
Message-ID: <> (raw)
In-Reply-To: <>

Paul Leung wrote:
> I created a database cluster in one account with the admin program.  
> When I went into another account and opened up the admin program, the 
> database cluster wasnt there.  The admin program had no clusters shown 
> initially.  I manually added the cluster that I made with my other 
> account but I wasnt sure if it was the same cluster that I made 
> initially or a brand new cluster that has the same name as the first 
> one.  So what's happening here?

A RHDB/PostgreSQL cluster is defined by a DBMS backend listening on a 
certain port of a certain host.  As long as you defined the new cluster 
with the same host name (or IP address) and port number you are 
connecting to the same database cluster (or "catalog cluster" in the SQL 
standard terms -- I find the PostgreSQL terminology more clear).

Of course you can also choose what database user you want to connect as,
so you can have different "clusters" so you can connect as the DBA or as 
an ordinary user to the same backend.

Anyway, each user of the tool may want these things set differently, 
connect to different clusters etc., so these settings are per Unix user 
and sored in the ~/.rhdb directory.

> I also noticed that there was a trigger tab that I could go to to add 
> triggers.  I saw tabs for views, functions, and etc. but nothing for 
> triggers.  Where do I go to add triggers?

Triggers are database objects associated with tables.  If you open a 
table node (after you create a table, of course), you will see things 
like indexes and triggers in there.


Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9

  reply	other threads:[~2003-01-12 17:40 UTC|newest]

Thread overview: 10+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2003-01-12  5:48 Paul Leung
2003-01-12 17:40 ` Fernando Nasser [this message]
2003-01-13 16:49   ` Patrick Macdonald
  -- strict thread matches above, loose matches on Subject: below --
2003-01-10  6:19 Paul Leung
2003-01-10  5:43 Paul Leung
2003-01-10 15:24 ` Andrew Overholt
2003-01-09 21:55 Fred New
2003-01-09 13:58 George T. Gibson
2003-01-09  4:33 Paul Leung
2003-01-09 18:19 ` Deepak Bhole

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \ \ \ \ \ \ \

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).