Thread: trouble with an older version of postgresql

               

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

Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions

On Mon, Feb 08, 2010 at 02:26:50PM +0100, Krešimir Križanović wrote:
>     The trouble is there is no database. When i try to create the first one
>    using createdb, i get an error:
>
>    createdb: could not connect to database postgres: FATAL:  Database
>    "postgres" does not exist in the system catalog.

See if you have a file called global/pg_database in your data directory. It
should be plain text, and contain a list of all the databases that exist. One
of them is probably called "template1", and you should be able to connect to
that. Note that 7.3 is awfully old, and you're unlikly to get much support for
it beyond "Upgrade immediately if not sooner."

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

=?UTF-8?B?S3JlxaFpbWlyIEtyacW+YW5vdmnEhw==?= <Kresimir.Krizanovic@fer.hr> writes:
>  The trouble is there is no database. When i try to create the first one using createdb, i get an error:

> createdb: could not connect to database postgres: FATAL:  Database "postgres" does not exist in the system catalog.

It looks like you are trying to use a newer version of the client-side
tools with an older server.  The "database does not exist" message
hasn't been spelled exactly that way since 7.3, so your server is at
least that old (and thus way, way, way overdue for an update :-().
Recent versions of the client tools assume that a database named
"postgres" exists, but we didn't start creating one of those by
default until 8.1 or so.

What you'll need to do is tell the client program to connect to one
of the databases that does exist.  Try "template1" for starters.
If you feel like it, you can then create a database named "postgres"
so that the client default works --- but it'd be more useful to
spend your time on retiring that ancient server in favor of something
more modern.

            regards, tom lane

1. Do it as the user postgres.
2. If the database postgres doesn't exist, use the following command line: psql -d template1
3. Run "create database postgres;"

[mgogala@medo ~]$ ps -fu postgres
UID        PID  PPID  C STIME TTY          TIME CMD
postgres  4991     1  0 08:43 ?        00:00:00 /usr/bin/postmaster -p 5432 -D /
postgres  4993  4991  0 08:43 ?        00:00:00 postgres: logger process      
postgres  4995  4991  0 08:43 ?        00:00:00 postgres: writer process      
postgres  4996  4991  0 08:43 ?        00:00:00 postgres: wal writer process  
postgres  4997  4991  0 08:43 ?        00:00:00 postgres: autovacuum launcher pr
postgres  4998  4991  0 08:43 ?        00:00:00 postgres: stats collector proces
[mgogala@medo ~]$

 

                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



 

Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions

 

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