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
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 |