BUG #1379: pg_dumpall problem

From: "John Gallai" <gallaij(at)mediagnost(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1379: pg_dumpall problem
Date: 2005-01-10 14:23:47
Message-ID: 200501101423.j0AENl3i032259@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1379
Logged by: John Gallai
Email address: gallaij(at)mediagnost(dot)hu
PostgreSQL version: 7.4.2
Operating system: SuSE Linux 8.2
Description: pg_dumpall problem
Details:

Dear Developer Team!

I think the pg_dumpall and pg_dump have a bug. We have a database named
"mis". We create a full dump with pg_dunpall utility in every two hour. But
when we try to restore the backup it dosn't succeed.

1. I create the templates (under the privileges of postgres user):

initdb -D /usr/local/pgsql/data --locale=hu_HU

when it's ok then

2. start postgreSQL server with this arguments:

postmaster -D /usr/local/pgsql/data -B 3072 -i -S
OK. it starts.

3. psql template1 < dumpfilename.

It starts to restore the data and it always say that invalid command \N or
\. But this file was made by THIS software and it can not understand its own
backup file?
When it finishes the work there's a lot of tables without any content of
data. But before the dump they had!

4. I try the last command again (psql template1 < dumpfilename). It says a
lot times that "this relation already exists" and some times it says that
"cannot create index because the table has multiple rows"....... After
finish ALL seems OK but a lot of table has really multiple rows.......

Please help me because because of a crack we would have a lot of problems.

Thanks,

John

Browse pgsql-bugs by date

  From Date Subject
Next Message Ivan Chumak 2005-01-10 15:31:53 BUG #1380: dont reading messages in russian languages
Previous Message Alexey Borzov 2005-01-10 12:51:26 Re: [BUGS] tsearch2 headline function fails to parse