From: | Tore Halset <halset(at)pvv(dot)ntnu(dot)no> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_dump/pg_restore trouble on win32 |
Date: | 2004-10-01 08:12:28 |
Message-ID: | A2A89B02-1381-11D9-BBD0-000A95CD827E@pvv.ntnu.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello.
I am running 8.0.0-beta3 on Mac OS X 10.3.5 and 8.0.0-beta2-dev3
(pginstaller) on windows 2000. I have two databases. The dumpfile
(format c) for database 1 is 150MB and the dumpfile for database 2 is
2GB.
Dumping the databases on the mac worked. I have loaded the dumpfiles in
another database on the mac. Everything is working.
Restoring the small database on the windows box is working, but the 2GB
database will not be restored :/ The rest of this mail is about the 2GB
database. Can it be possible that the command line utilities does not
handle files >= 2GB? This is the output from "ls -l" on the mac:
-rw-r--r-- 1 halset halset 2254827612 29 Sep 23:47 utvikling_cc.dump
Running pg_dump on the windows computer to dump from the database on
the mac over the local network leads to lots of warnings like this:
pg_dump: [custom archiver] WARNING: ftell mismatch with expected
position -- ftell used
pg_dump: [custom archiver] WARNING: ftell mismatch with expected
position -- ftell used
Trying to pg_restore the created dump does not work:
D:\Program\PostgreSQL\8.0-beta2-dev3\bin>pg_restore -U toretest -d
utvikling_cc
d:\temp\tore\d2
Password:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC Entry 1837; 0 0 COMMENT
SCHEMA public
postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of sc
hema public
Command was:
COMMENT ON SCHEMA public IS 'Standard public schema';
pg_restore: [custom archiver] error during file seek: Invalid argument
I have also tried to copy the dumpfile from the mac to the windows box
using samba. The dumpfile worked on the mac, but failed to load on the
windows box:
D:\Program\PostgreSQL\8.0-beta2-dev3\bin>pg_restore -U toretest -d
utvikling_cc
d:\temp\tore\utvikling_cc.dump
Password:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC Entry 1838; 0 0 COMMENT
SCHEMA public
postgres
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of sc
hema public
Command was:
COMMENT ON SCHEMA public IS 'Standard public schema';
pg_restore: [custom archiver] error during file seek: Invalid argument
Regards,
- Tore.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-10-01 08:37:21 | Re: logging |
Previous Message | Theo Galanakis | 2004-10-01 06:54:03 | logging |