Re: BUG #5739: postgresql will not start - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5739: postgresql will not start
Date
Msg-id 4CCEEE9B020000250003709C@gw.wicourts.gov
Whole thread Raw
In response to BUG #5739: postgresql will not start  ("Kim Garren" <dedanna@bjoernvold.com>)
List pgsql-bugs
"Kim Garren" <dedanna@bjoernvold.com> wrote:

> Received update to postgresql 9.0.1-2 yesterday

How?  From where?  What were you running before?

> Once booted, I try to start it manually, with the following
> result:
>
> # /etc/rc.d/postgresql start
> :: Starting PostgreSQL
> [BUSY] server starting
>
> [DONE]

What is showing for `ps aux | grep postgres` ?  What is in the logs?

> https://bbs.archlinux.org/viewtopic.php?id=107656

> https://bugs.archlinux.org/task/21560

Both of these make it sound like you were upgrading from PostgreSQL
8.4.  This requires a database conversion.  What technique did you
use for that?  (The more specific you can be about the exact steps,
the more likely it is that someone will be able to help you.)

> I have lost my music db because of this.

Not unless you deleted your data directory.  If you don't back it up
regularly, it would certainly be wise to do so before a major
release upgrade.  Making a recursive copy of the database data
directory would be a very good idea right now.

-Kevin

pgsql-bugs by date:

Previous
From: "Kim Garren"
Date:
Subject: BUG #5739: postgresql will not start
Next
From: Tom Lane
Date:
Subject: Re: index on function confuses drop table cascade on child