Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Postgres version change - pg_dump

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "sarlav kumar" <sarlavk(at)yahoo(dot)com>,"pgsqlnovice" <pgsql-novice(at)postgresql(dot)org>,"pgsqlperform" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] Postgres version change - pg_dump
Date: 2004-12-21 07:09:55
Message-ID: 006b01c4e72c$161775b0$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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. 

In response to

pgsql-novice by date

Next:From: Bruce BadgerDate: 2004-12-21 07:35:22
Subject: Re: Drop does not always drop
Previous:From: Christopher Kings-LynneDate: 2004-12-21 05:58:14
Subject: Re: [PERFORM] Postgres version change - pg_dump

pgsql-performance by date

Next:From: Amrit AngsusinghDate: 2004-12-21 09:31:49
Subject: Howto Increased performace ?
Previous:From: Christopher Kings-LynneDate: 2004-12-21 05:58:14
Subject: Re: [PERFORM] Postgres version change - pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group