Skip site navigation (1) Skip section navigation (2)

Re: Post Installation problem

From: Dennis Leeuw <dleeuw(at)made-it(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>, "Aarni =?iso-8859-1?Q?Ruuhim=E4ki?=" <megative(at)iwn(dot)fi>
Subject: Re: Post Installation problem
Date: 2001-09-15 16:28:47
Message-ID: 3BA381BF.D945A80@made-it.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks for the quick reponses. I'll show you some more about the logs I
get, maybe that gives you a better idea of what is going on.

I have run initdb as described in the INSTALL file like:
su - postgres
wuppy:~$ initdb -D /opt/postgresql/data/
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Fixing permissions on existing directory /opt/postgresql/data/
Creating directory /opt/postgresql/data//base
Creating directory /opt/postgresql/data//global
Creating directory /opt/postgresql/data//pg_xlog
Creating template1 database in /opt/postgresql/data//base/1
DEBUG:  database system was shut down at 2001-09-15 18:19:13 CEST
DEBUG:  CheckPoint record at (0, 8)
DEBUG:  Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 16384
DEBUG:  database system is in production state
Creating global relations in /opt/postgresql/data//global
DEBUG:  database system was shut down at 2001-09-15 18:19:37 CEST
DEBUG:  CheckPoint record at (0, 108)
DEBUG:  Redo record at (0, 108); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 514; NextOid: 17199
DEBUG:  database system is in production state
Initializing pg_shadow.
Enabling unlimited row width for system tables.
Creating system views.
Loading pg_description.
Setting lastsysoid.
Vacuuming database.
Copying template1 to template0.

Success. You can now start the database server using:

    /opt/postgresql/bin/postmaster -D /opt/postgresql/data/
or
    /opt/postgresql/bin/pg_ctl -D /opt/postgresql/data/ -l logfile start

So all seems well, I guess. Then I run:
wuppy:~$ /opt/postgresql/bin/postmaster -D /opt/postgresql/data/
DEBUG:  database system was shut down at 2001-09-15 18:20:06 CEST
DEBUG:  CheckPoint record at (0, 1522068)
DEBUG:  Redo record at (0, 1522068); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 615; NextOid: 18720
DEBUG:  database system is in production state

Which is OK too.
After that every command responds with show: command not found, like:
psql template1
./psql: show: command not found

So I still guess I did everything right ??? Didn't I ?

Dennis





Vijay Deval wrote:

> I think after first installation it is necessary to issue command
> initdb.
> Then everything gets going.
>
> Vijay
>
> Dennis Leeuw wrote:
> >
> > postmaster successfully started
> > wuppy:~$ createdb test
> > /opt/postgresql/bin/psql: show: command not found
> > createdb: database creation failed
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

Attachment: dleeuw.vcf
Description: text/x-vcard (235 bytes)

In response to

Responses

pgsql-novice by date

Next:From: Vijay DevalDate: 2001-09-16 04:35:01
Subject: Re: Post Installation problem
Previous:From: Tomasz ZielonkaDate: 2001-09-15 13:59:36
Subject: Re: platform independent set-up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group