- Do it as the user postgres.
- If the database postgres doesn't exist, use the following command line: psql -d template1
- Run "create database postgres;"
That should be it. Please, also verify tthat your postgres instance is started. You can do that like this:
[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 ~]$
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.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
|
