pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLoad DB - Conversion from 8.1.4 to 8.2.4
5+ messages / 4 participants
[nested] [flat]
* Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-24 18:55 Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Campbell, Lance @ 2007-06-24 18:55 UTC (permalink / raw)
To: pgsql-admin
I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do the
following command in order to load the new database after install?
pg_dump -h host1 -p 1234 dbname | psql -h host1 -p 56789 dbname
Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is PostgreSQL
8.2.4.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-24 20:06 Tommy Gildseth <tommy.gildseth@usit.uio.no>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Tommy Gildseth @ 2007-06-24 20:06 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: pgsql-admin
Campbell, Lance wrote:
>
> I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do
> the following command in order to load the new database after install?
>
> pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ /dbname///
>
> Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is
> PostgreSQL 8.2.4.
>
Should be fine, as long as you ensure that the pg_dump you use, is the
one from your 8.2.4 installation, and not the 8.1.4 version.
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-27 00:14 Peter Koczan <pjkoczan@gmail.com>
parent: Tommy Gildseth <tommy.gildseth@usit.uio.no>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Koczan @ 2007-06-27 00:14 UTC (permalink / raw)
To: Tommy Gildseth <tommy.gildseth@usit.uio.no>; +Cc: Campbell, Lance <lance@uiuc.edu>; pgsql-admin
Tommy Gildseth wrote:
> Campbell, Lance wrote:
>>
>> I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do
>> the following command in order to load the new database after install?
>>
>> pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/
>> /dbname///
>>
>> Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is
>> PostgreSQL 8.2.4.
>>
>
> Should be fine, as long as you ensure that the pg_dump you use, is the
> one from your 8.2.4 installation, and not the 8.1.4 version.
>
>
Two quick addendums:
- pg_dump doesn't dump large objects. You should use the following if
you use large objects.
pg_dump -h /host1/ –p 1234 -Fc /dbname/ | pg_restore -h /host1 –p 56789/
/dbname///
- There might be some other issues with the upgrade. I've run into
permissions issues, data types that were checked more strictly, and a
couple broken primary keys in my days as an admin. I'm not saying you'll
run into these, but if you can, do a dry run of a dump/restore so you
can solve the problems up front.
Peter
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-27 02:27 Campbell, Lance <lance@uiuc.edu>
parent: Peter Koczan <pjkoczan@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Campbell, Lance @ 2007-06-27 02:27 UTC (permalink / raw)
To: Peter Koczan <pjkoczan@gmail.com>; Tommy Gildseth <tommy.gildseth@usit.uio.no>; +Cc: pgsql-admin
I was thinking about upgrading from 8.1.4 to 8.1.9. Then I will do the
upgrade from 8.1.9 to 8.2.4.
Is this a better approach?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
-----Original Message-----
From: Peter Koczan [mailto:pjkoczan@gmail.com]
Sent: Tuesday, June 26, 2007 7:14 PM
To: Tommy Gildseth
Cc: Campbell, Lance; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Load DB - Conversion from 8.1.4 to 8.2.4
Tommy Gildseth wrote:
> Campbell, Lance wrote:
>>
>> I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do
>> the following command in order to load the new database after
install?
>>
>> pg_dump -h /host1/ -p 1234 /dbname/ | psql -h /host1 -p 56789/
>> /dbname///
>>
>> Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is
>> PostgreSQL 8.2.4.
>>
>
> Should be fine, as long as you ensure that the pg_dump you use, is the
> one from your 8.2.4 installation, and not the 8.1.4 version.
>
>
Two quick addendums:
- pg_dump doesn't dump large objects. You should use the following if
you use large objects.
pg_dump -h /host1/ -p 1234 -Fc /dbname/ | pg_restore -h /host1 -p 56789/
/dbname///
- There might be some other issues with the upgrade. I've run into
permissions issues, data types that were checked more strictly, and a
couple broken primary keys in my days as an admin. I'm not saying you'll
run into these, but if you can, do a dry run of a dump/restore so you
can solve the problems up front.
Peter
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Load DB - Conversion from 8.1.4 to 8.2.4
@ 2007-06-27 04:14 Tom Lane <tgl@sss.pgh.pa.us>
parent: Campbell, Lance <lance@uiuc.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2007-06-27 04:14 UTC (permalink / raw)
To: Campbell, Lance <lance@uiuc.edu>; +Cc: Peter Koczan <pjkoczan@gmail.com>; Tommy Gildseth <tommy.gildseth@usit.uio.no>; pgsql-admin
"Campbell, Lance" <lance@uiuc.edu> writes:
> I was thinking about upgrading from 8.1.4 to 8.1.9. Then I will do the
> upgrade from 8.1.9 to 8.2.4.
AFAIK there's no point to that. Just jump to 8.2 in one step. There
are not any bug fixes in 8.1.9 that you'd not get from 8.2.x.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-06-27 04:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-24 18:55 Load DB - Conversion from 8.1.4 to 8.2.4 Campbell, Lance <lance@uiuc.edu>
2007-06-24 20:06 ` Tommy Gildseth <tommy.gildseth@usit.uio.no>
2007-06-27 00:14 ` Peter Koczan <pjkoczan@gmail.com>
2007-06-27 02:27 ` Campbell, Lance <lance@uiuc.edu>
2007-06-27 04:14 ` Tom Lane <tgl@sss.pgh.pa.us>
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