From: Iain <iain@mst.co.jp>
To: sarlav kumar <sarlavk@yahoo.com>
To: pgsqlnovice <pgsql-novice@postgresql.org>
To: pgsqlperform <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] Postgres version change - pg_dump
Date: Tue, 21 Dec 2004 16:09:55 +0900
Message-ID: <006b01c4e72c$161775b0$7201a8c0@mst1x5r347kymb> (raw)
References: <20041220144034.93247.qmail@web51306.mail.yahoo.com>
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 -----
From: sarlav kumar
To: pgsqlnovice ; pgsqlperform
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: iain@mst.co.jp, sarlavk@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] Postgres version change - pg_dump
In-Reply-To: <006b01c4e72c$161775b0$7201a8c0@mst1x5r347kymb>
References: <20041220144034.93247.qmail@web51306.mail.yahoo.com> <006b01c4e72c$161775b0$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox