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:
Show quoted text
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 nameWhat 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