Re: trouble with an older version of postgresql - Mailing list pgsql-novice

From Krešimir Križanović
Subject Re: trouble with an older version of postgresql
Date
Msg-id E14FE684AF8EC84B854B0CEBA87A831871423F@sluga.fer.hr
Whole thread Raw
In response to Re: trouble with an older version of postgresql  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Responses Re: trouble with an older version of postgresql  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
Re: trouble with an older version of postgresql  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-novice

 

                I cant start psql. It says:

 

psql: FATAL:  Database "kkrizan" does not exist in the system catalog.

 

'kkrizan' is my username.

 

                K.K.

 

From: Mladen Gogala [mailto:mladen.gogala@vmsinfo.com]
Sent: Saturday, February 06, 2010 12:08 AM
To: Krešimir Križanović
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] trouble with an older version of postgresql

 

Create database "postgres" from psql. It's an empty database, anyway.

On Fri, 2010-02-05 at 11:47 +0100, Krešimir Križanović wrote:

               

Hi, i downloaded telegraphCQ, a datastreaming tool based on postgresql 7.3.2.

 

I managed to install it and some library it needs, and now i have to start postmaster and create a database.

 

 
Step 1: $ initdb --no-locale -D /home/kkrizan/tcq/pgdata
All goes well
 
Step 2: $ pg_ctl start -D /home/kkrizan/tcq/pgdata -l /home/kkrizan/tcq/log/pglog
All goes well. I can see postmaster process using ps –x.
 
Step 3: $ createdb kkdb
I get an error.
createdb: could not connect to database postgres: FATAL:  Database "postgres" does not exist in the system catalog.
 
Could you give me a few pointers how to solve this error problem?
 
 
Thanks in advance


Kresimir Krizanovic

 

 

VMS

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com



The Leader in Integrated Media Intelligence Solutions



 

Attachment

pgsql-novice by date:

Previous
From: Ognjen Blagojevic
Date:
Subject: Re: Newbie question about blobs and bytea
Next
From: Jayadevan M
Date:
Subject: Re: trouble with an older version of postgresql