Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id TAA11789 for postgres-redist; Thu, 9 Feb 1995 19:10:49 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502100310.TAA11789@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from mailgate.aist-nara.ac.jp (fsb1.aist-nara.ac.jp [163.221.76.12]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id TAA11779 for <postgres@nobozo.cs.berkeley.edu>; Thu, 9 Feb 1995 19:10:47 -0800
Received: from dec324 by mailgate.aist-nara.ac.jp (8.6.9+2.4W/2.8Wb/NAIST-1.5[gate])
	id MAA24775; Fri, 10 Feb 1995 12:10:43 +0900
Received: by dec324.aist-nara.ac.jp (5.65+1.6W/2.7W-AIST/1.3)
	id AA23565; Fri, 10 Feb 95 12:10:38 GMT+0900
Message-Id: <9502100310.AA23565@dec324.aist-nara.ac.jp>
To: robert.patrick@cs.cmu.edu
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: creation problem
Reply-To: yutaka-i@is.aist-nara.ac.jp
In-Reply-To: Your message of "Mon,  6 Feb 1995 16:25:15 -0500 (EST)"
References: <kjBdCvi00hPeIC3XFC@cs.cmu.edu>
X-Mailer: Mew beta version 0.84 on Emacs 18.59.1, Mule 1.1
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Date: Fri, 10 Feb 1995 12:10:37 +0900
From: Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 09 Feb 95 19:10:48 -0800
Resent-XMts: smtp

Thanks your advise.

From: Robert.Patrick@cs.cmu.edu
Subject: Re: creation problem
Date: Mon,  6 Feb 1995 16:25:15 -0500 (EST)

> 2.) Edit the file $POSTGRESHOME/data/files/global1.bki and add yourself
> to the pg_user class (See example below).  After doing this, you will
> need to rerun initdb.
> 
> example:
> There should be a line that looks similar to this in global1.bki:
> 
> insert OID = 0 ( postgres 6543 t t t t )
> 
> postgres is the database superuser's login
> 6543 is the superuser's Unix UID.
> 
> To have yourself added as a superuser of the database, add the following
> line directly below the one shown above:
> 
> insert OID = 1 ( rp2y 3456 t t t t )
> 
> where rp2y is your login name
>     and 3456 is your Unix UID.

so, I successed initdb, so use postgres.
I can use it in "monitor" mode.

but, I tried use postgres directry from unix , 
----------------------------
dec324[281]% monitor -TN -c "append ticket (number="3", status="open",
opener="yutaka-i")" ntemp
WARN:Feb 10 12:01:56:typeid_get_relid: Invalid type - oid = 357 
----------------------------
in monitor mode,
----------------------------
Go 
* append ticket (number="3", status="open",opener="yutaka-i")\g

Query sent to backend is "append ticket (number="3",
status="open",opener="yutaka-i")"
APPEND 20224
----------------------------
successful.

why I cannot use postgres directry from unix?

---
:  Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
:  Graduate School of Information Science
:  Nara Institute of Science and Technology

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/