Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline" - Mailing list pgsql-general

From Ron Mayer
Subject Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"
Date
Msg-id POEDIPIPKGJJLDNIEMBECENNCKAA.ron@intervideo.com
Whole thread Raw
In response to Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom wrote...
> > > [from older msg] If you are running this across a TCP socket,
> > > maybe you could capture the traffic with tcpdump --- if so,
> > > looking at the last few dozen packets in each direction would
> > > be mighty useful ...]
> >
> > Later, (though probably not til the weekend) I'd be happy to try
> > the tcpdump if that's a better tool, though; since it sounds like
> > the new protocol should have recovered more gracefully than it did.
>
> Yes, there's still the question of why it lost sync after the first
> error.  Please investigate when you get a chance.

I've never used tcpdump, so any pointers to what's valuable to
you would be appreciated.

Is
  tcpdump -X -x -s 8192 -i any port 5432 | tail -[a_few_thousand]
the most useful to you?  Or are other flags better?




> [quoted out of order]
> [...]the fix to emit "\r" [...] was applied between 7.2 and 7.2.1[...]
>
> If that's an actual 7.2 installation, I can offer you many excellent
> reasons why you should update it to 7.2.4 forthwith ...

Well, the system it's running has been working flawlessly over a year,
and due to changing job priorities and conservatism about touching
working systems I'm reluctant. :-)  The hard disk space (160G) will
probably fill up in Q4 this year, so I pointed the new guys looking
at 7.3.X or 7.4.X  for the next generation system, hence this discovery.

   Ron


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: check_foreign_key
Next
From:
Date:
Subject: Querying the last value of all sequences