Thread

Commits

  1. Doc: fix mention of psql's minimum supported server version.

  2. Doc: fix mention of pg_dump's minimum supported server version.

  3. Remove pg_dump/pg_dumpall support for dumping from pre-8.0 servers.

  1. Can we still dump version 7?

    Daniel Westermann (DWE) <daniel.westermann@dbi-services.com> — 2022-05-31T14:26:09Z

    Hi,
    
    this commit (64f3524e2c8deebc02808aa5ebdfa17859473add) removed dump support for dumping from  pre-8.0. 
    
    I guess this statement is not true anymore?
    "Current releases of the dump programs can read data from any server version back to 7.0."
    https://www.postgresql.org/docs/current/upgrading.html 
    
    Regards
    Daniel
    
    
    
  2. Re: Can we still dump version 7?

    Tom Lane <tgl@sss.pgh.pa.us> — 2022-05-31T14:55:44Z

    "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
    > I guess this statement is not true anymore?
    > "Current releases of the dump programs can read data from any server version back to 7.0."
    > https://www.postgresql.org/docs/current/upgrading.html 
    
    Ugh, missed that, thanks for spotting it.
    
    I wonder whether we should update this or just remove it --- it's
    clearly something that's likely to get missed again.
    
    			regards, tom lane
    
    
    
    
  3. Re: Can we still dump version 7?

    Jonathan S. Katz <jkatz@postgresql.org> — 2022-05-31T14:57:51Z

    On 5/31/22 10:55 AM, Tom Lane wrote:
    > "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
    >> I guess this statement is not true anymore?
    >> "Current releases of the dump programs can read data from any server version back to 7.0."
    >> https://www.postgresql.org/docs/current/upgrading.html
    > 
    > Ugh, missed that, thanks for spotting it.
    > 
    > I wonder whether we should update this or just remove it --- it's
    > clearly something that's likely to get missed again.
    
    While burdensome, +1 for updating. We don't want users to get caught by 
    surprise if pg_dumpall does not work on an old version when trying to 
    update to a newer version.
    
    Jonathan
    
  4. Re: Can we still dump version 7?

    Tom Lane <tgl@sss.pgh.pa.us> — 2022-05-31T16:21:09Z

    "Jonathan S. Katz" <jkatz@postgresql.org> writes:
    > On 5/31/22 10:55 AM, Tom Lane wrote:
    >> I wonder whether we should update this or just remove it --- it's
    >> clearly something that's likely to get missed again.
    
    > While burdensome, +1 for updating. We don't want users to get caught by 
    > surprise if pg_dumpall does not work on an old version when trying to 
    > update to a newer version.
    
    Further investigation shows that we've failed to update this twice in
    the past six years, and failed to update a similar comment about psql
    once.  I fixed 'em, but I have very little hope that they'll stay fixed.
    
    			regards, tom lane
    
    
    
    
  5. Re: Can we still dump version 7?

    Jonathan S. Katz <jkatz@postgresql.org> — 2022-05-31T18:47:23Z

    On 5/31/22 12:21 PM, Tom Lane wrote:
    > "Jonathan S. Katz" <jkatz@postgresql.org> writes:
    >> On 5/31/22 10:55 AM, Tom Lane wrote:
    >>> I wonder whether we should update this or just remove it --- it's
    >>> clearly something that's likely to get missed again.
    > 
    >> While burdensome, +1 for updating. We don't want users to get caught by
    >> surprise if pg_dumpall does not work on an old version when trying to
    >> update to a newer version.
    > 
    > Further investigation shows that we've failed to update this twice in
    > the past six years, and failed to update a similar comment about psql
    > once.  I fixed 'em, but I have very little hope that they'll stay fixed.
    
    Could we add as part of the branching procedure that we update this value?
    
    Jonathan