Re: pg_restore has problems with restoring sequences.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thanks,



On 04.02.2018 19:16, Tom Lane wrote:
robert <robert@xxxxxxxxx> writes:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1068; 1259 142848 SEQUENCE
change_email_domain_id_seq odoo
pg_restore: [archiver (db)] could not execute query: ERROR:  syntax error at or
near "AS"
LINE 2:     AS integer
              ^
      Command was: CREATE SEQUENCE change_email_domain_id_seq
      AS integer
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALU...
Hm.  What this suggests is that you're using a pg_dump that is newer than
the server that you're trying to restore to.  The "AS datatype" clause
in CREATE SEQUENCE is new in v10.

The general rule for pg_dump version choice is "use the newest version you
can, but not newer than the server you're going to restore to".  Otherwise
you run into problems like this of the dump containing syntax the target
server doesn't understand.

			regards, tom lane

I am using postgres 10 on the server where I create the dump
and 10.1 where i try to restore.
however,  the box where I try to restore uses
root@lappi:/home/robert/odoo_instances# pg_restore -V
pg_restore (PostgreSQL) 9.5.10

when I check with :
root@lappi:/home/robert/odoo_instances# apt-cache policy postgresql-client
postgresql-client:
  Installed: (none)
  Candidate: 10+189.pgdg17.04+1
  Version table:
     10+189.pgdg17.04+1 500
        500 http://apt.postgresql.org/pub/repos/apt zesty-pgdg/main amd64 Packages         500 http://apt.postgresql.org/pub/repos/apt zesty-pgdg/main i386 Packages
     9.6+184ubuntu1.1 500
        500 http://ch.archive.ubuntu.com/ubuntu artful-updates/main amd64 Packages         500 http://ch.archive.ubuntu.com/ubuntu artful-updates/main i386 Packages         500 http://security.ubuntu.com/ubuntu artful-security/main amd64 Packages         500 http://security.ubuntu.com/ubuntu artful-security/main i386 Packages
     9.6+184ubuntu1 500
        500 http://ch.archive.ubuntu.com/ubuntu artful/main amd64 Packages
        500 http://ch.archive.ubuntu.com/ubuntu artful/main i386 Packages

and when I try to reinstall
apt install postgresql-client-common
i get a message, that it is already the newest version.

ah, now I see something:$which pg_restore points to:
 /usr/bin/pg_restore -> ../share/postgresql-common/pg_wrapper

what is this pg_wrapper??

thanks


--
Robert Rottermann CEO

031 333 10 20
robert@xxxxxxxxxx <mailto:robert@xxxxxxxxxx>
Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse%203,3014%20Bern>

https://Redo2oo.ch <https://redo2oo.ch>

*Ihr Partner wenn es um ERP Lösungen geht.*


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux