From: | Bastian Kleineidam <calvin(at)cs(dot)uni-sb(dot)de> |
---|---|
To: | bugs(at)postgresql(dot)org |
Subject: | installation glitches on Linux |
Date: | 1999-11-23 16:30:46 |
Message-ID: | Pine.LNX.4.21.9911231728520.2755-100000@void.cs.uni-sb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
I want to report experiences installing PostgreSQL 6.5.3 under Debian
Linux 'potato(unstable)' with kernel 2.2.13
(1) INSTALL step 18. (calling initdb)
I have a non-privileged account with user postgres, group postgres
(uid=31, gid=32).
Everything went ok until i called initdb: this script tests
for uid==0 but INSTALL explicitly allows installation from
"non-privileged" accounts. This is a contradiction.
Fix: remove the test for uid==0:
#if [ $POSTGRES_SUPERUID -ne `pg_id` -a `pg_id` -ne 0 ]; then
if [ $POSTGRES_SUPERUID -ne `pg_id` ]; then
Then run initdb -u postgres and off you go.
(2) INSTALL step 20.c. (call psql)
======= begin shell snippet ===========
postgres(at)treasure:/~> psql
Connection to database 'postgres' failed.
FATAL 1: Database postgres does not exist in pg_database
postgres(at)treasure:/~> psql template1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: template1
template1=>
======= end shell snippet ==========
Apparently the createdb command creates 'template1' database per
default and the psql command connects to 'postgres' per default.
Workaround is seen in the shell snippet: call 'psql template1'
Bastian Kleineidam
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-11-23 18:49:18 | Re: [PATCHES] ecpg sqlca.h bug |
Previous Message | Robert Forsman | 1999-11-23 16:28:36 | Unable to match record |