Re: trouble with an older version of postgresql

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;"

That should be it. Please, also verify tthat your postgres instance is
started. You can do that like this:

[mgogala(at)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(at)medo ~]$

If the postmaster, wal writer and writer process are present, your
instance is started properly and there is no reason for this to fail.
The template1 database should be present if your installation was
successful. If you don't have the template1 database, your installation
is no good and you should redo it.

On Mon, 2010-02-08 at 10:40 +0100, Krešimir Križanović wrote:
>
>
> 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(dot)gogala(at)vmsinfo(dot)com]
> Sent: Saturday, February 06, 2010 12:08 AM
> To: Krešimir Križanović
> Cc: pgsql-novice(at)postgresql(dot)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
>
>
>
>
>
>
>
>
>
>

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