From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: could not migrate 8.0.13 database with large object data to 9.5.1 |
Date: | 2016-03-02 04:59:27 |
Message-ID: | 56D6732F.1010503@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
(thread moved from pg_bugs)
(upgrading a 8.0.13 database on Windows XP 32bit to 9.5.1 on Windows 8
64 bit.....)
On 3/1/2016 8:05 PM, Premsun Choltanwanich wrote:
> Modified command by remove -Ft flag as per you suggestion:
> pg_dump -v -h 192.168.200.75 -U clubadmin -d clubprogram | psql -U
> clubadmin -d clubprogram
>
> Result (got same message even with parameter -b or not):
> pg_dump: reading rewrite rules
> pg_dump: reading policies
> pg_dump: reading large objects
> ...
> pg_dump: creating FUNCTION "public.plpgsql_call_handler()"
> pg_dump: creating FUNCTION "public.plpgsql_validator(oid)"
> ...
> pg_dump: creating FUNCTION "public.pg_file_write(text, text, boolean)"
those all sound like standard postgres functions, its not clear to me
why pg_dump is generating the CREATE FUNCTION code for them.
> pg_dump: [archiver] could not write to output file: Invalid argument
>
ok, presumably your new box has plenty of disk space? try this on the
new 9.5 system...
"C:\Program Files\PostgreSQL\9.5\bin\pg_dump" -v -h 192.168.200.75
-U clubadmin -d clubprogram -f "D:\Backups\clubprogram-2016-03-01.sql"
(replace D:\Backups\ with wherever you want to put this potentially
rather large backup file)
if that works, then ...
"C:\Program Files\PostgreSQL\9.5\bin\psql" -U clubadmin -d
clubprogram -f "D:\Backups\clubprogram-2016-03-01.sql"
should load the dumped data onto the new system.
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2016-03-02 05:21:52 | Re: Re: could not migrate 8.0.13 database with large object data to 9.5.1 |
Previous Message | Premsun Choltanwanich | 2016-03-02 04:05:12 | Re: could not migrate 8.0.13 database with large object data to 9.5.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2016-03-02 05:21:52 | Re: Re: could not migrate 8.0.13 database with large object data to 9.5.1 |
Previous Message | Premsun Choltanwanich | 2016-03-02 04:10:27 | could not migrate 8.0.13 database with large object data to 9.5.1 |