| From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
|---|---|
| To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | 9.6 parameters messing up my 9.2 pg_dump/pg_restore |
| Date: | 2017-06-28 19:08:01 |
| Message-ID: | CAD3a31VG6ZONFxYM8J1UFgiV53dv=Ut3rT3Sc51hHiE-aQ4-5w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi. I've got a CentOS server with 9.2 and 9.6 both running. (Both from
PGDG). I've got a cron job that transfers data from one DB to another,
that recently stopped working, and I traced it to my installing 9.6. The
dump comand is pretty straightforward:
pg_dump -c -O -t "${prefix}*"...
But at the top it sets a bunch of parameters, some of which are
unrecognized by 9.2, which then throws an error and causes my transaction
to fail. Top of the dump file:
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.21
-- Dumped by pg_dump version 9.6.3
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET row_security = off;
And output from running pg_restore:
BEGIN
SET
ERROR: unrecognized configuration parameter "lock_timeout"
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
...
I didn't see any options for dealing with this, though I'm hoping I'm
missing something easy or obvious. Any suggestions or help would be
appreciated. Thanks.
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://agency-software.org/demo/client
<https://agency-software.org/demo/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801
Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-06-28 19:52:52 | Re: 9.6 parameters messing up my 9.2 pg_dump/pg_restore |
| Previous Message | Niel Smith | 2017-06-28 18:32:44 | PostGreSQL Timeout, auto shutdown and Pkey errors |