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

stig erikson <stigerikson_nospam_ (AT) yahoo (DOT) se> writes:
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

Tom Lane wrote:
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?

stig erikson <stigerikson_nospam_ (AT) yahoo (DOT) se> writes:
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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly