Обсуждение: Error executing dbcreate

with PostgreSQL 7.3.2.

I'm running linux (mandrake 9.0).

I successfully executed the followed instructions:

     ./configure
     make
     su
     make install
     adduser postgres
     mkdir /usr/local/pgsql/data
     chown postgres /usr/local/pgsql/data
     su - postgres
     /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
     /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data logfile
   2>&1 &

And failed executing this:
     /usr/local/pgsql/bin/createdb test
with this error:
     ERROR:  'autocommit' is not a valid option name

What is the problem?

I bet you already have one flavor of postgresql (7.2.x) installed.

Do an rpm -qa|grep -i post to see if you do.

On Thu, 8 May 2003, Jeff Holle wrote:

> with PostgreSQL 7.3.2.
>
> I'm running linux (mandrake 9.0).
>
> I successfully executed the followed instructions:
>
>      ./configure
>      make
>      su
>      make install
>      adduser postgres
>      mkdir /usr/local/pgsql/data
>      chown postgres /usr/local/pgsql/data
>      su - postgres
>      /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
>      /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data logfile
>    2>&1 &
>
> And failed executing this:
>      /usr/local/pgsql/bin/createdb test
> with this error:
>      ERROR:  'autocommit' is not a valid option name
>
> What is the problem?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Jeff Holle <jeff.holle@verizon.net> writes:
> And failed executing this:
>      /usr/local/pgsql/bin/createdb test
> with this error:
>      ERROR:  'autocommit' is not a valid option name

Looks to me like you have a 7.3 createdb script trying to talk to
a pre-7.3 database server.  Better check your setup.

            regards, tom lane