GOOD NEWS
On Jan 23, 2012, at 20:00, David Johnston <polobo@yahoo.com> wrote:
> On Jan 23, 2012, at 19:38, Adrian Klaver <adrian.klaver@gmail.com> wrote:
>
>> On Monday, January 23, 2012 4:24:50 pm David Johnston wrote:
>>> Immediately upon starting the server I get an "incomplete startup packet"
>>> log message. Just prior there is an "autovacuum launcher started"
>>> message.
>>
>> Do you have other programs connecting to server on startup?
>>
>>>
>>> Any thoughts?
>>>
>>> David J.
>>
>> --
>> Adrian Klaver
>> adrian.klaver@gmail.com
>>
>
> I have 3 external machines that hit this server plus Apache Tomcat on the same machine. I shutdown Tomcat during the
restart. Possible a zombie (or hidden/forgotten) process is running though the log indicates local. Had been using
pg_admin3for testing and somehow ended up with a possible zombie process there so maybe...
>
> Version 9.0.x - can get the release a little later, running pg_dump at the moment.
>
> Still researching/learning but was using WAL shipping and the ship command was failing. In the target directory the
mostrecent WAL files is only ~2MB in size (can't check the pg_xlog directory at the moment). My guess is size quota on
targetbut cannot check at the moment. Turned off WAL archive and restarted the server. Restarted a couple of times
untilI remembered to shutdown all the other applications.
>
> Pg_dump seems to be running OK and was able to execute queries. Was still having difficulty getting my Tomcat
softwareto connect but am unsure if I'm just missing something or what. No obvious messages in either log about that
butcannot get back to it until the dump completes.
>
> Appreciate any help that can be given. Unfortunately I haven't focused enough attention on Linux (Ubuntu 10.4 LTE)
andPostgreSQL administration as I'd like (education and/or professional services). Apparently that is going to change
soonerthan I had thought.
>
> David J.
>
Looking at my process viewer I saw a Java process running (with Catalina...) even though I supposedly shutdown Tomcat.
SinceTomcat wasn't working anyway I decided to just kill the process then restart PostgreSQL...no more spurious error
message. Restarted Tomcat and I can now hit my Servlet.
Just need to get the base backup and WAL shipping enabled again. Assuming since I disabled it, and just ran a pg_dump
whileeverything was disconnected, that I can basically throw out the shipped WAL files?
Still kinda at a loss for root cause and deciding whether there still may be an underlying problem. Thoughts are
welcomebut I'm likely to seek professional help on this one regardless.
Thanks for listening.
David J.