Re: Debian upgrade and PGSQL pid file

OK, I can do some reading and such.
But first I will run pg_dump just in case...

On 4/10/2007, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote:

>On Tue, Apr 10, 2007 at 06:01:34AM -0400, Tom Allison wrote:
>> A while back I threw together a postgresql installation on a computer with
>> a RAID disk for performance reasons. I never got it working 100% since it
>> was just a quick weekend adventure and I never expected much to come of it.
>
>Firstly, there's a README specifically for Debian in the postgres
>packages, I suggest you read it, it has lots of information about the
>way Debian has it setup.
>
>> I'm not trying to upgrade the database via debians recent release and ran
>> into an error from the debian scripts:
>>
>> Preparing to replace postgresql-8.1 8.1.5-1 (using
>> .../postgresql-8.1_8.1.8-1_i386.deb) ...
>> Stopping PostgreSQL 8.1 database server: main* Error: pid file is invalid,
>> please manually kill the stale server process.
>> failed!
>
>Is there still a server running, or not? If not, delete to pid file.
>That should work better.
>
>> ---------------
>> I actually have a pid file in both locations:
>> /raid/postgresql/postmaster.pid,
>> /var/run/postgresql/8.1-main.pid
>
>No, that's normal. One is maintained by the postmaster, the other by
>the init script.
>
>> /raid/postgresql/ has a *lot* of files I was expecting to see somewhere
>> else (like /etc/postgresql)
>
>How did you create that structure? If you did an initdb then it's
>expected, some postgres initdb doesn't know about clusters. If you use
>used pg_createcluster I beleive that should have been taken care of. In
>either case I think they're harmless (if confusing).
>
>> How should it work and how do I get it there?
>
>If you make sure the server is down, you should just be able to delete
>the pid file and upgrade...
>
>Have a nice day,
>--
>Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
>> From each according to his ability. To each according to his ability to litigate.