can't create database

From: "John Liu" <johnl(at)emrx(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: can't create database
Date: 2003-04-03 14:50:50
Message-ID: NDBBKKKHILOHGHNKGOCEIEAEFAAA.johnl@emrx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

on one of the AIX4.3.3,
the 7.1.3 pgsql is installed by root on the system,
then I tried to install
7.3.1/or 7.3.2 under another non-root user,
I can run make, make check, make install,
postmaster can start without errors, but when
I try to createdb, here're some errors -

createdb emrxdbs
ERROR: 'autocommit' is not a valid option name
createdb: database creation failed

then I issued,
postgre7.3.2>psql template1
ERROR: parser: parse error at or near "."
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=> select version();
version
------------------------------------------------------------
PostgreSQL 7.1.3 on powerpc-ibm-aix4.3.3.0, compiled by cc
(1 row)

template1=>

it picks the older version and always having a parser error!!

Any hints?

thanks.

johnl

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Liu 2003-04-03 15:03:29 Re: can't create database
Previous Message Tom Lane 2003-04-03 14:29:39 Re: contrib and licensing