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: