agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
To: robert.patrick@cs.cmu.edu
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: creation problem
Date: Fri, 10 Feb 1995 12:10:37 +0900
Message-ID: <9502100310.AA23565@dec324.aist-nara.ac.jp> (raw)
References: <kjBdCvi00hPeIC3XFC@cs.cmu.edu>
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/
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: yutaka-i@is.aist-nara.ac.jp, robert.patrick@cs.cmu.edu
Subject: Re: creation problem
In-Reply-To: <9502100310.AA23565@dec324.aist-nara.ac.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox