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

Re: Moving a database-sos

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: "'PGSQL Novice List'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Moving a database-sos
Date: 2002-12-25 12:07:45
Message-ID: 000001c2ac0e$3f9cde80$da86d380@main (view raw or flat)
Thread:
Lists: pgsql-novice
Never mind... It was a version problem, but there is a workaround.

Sincerely,
r. 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Reshat Sabiq
Sent: Wednesday, December 25, 2002 4:06 AM
To: 'PGSQL Novice List'
Subject: Re: [NOVICE] Moving a database-sos

Actually, 1.7 is the dump version which means that the destination
server does not understand the dump version on the source (which is
understood for restoring on the source as I checked). Apparently, that
is because source is 7.3.1, whereas destination is 7.2.3.
I am still planning to try smt. else, maybe a different way around the
destination's restoration will get the idea.

Sincerely,
r. 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Reshat Sabiq
Sent: Wednesday, December 25, 2002 3:58 AM
To: 'PGSQL Novice List'
Subject: Re: [NOVICE] Moving a database-sos

After putting it into an archive with pg_dump, I got:
pg_restore: [archiver] unsupported version (1.7) in file header
on destination machine. It's not clear what 1.7 is though, cause all
pg... version involved are 7.x.y, whereas tar versions are both 1.13.25.

P.S. Going to try 2 more things on my mind.

Sincerely,
r. 




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



In response to

pgsql-novice by date

Next:From: Heiko SchroederDate: 2002-12-27 02:27:21
Subject: Heavy security bug in 7.2.2-16?
Previous:From: Reshat SabiqDate: 2002-12-25 09:06:03
Subject: Re: Moving a database-sos

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