|
As others have already said, use the newer
version of pg_dump and it should go ok.
I had lots of problems restoring 7.1 dumps
into 7.4 database, but it goes smoothly if I use the 7.4 version of
pg_dump.
Assuming you have 2 servers, the old one
and a new one, call pg_dump from your new server as follows:
pg_dump --username=postgres
--host=192.168.x,x <other options>
and use the IP address of the old server
for the --host parameter.
You may need to edit the pg_hba.conf file
on the old server to allow the connection from the new server.
This is pretty convenient as you don't
even have to copy the dump file from the old server.
I was thinking you could set up a
backup server in this way. On a busy system, it may take a load of the main
server so that running backups with users online shouldn't be a problem. That's
in theory anyway.
regards
Iain
----- Original Message -----
Sent: Monday, December 20, 2004
11:40 PM
Subject: [PERFORM] Postgres
version change - pg_dump
Hi All,
Thanks to everyone for helping with my previous questions.
I have a test database running on Postgres 7.3.2.
version
-------------------------------------------------------------
PostgreSQL
7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
I have another server where a newer version of postgres that came with
the Fedora Core 3 package installed.
version
-------------------------------------------------------------------------------------------------------------------------
PostgreSQL
7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC)
3.4.2 20041017 (Red Hat 3.4.2-6)
I would like to do a pg_dump on the test database, and restore it in the
new database on Postgres 7.4.6. I would like to know if there would be any
problem due to the postgres version/OS change. If so, could someone tell me
what precautions I can take to avoid any problems?
Thanks in advance,
Saranya
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
Learn
more.
| 