problems with moving a database - Mailing list pgsql-admin
| From | Oliver Kullmann |
|---|---|
| Subject | problems with moving a database |
| Date | |
| Msg-id | 20030513180758.GB5534@swan.ac.uk Whole thread Raw |
| Responses |
Re: problems with moving a database
|
| List | 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 by date: