| Lists: | pgsql-general |
|---|
| From: | Jarkko Elfving <jarelf(at)ebaana(dot)net> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | About PostgreSQL 8.0 |
| Date: | 2005-01-22 22:13:08 |
| Message-ID: | 1106431988.3195.11.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)ebaana(dot)net>
| From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
|---|---|
| To: | Jarkko Elfving <jarelf(at)ebaana(dot)net> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: About PostgreSQL 8.0 |
| Date: | 2005-01-22 23:04:29 |
| Message-ID: | 7c1574a905012215044312c46f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Sun, 23 Jan 2005 00:13:08 +0200, Jarkko Elfving <jarelf(at)ebaana(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org
| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Jarkko Elfving <jarelf(at)ebaana(dot)net> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: About PostgreSQL 8.0 |
| Date: | 2005-01-22 23:48:14 |
| Message-ID: | 20050122234814.GA92600@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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/