Re: can't create database - Mailing list pgsql-hackers

From Christoph Haller
Subject Re: can't create database
Date
Msg-id 200304031505.RAA09525@rodos
Whole thread Raw
In response to can't create database  ("John Liu" <johnl@emrx.com>)
Responses Re: can't create database
List 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?
> 
You'll probably need to set a second PGPORT to make two versions 
run. See the docs. 
Regards, Christoph 



pgsql-hackers by date:

Previous
From: "John Liu"
Date:
Subject: can't create database
Next
From: "John Liu"
Date:
Subject: Re: can't create database