From: | Serge Sozonoff <serges(at)infinet(dot)ch> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Database Restore |
Date: | 2000-01-31 19:38:30 |
Message-ID: | 4.1.20000131203829.00a397b0@mail.infinet.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello all,
I have the following scenario.
1 Linux server (Server A) running Postgres compiled with the standard
BLCKSZE of 8Kb
1 Linux server (Server B) running Postgres compiled with a 32kb BLCKSZE in
the include/config.h file.
A 90 Table database sitting on server A that needs to get to Server B.
I tried doing a pg_dump of the database on Server A and restoring it on
Server B by doing a "psql -e publiflex < db.backup" but
this always fails due to special characters in the dump so basically this
method of backup and
restore does not work for me (unless I am missing something ?)
Second I tried to copy all the binaries in the database dir on Server A to
Server B.
This does not seem to work either and I think it is because of the
BlockSize that is different on each server.
Does any one have any suggestions?
Thanks, Serge
!--------------------------------------!
! Serge Sozonoff !
! http://www.skiphotos.ch !
!--------------------------------------!
From | Date | Subject | |
---|---|---|---|
Next Message | Hernan J. Gonzalez | 2000-01-31 21:45:01 | Re: [ADMIN] request for tuning suggestions from PC Week Labs |
Previous Message | Nicola Cisternino | 2000-01-31 17:57:48 | Relations & Referential Integrity .... |