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

Re: trouble with an older version of postgresql

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Krešimir Križanović <Kresimir(dot)Krizanovic(at)fer(dot)hr>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: trouble with an older version of postgresql
Date: 2010-02-05 23:07:57
Message-ID: 1265411277.2573.17.camel@nycwxp2622 (view raw or flat)
Thread:
Lists: pgsql-novice
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




In response to

Responses

pgsql-novice by date

Next:From: peterDate: 2010-02-06 14:11:36
Subject: Re: Database handle destroyed without explicit disconnect
Previous:From: Daniel StaalDate: 2010-02-05 20:01:25
Subject: Re: Any way to recover a lost db..

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