Skip site navigation (1) Skip section navigation (2)

dump & restore problem

From: Kees Leune <C(dot)J(dot)Leune(at)kub(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: dump & restore problem
Date: 1998-08-19 08:11:34
Message-ID: Pine.SOL.4.00.9808191010120.12244-100000@picnix (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
My apologies for sending this question to the list twice. Due to a glitch
in our procmail configuration, I lost all mail that I should have received
overnight, including any answers to this question.

I have a problem with upgrading postgresql 6.1 to 6.3.2. Compilation and 
installation of the database system is no problem, the trouble start when I
try to move the contents of the old database to the new one.

This is the procedure I followed.

0. Platform is:
   SunOS epidemix 5.5 Generic_103093-06 sun4m sparc SUNW,SPARCstation-4
1. compile version 6.3.2
2. run 6.3.2 version of pg_dumpall to dump the contents of the old database.
   The old poster is still running
   This will lead to a number of warnings/errors about the pg_shadow table, i.e. 
that it does not exist. From the documentation , I understand that this is 
correct since 6.1 doesn't have this table.
   When I check the captured output of pg_dumpall, none of my users has been 
saved to the output. Needless to say, I also dumped the database with the old 
version of pg_dumpall. During the dump process, no errors or warnings occur.
3. kill the postmaster. Renamed postgres directory to postgres.old, created new 
postgres directory. Went back to source and did gnu-make install, followed by 
initdb. No problems occured.

4. When I try to reload my old data from the dump that has been made with the 
6.3.2 version of pg_dumpall, no users are created and the restore process stops. 
If I create the users manually and then remove the first few lines from db.out 
that are responsible for deleting the body of pg_shadow, the restore process 
stops with an error that mentions a buffer overflow

When I try to reload my old data from the dump that has been made with the 6.1 
version of pg_dumpall, my users are created, but I get an error that the users 
are not listed in pg_shadow and the restore process stops. 

>From the documentation, I understood that pg_user now is a view of pg_shadow, 
how is it possible then that when I update pg_user, the changes are not made to 

Anyhow, I've been trying for a day and a half to restore my database and nothing 
works. Since it is a more-or-less production database, I restored the 6.1 copy 
so that we could continue our work.

What is wrong? And more importantly, how do I fix it?!

Thanks in advance for your reactions!

Kees Leune, Researcher at the Infolab        | Email: kees(at)kub(dot)nl
Tilburg University, The Netherlands          | Phone: +31 13 466 2688           | HAM: PA3HFB

pgsql-admin by date

Next:From: Przemyslaw BakDate: 1998-08-19 08:50:52
Subject: Backup of postgres
Previous:From: mrparkDate: 1998-08-19 07:14:14
Subject: Re: [ADMIN] Authenticate Error On MOD_AUTH_PGSQL.C

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group