Mary Y Wang wrote:
I got this error:
-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL
version 7.3, which is not compatible with this version 8.3.8.
I
Albe Laurenz wrote:
If you care about the data in the 7.3 data directory, you will
have to migrate it: start a 7.3 server, export with 8.3's
pg_dumpall, run 8.3's initdb, import the dump.
and thats not that easy with Redhat/Centos/Fedora/etc RPM installs, as
installing 8.x from RPM sources
Albe Laurenz wrote:
To find out what PostgreSQL stuff you have installed (provided
you installed it as RPM and did not compile it from source),
you can run
rpm -qa | grep postgres
Some other useful tricks to know here; most commands take --version:
$ initdb --version
initdb (PostgreSQL)
Hi,
I got this error:
-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is
not compatible with this version 8.3.8.
I think I must have two
In response to Wang, Mary Y :
Hi,
I got this error:
-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 7.3, which
is not compatible with this
-general-ow...@postgresql.org] On Behalf Of A. Kretschmer
Sent: Thursday, February 25, 2010 11:04 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Two Versions of PostgreSQL Installed - How to uninstall
one particular version
In response to Wang, Mary Y :
Hi,
I got this error:
-bash-2.05b
In response to Wang, Mary Y :
Thanks Andreas for the info. I'm working on a development server right now,
and currently I don't have any data loaded yet. As matter of fact, I was
trying to load the database data from a dump file that generated by
pg_dump.
Here is the thing:
I've a