Public bug reported:
I'm trying to upgrade my PostgreSQL 8.4 cluster on Ubuntu 12.04 LTS to
PostgreSQL 9.1, by running:
pg_dropcluster 9.1 main --stop
pg_upgradecluster 8.4 main
This fails with an SQL syntax error because apparently one of the tables
in one of the databases has a column named "new" that ought to be quoted
appropriately in the generated dump file:
Stopping old cluster...
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Creating new cluster (configuration: /etc/postgresql/9.1/main, data:
/var/lib/postgresql/9.1/main)...
Moving configuration file /var/lib/postgresql/9.1/main/postgresql.conf to
/etc/postgresql/9.1/main...
Moving configuration file /var/lib/postgresql/9.1/main/pg_hba.conf to
/etc/postgresql/9.1/main...
Moving configuration file /var/lib/postgresql/9.1/main/pg_ident.conf to
/etc/postgresql/9.1/main...
Configuring postgresql.conf to use port 5433...
Disabling connections to the new cluster during upgrade...
Roles, databases, schemas, ACLs...
Fixing hardcoded library paths for stored procedures...
Upgrading database pov3...
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: syntax error at or near "new"
LINE 1: ...verse, adjusted_journal_id, adjusted_currency_id, new, relat...
^
pg_dump: The command was: COPY public.account_bank_statement_line (id,
create_uid, create_date, write_date, write_uid, reconcile_id, partner_id, type,
account_id, note, date, ref, statement_id, adjusted_move_line_id, reverse,
adjusted_journal_id, adjusted_currency_id, new, related_statement_line_id,
payment_mode_id, payment_order_id, payment_line_id, state, amount,
operation_id, adjusted_with_move_line_id, advance_invoice_id,
payroll_reconciled, payroll_reconcile_id, payroll_period_id, payment_code,
name) TO stdout;
pg_restore: [custom archiver] unexpected end of file
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Error during cluster dumping, removing new cluster
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: postgresql-common 129ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-101.141-generic 3.2.76
Uname: Linux 3.2.0-101-generic x86_64
ApportVersion: 2.0.1-0ubuntu17.13
Architecture: amd64
Date: Tue Apr 26 09:50:03 2016
MarkForUpload: True
PackageArchitecture: all
ProcEnviron:
LC_CTYPE=lt_LT.UTF-8
TERM=xterm-256color
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: postgresql-common
UpgradeStatus: Upgraded to precise on 2012-07-31 (1364 days ago)
** Affects: postgresql-common (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug precise
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1574978
Title:
pg_upgradecluster fails with an SQL syntax error
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1574978/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
