Re: Cannot restore dumps made with -Fc and --column-inserts

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

 



On 4 January 2012 19:14, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> Dick Visser <visser@xxxxxxxxxx> writes:
>> Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today.
>> When I do a pg_dump using --column-inserts, the subsequent restore fails:
>
> Ugh ... I think I broke this :-(.
>
> As a workaround, you can ask pg_restore for plain text output and
> pipe that to psql.

Pfew, that worked, I actually didn't know about this SQL mode of pg_restore.
At least my backups are not useless :-)


-- 
Dick Visser
System & Networking Engineer
TERENA Secretariat
Singel 468 D, 1017 AW Amsterdam
The Netherlands

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[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