I already set the 2nd port for the new installation, otherwise, postmaster will not start up ...
johnl > -----Original Message----- > From: Christoph Haller [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 11:05 AM > To: John Liu > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] can't create database > > > > > > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
