pg_dump/pg_restore trouble on win32

Поиск
Список
Период
Сортировка
От Tore Halset
Тема pg_dump/pg_restore trouble on win32
Дата
Msg-id A2A89B02-1381-11D9-BBD0-000A95CD827E@pvv.ntnu.no
обсуждение исходный текст
Ответы Re: pg_dump/pg_restore trouble on win32  (Tore Halset <halset@pvv.ntnu.no>)
Список 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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Theo Galanakis
Дата:
Сообщение: logging
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: logging