About PostgreSQL 8.0
Hi.
I've started to learn SQL about 6 months ago, and now I'd upgraded
PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
README file (how stupid I was) and there were instructions to how to do
it; the upgrade I mean. Now I'm wondering, server is not running because
fileformat or something like that is wrong - I did the upgrade wrongly.
I do not have any relevant data in the Postgre database, so I don't need
to backup it (which was one point of the upgrading). How I must have to
proceed that I can start the Postgre server? Do I use the initdb command
and if I do, how I do it with default locations? I'm very new on
PostgreSQL and do not have much experience on SQL. I'm running on FC3.
I hope that you understand what my problem is. I will explain more, if
you don't.
Plz, help me.
--
Jarkko Elfving <jarelf@ebaana.net>
On Sun, 23 Jan 2005 00:13:08 +0200, Jarkko Elfving <jarelf@ebaana.net> wrote:
Hi.
I've started to learn SQL about 6 months ago, and now I'd upgraded
PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
README file (how stupid I was) and there were instructions to how to do
it; the upgrade I mean. Now I'm wondering, server is not running because
fileformat or something like that is wrong - I did the upgrade wrongly.
I do not have any relevant data in the Postgre database, so I don't need
to backup it (which was one point of the upgrading). How I must have to
proceed that I can start the Postgre server? Do I use the initdb command
and if I do, how I do it with default locations? I'm very new on
PostgreSQL and do not have much experience on SQL. I'm running on FC3.I hope that you understand what my problem is. I will explain more, if
you don't.
If you don't care about losing your data, you can fix this by shutting
down postgresql, deleting the contents of /var/lib/pgsql/data and then
starting postgresql again.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
On Sun, Jan 23, 2005 at 12:13:08AM +0200, Jarkko Elfving wrote:
I've started to learn SQL about 6 months ago, and now I'd upgraded
PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
README file (how stupid I was) and there were instructions to how to do
it; the upgrade I mean. Now I'm wondering, server is not running because
fileformat or something like that is wrong - I did the upgrade wrongly.
I'd guess that you didn't do an initdb and tried to run an 8.0
server with a 7.4 cluster. See the "Installation Instructions"
chapter of the documentation, in particular the "If You Are Upgrading"
section; see also "Migration Between Releases" in the "Backup and
Restore" chapter and the documentation for initdb:
http://www.postgresql.org/docs/8.0/static/installation.html
http://www.postgresql.org/docs/8.0/static/migration.html
http://www.postgresql.org/docs/8.0/static/app-initdb.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/