problems with moving a database

From: Oliver Kullmann <O(dot)Kullmann(at)Swansea(dot)ac(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: problems with moving a database
Date: 2003-05-13 18:07:58
Message-ID: 20030513180758.GB5534@swan.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Kambhampaty 2003-05-13 18:12:20 Re: No flamefest please, MySQL vs. PostgreSQL AGAIN
Previous Message Shankar K 2003-05-13 17:19:55 Re: database running slow