problems with moving a database

Поиск
Список
Период
Сортировка
От Oliver Kullmann
Тема problems with moving a database
Дата
Msg-id 20030513180758.GB5534@swan.ac.uk
обсуждение исходный текст
Ответы Re: problems with moving a database  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список pgsql-admin
Hi,

since quite some time I'm wrestling with the following,
seemingly very basic problem:

I have a database, call it DB1, on my laptop (size of DB ~ 6 GB; OS Suse Linux 8.0).
Now I need to move DB1 to another computer (laptop got too small).
So I "just" create a dump, and create the database on the
pc (call the new database DB2; same version of PostgreSQL, also Suse Linux 8.0).

The first time I tried it was not possible to recreate the
table structure. So well, I use

pg_dump -a

Still problems with the owner structure (user1 on the laptop
is different from user2 on the pc). Since I do not care at
all about these different names, I used

pg_dump -a -R -O -x DB1

Now I get

> psql -dDB2 -U oliver < DB1.dmp
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
FATAL 2:  copy: line 6606854, write of log file 3, segment 143, offset 8716288 failed: No space left on device
lost synchronization with server, resetting connection
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  copy: line 6602698, cannot write block 34375 of b_unit_reductions_b_info_id_key: No space left on device
lost synchronization with server, resetting connection
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
ERROR:  pg_class: Permission denied.
 setval
--------
      2
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      4
(1 row)

 setval
--------
      8
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
    230
(1 row)

 setval
--------
    178
(1 row)

  setval
----------
 11647053
(1 row)

 setval
--------
    150
(1 row)

  setval
----------
 11648603
(1 row)


As you can see, first I get these pg_class errors:
I guess still the systems tries to copy something
of the old structure (in which I'm not interested
--- I just want to get the data copied, *nothing else*).
So well, perhaps these errors can be ignored, but the
other errors seem to be serious, and the database
is not consistent anymore: For example I get NULL
entries for attributes of type SERIAL.

On the pc I still have 12 GB free (the dump-file is
a bit more than 1 GB). What else can I do??

I would be glad for any help!

Thanks in any case.

Oliver


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

Предыдущее
От: Shankar K
Дата:
Сообщение: Re: database running slow
Следующее
От: Murthy Kambhampaty
Дата:
Сообщение: Re: No flamefest please, MySQL vs. PostgreSQL AGAIN