Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id EFF829FB964 for ; Fri, 20 Apr 2007 09:16:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 31938-07 for ; Fri, 20 Apr 2007 09:16:18 -0300 (ADT) X-Greylist: delayed 00:23:45.443831 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 70F649FB391 for ; Fri, 20 Apr 2007 09:16:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr4.postgresql.org (Postfix) with ESMTP id 0F7785AF044 for ; Fri, 20 Apr 2007 11:52:36 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 433C21874D for ; Fri, 20 Apr 2007 13:52:18 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 08077-05-2 for ; Fri, 20 Apr 2007 13:52:12 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id EFF5B1874C for ; Fri, 20 Apr 2007 13:52:11 +0200 (CEST) Subject: createdb: database postgres does not exists From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: PostgreSQL Admin Content-Type: text/plain Organization: Mob-Art d.o.o. Date: Fri, 20 Apr 2007 13:52:11 +0200 Message-Id: <1177069931.10413.12.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/190 X-Sequence-Number: 25254 I have postgres 8.1 on WindowsXP, installed via postgres installer. I have the user postgres on the cluster. When I try to create database from command line: createdb -U postgres test_db_1 I get error that 'postgres database does not exists'. When I try to create db from EMS manager, everything works fine. I noticed that on my linux boxes initdb creates databases postgres, template0 and template1. Is this a bug in windows installer, or am I doing something wrong? Mike