agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedcreation problem
4+ messages / 2 participants
[nested] [flat]
* creation problem
@ 1995-02-05 01:51 Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-06 21:25 ` Re: creation problem Robert.Patrick@cs.cmu.edu
0 siblings, 1 reply; 4+ messages in thread
From: Drunkard Terry @ 1995-02-05 01:51 UTC (permalink / raw)
To: legacy
Now, I tried to create new database.
"make" finish, so I use command to create the database.
---------------------------------
dec324[150]% createdb temp
FATAL 1:Feb 5 10:34:58:User yutaka-i is not in pg_user
createdb: database creation failed on temp.
---------------------------------
I thought "I'll create my username on postgres."
so I used "createuser" command.
---------------------------------
dec324[152]% createuser yutaka-i
createuser: database access failed.
---------------------------------
why not? postmaster is running, initdb has finished.
There are something else to create database?
Machine is DECstation 5000/25.
Postgres version is v4r0.
Thanks.
---------------- Terry [G'Job !]
==============================================================================
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: creation problem
1995-02-05 01:51 creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
@ 1995-02-06 21:25 ` Robert.Patrick@cs.cmu.edu
1995-02-10 03:10 ` Re: creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
0 siblings, 1 reply; 4+ messages in thread
From: Robert.Patrick@cs.cmu.edu @ 1995-02-06 21:25 UTC (permalink / raw)
To: legacy
Excerpts from internet.postgres: 5-Feb-95 creation problem Drunkard
Terry@is.aist-n (1239*)
> Now, I tried to create new database.
> "make" finish, so I use command to create the database.
> ---------------------------------
> dec324[150]% createdb temp
> FATAL 1:Feb 5 10:34:58:User yutaka-i is not in pg_user
>
> createdb: database creation failed on temp.
> ---------------------------------
> I thought "I'll create my username on postgres."
> so I used "createuser" command.
> ---------------------------------
> dec324[152]% createuser yutaka-i
> createuser: database access failed.
> ---------------------------------
> why not? postmaster is running, initdb has finished.
> There are something else to create database?
> Machine is DECstation 5000/25.
> Postgres version is v4r0.
The problem is that when you compile Postgres, the only user who can do
anything initially is the user specified in Makefile.global in the
"POSTGRESLOGIN" variable.
To use "createuser", you have one of two choices:
1.) Login as the user specified in Makefile.global (usually user
"postgres" unless you changed it). and add yourself as a user with
createuser.
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.
NOTE: This file is ONLY used by "initdb" so you will need to run
"cleardbdir" and then "initdb".
Robert
==============================================================================
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: creation problem
1995-02-05 01:51 creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-06 21:25 ` Re: creation problem Robert.Patrick@cs.cmu.edu
@ 1995-02-10 03:10 ` Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-10 15:36 ` Re: creation problem Robert.Patrick@cs.cmu.edu
0 siblings, 1 reply; 4+ messages in thread
From: Drunkard Terry @ 1995-02-10 03:10 UTC (permalink / raw)
To: robert.patrick@cs.cmu.edu; +Cc: legacy
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: creation problem
1995-02-05 01:51 creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-06 21:25 ` Re: creation problem Robert.Patrick@cs.cmu.edu
1995-02-10 03:10 ` Re: creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
@ 1995-02-10 15:36 ` Robert.Patrick@cs.cmu.edu
0 siblings, 0 replies; 4+ messages in thread
From: Robert.Patrick@cs.cmu.edu @ 1995-02-10 15:36 UTC (permalink / raw)
To: legacy; +Cc: legacy
Excerpts from internet.postgres: 10-Feb-95 Re: creation problem Drunkard
Terry@is.aist-n (2052*)
> 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
Try quoting the quotes.
% monitor -TN -c "append ticket (number = 3, status=\"open\",
opener=\"yutaka-i\")" ntemp
I left out the quotes on the number 3 because quotes aren't needed for
numbers (unless they are stored as strings).
Robert
==============================================================================
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1995-02-10 15:36 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-02-05 01:51 creation problem Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-06 21:25 ` Robert.Patrick@cs.cmu.edu
1995-02-10 03:10 ` Drunkard Terry <yutaka-i@is.aist-nara.ac.jp>
1995-02-10 15:36 ` Robert.Patrick@cs.cmu.edu
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox