problems dumping

From: Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: problems dumping
Date: 2002-10-15 16:32:18
Message-ID: 200210151832.18924.a.schmitz@cityweb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting this
to a file I have >40000 lines of schema and data. Running psql template1 <
<dumpfile> the databases get partially created, i.e the schema is completely
there but data even of the big tables is missing. The dumpfile itself has
only 150k lines left. It used to work before I upgraded to 7.2.3. Any
explainations ?
I also did a " pg_dumpall -C -F p -f test2 -v". I can see the file test2
growing and I can see the schema an the data written in there. It all looks
fine. When the command is finished the shrinks drastically and the data seems
to be gone. Does anybody know the phenomena ?

bash-2.03$ ls -al
total 305588
drwxr-xr-x 2 postgres postgres 512 Oct 15 18:10 .
drwxr-xr-x 3 postgres postgres 512 Oct 15 18:05 ..
-rw-r--r-- 1 postgres postgres 156368896 Oct 15 18:31 test2
bash-2.03$ ls -al
total 318772
drwxr-xr-x 2 postgres postgres 512 Oct 15 18:10 .
drwxr-xr-x 3 postgres postgres 512 Oct 15 18:05 ..
-rw-r--r-- 1 postgres postgres 163119104 Oct 15 18:31 test2
bash-2.03$ ls -al
total 329556
drwxr-xr-x 2 postgres postgres 512 Oct 15 18:10 .
drwxr-xr-x 3 postgres postgres 512 Oct 15 18:05 ..
-rw-r--r-- 1 postgres postgres 168632320 Oct 15 18:31 test2
bash-2.03$ ls -al
total 62
drwxr-xr-x 2 postgres postgres 512 Oct 15 18:10 .
drwxr-xr-x 3 postgres postgres 512 Oct 15 18:05 ..
-rw-r--r-- 1 postgres postgres 28684 Oct 15 18:33 test2
bash-2.03$

kind regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Boes 2002-10-15 16:38:06 Re: Errors while vacuuming large tables
Previous Message Tom Lane 2002-10-15 14:28:09 Re: Trouble dumping "backing up" in 7.1.3