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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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