dumping on 7.4.6 importing on 7.4.1

[stig erikson]

Hi.
Is it possible to dump a database on a 7.4.6 server and then restore it
on a 7.4.1 server?

should i use the 7.4.1 pg_dump or the 7.4.6 pg_dump?
should i use any switches?

thanks

[Tom Lane]

Re: dumping on 7.4.6 importing on 7.4.1

stig erikson <stigerikson_no spam_@yahoo.se> writes:[color=blue]
> Is it possible to dump a database on a 7.4.6 server and then restore it
> on a 7.4.1 server?[/color]

Should work, but why aren't you updating the 7.4.1 server? There were
some pretty nasty bugs fixed between .1 and .6.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[stig erikson]

Re: dumping on 7.4.6 importing on 7.4.1

Tom Lane wrote:[color=blue][color=green]
>>Is it possible to dump a database on a 7.4.6 server and then restore it
>>on a 7.4.1 server?[/color]
>
>
> Should work, but why aren't you updating the 7.4.1 server? There were
> some pretty nasty bugs fixed between .1 and .6.
>[/color]

problem is i dont have full power over that machine.
i will try to talk to the admin.
it's redhat 8.0 with postgresql installed from rpms, maybe there are new
rpms somewhere?
i could not find any official builds for rh8, does the rh9 rpms work?

[Tom Lane]

Re: dumping on 7.4.6 importing on 7.4.1

stig erikson <stigerikson_no spam_@yahoo.se> writes:[color=blue]
> i could not find any official builds for rh8, does the rh9 rpms work?[/color]

Doubtful. What I'd recommend is getting the source RPM and building your
own binary RPMs --- that's pretty much certain to work. All you need
is
rpmbuild --rebuild --define='build8 1' postgresql-nnn.src.rpm

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly