Postgres Pro
Downloads
Home   >   mailing lists

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

From Mladen Gogala
Subject Re: trouble with an older version of postgresql
Date
Msg-id 1265411277.2573.17.camel@nycwxp2622
Whole thread Raw
In response to trouble with an older version of postgresql  (Krešimir Križanović <Kresimir.Krizanovic@fer.hr>)
Responses Re: trouble with an older version of postgresql  (Krešimir Križanović <Kresimir.Krizanovic@fer.hr>)
List pgsql-novice
Tree view
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




VMSMladen 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: Daniel Staal
Date:
Subject: Re: Any way to recover a lost db.. (fwd)
Next
From: peter@vfemail.net
Date:
Subject: Re: Database handle destroyed without explicit disconnect