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

2012-01-04 Thread Dick Visser
On 4 January 2012 19:14, Tom Lane wrote: > Dick Visser 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 o

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

2012-01-04 Thread Tom Lane
Dick Visser 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.

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

2012-01-04 Thread French, Martin
annot restore dumps made with -Fc and --column-inserts Hi guys 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: postgres@filesender:~$ pg_dump -Fc --column-inserts filesender -f filesender_backup.pgdump postgres@files

[ADMIN] Cannot restore dumps made with -Fc and --column-inserts

2012-01-04 Thread Dick Visser
Hi guys 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: postgres@filesender:~$ pg_dump -Fc --column-inserts filesender -f filesender_backup.pgdump postgres@filesender:~$ createdb -T template0 fstest postgres@filesen