public inbox for [email protected]
help / color / mirror / Atom feedpostgresql 8.0 advantages
15+ messages / 11 participants
[nested] [flat]
* postgresql 8.0 advantages
@ 2005-02-25 14:41 Si Chen <[email protected]>
2005-02-25 14:53 ` Re: postgresql 8.0 advantages Sean Davis <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
0 siblings, 2 replies; 15+ messages in thread
From: Si Chen @ 2005-02-25 14:41 UTC (permalink / raw)
To: postgresql-general mailing list <[email protected]>
Hello.
I read the PostgreSQL 8.0 "What's New" page
(http://www.postgresql.org/docs/whatsnew) and wasn't sure whether
version 8.0 is significantly faster, more scalability, or more stable
than versions 7.4? I remember big speed improvements between 7.3 and
7.4. It seems the biggest advantage of version 8.0 is being able to run
in Windows.
Is that true?
Thanks,
Si Chen
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
@ 2005-02-25 14:53 ` Sean Davis <[email protected]>
1 sibling, 0 replies; 15+ messages in thread
From: Sean Davis @ 2005-02-25 14:53 UTC (permalink / raw)
To: [email protected]; +Cc: postgresql-general mailing list <[email protected]>
On Feb 25, 2005, at 9:41 AM, Si Chen wrote:
> Hello.
>
> I read the PostgreSQL 8.0 "What's New" page
> (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether
> version 8.0 is significantly faster, more scalability, or more stable
> than versions 7.4? I remember big speed improvements between 7.3 and
> 7.4. It seems the biggest advantage of version 8.0 is being able to
> run in Windows.
> Is that true?
I like programming in perl and the new pl/perl adds a totally new
dimension to databasing. For example, the dbi-link
(http://pgfoundry.org/projects/dbi-link/) project allows you to create
a schema within your database that mirrors another data source (any
data sources available via perl DBI). You could have an XML file
served from the web as a set of tables in one schema, a mysql database
as a second schema, and a set of csv files in a directory as a third
schema, all with views within Postgres that allow query, update,
delete, etc. Other projects such as this are likely to spring up, I
would imagine. Performance characteristics aside (which I will leave
to others to comment about), I have found the pl/perl improvements well
worth the switch.
Sean
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
@ 2005-02-25 16:15 ` Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-27 10:58 ` Re: postgresql 8.0 advantages Julian Scarfe <[email protected]>
1 sibling, 2 replies; 15+ messages in thread
From: Tom Lane @ 2005-02-25 16:15 UTC (permalink / raw)
To: [email protected]; +Cc: postgresql-general mailing list <[email protected]>
Si Chen <[email protected]> writes:
> I read the PostgreSQL 8.0 "What's New" page
> (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether
> version 8.0 is significantly faster, more scalability, or more stable
> than versions 7.4? I remember big speed improvements between 7.3 and
> 7.4. It seems the biggest advantage of version 8.0 is being able to run
> in Windows.
There are some speed improvements in 8.0 too, though that wasn't the
main focus of the release cycle. For instance, Lonni Friedman's nearby
thread reports on a case where 8.0 consistently finds a much better
query plan for a complex query than prior releases did, because we fixed
some issues in the GEQO planner module.
regards, tom lane
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
@ 2005-02-25 17:20 ` Si Chen <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Lonni J Friedman <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
1 sibling, 2 replies; 15+ messages in thread
From: Si Chen @ 2005-02-25 17:20 UTC (permalink / raw)
To: [email protected]
Thanks!
Is there any documentation on how to upgrade to 8.0?
Is it possible to upgrade from 7.4 to 8.0 while keeping a production
database running "in place"? Or should I install 8.0 in another
directory/machine and then restore the database into it? Are there any
incompatibilities/modifications to databases from the earlier veresion
required?
(I am running RHEL3.)
Si Chen
Tom Lane wrote:
>Si Chen <[email protected]> writes:
>
>
>>I read the PostgreSQL 8.0 "What's New" page
>>(http://www.postgresql.org/docs/whatsnew) and wasn't sure whether
>>version 8.0 is significantly faster, more scalability, or more stable
>>than versions 7.4? I remember big speed improvements between 7.3 and
>>7.4. It seems the biggest advantage of version 8.0 is being able to run
>>in Windows.
>>
>>
>
>There are some speed improvements in 8.0 too, though that wasn't the
>main focus of the release cycle. For instance, Lonni Friedman's nearby
>thread reports on a case where 8.0 consistently finds a much better
>query plan for a complex query than prior releases did, because we fixed
>some issues in the GEQO planner module.
>
> regards, tom lane
>
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
@ 2005-02-25 17:20 ` Lonni J Friedman <[email protected]>
1 sibling, 0 replies; 15+ messages in thread
From: Lonni J Friedman @ 2005-02-25 17:20 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen <[email protected]> wrote:
> Thanks!
>
> Is there any documentation on how to upgrade to 8.0?
Dump your DB, install 8.0, reload your DB. Since you'e using RHEL3,
you should use the RPMs and it will be fairly easy.
> Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> database running "in place"? Or should I install 8.0 in another
No, its not.
> directory/machine and then restore the database into it? Are there any
> incompatibilities/modifications to databases from the earlier veresion
> required?
Depends on what kind of data structures you have in the DB
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman [email protected]
LlamaLand http://netllama.linux-sxs.org
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
@ 2005-02-26 09:27 ` Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Jeff Davis @ 2005-02-26 09:27 UTC (permalink / raw)
To: [email protected]; +Cc: PgSQL General List <[email protected]>
On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> Thanks!
>
> Is there any documentation on how to upgrade to 8.0?
>
> Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> database running "in place"? Or should I install 8.0 in another
> directory/machine and then restore the database into it? Are there any
> incompatibilities/modifications to databases from the earlier veresion
> required?
>
You might want to check out Slony-I <http://www.slony.info; for the
purpose of upgrading. Slony is actually a replication engine, but it can
be used to upgrade with little or no downtime. Otherwise, just
dump/upgrade/restore like normal.
As far as compatibility, 8.0 should be mostly backwards compatible.
There may be some minor things that I don't know about, so I recommend
some testing first.
Regards,
Jeff Davis
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
@ 2005-02-26 21:35 ` Jim C. Nasby <[email protected]>
2005-02-27 02:12 ` Re: postgresql 8.0 advantages Christopher Browne <[email protected]>
2005-02-27 12:19 ` Re: postgresql 8.0 advantages Christopher Browne <[email protected]>
2005-02-27 20:27 ` Re: postgresql 8.0 advantages Tino Wildenhain <[email protected]>
0 siblings, 3 replies; 15+ messages in thread
From: Jim C. Nasby @ 2005-02-26 21:35 UTC (permalink / raw)
To: Jeff Davis <[email protected]>; +Cc: [email protected]; PgSQL General List <[email protected]>
On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > Thanks!
> >
> > Is there any documentation on how to upgrade to 8.0?
> >
> > Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> > database running "in place"? Or should I install 8.0 in another
> > directory/machine and then restore the database into it? Are there any
> > incompatibilities/modifications to databases from the earlier veresion
> > required?
> >
>
> You might want to check out Slony-I <http://www.slony.info; for the
> purpose of upgrading. Slony is actually a replication engine, but it can
> be used to upgrade with little or no downtime. Otherwise, just
> dump/upgrade/restore like normal.
Has anyone tried moving a database from one location to another on the
HD? I'd like to use slony to minimize downtime, but I'd also like my
data to end up in the same place it is right now when I'm done.
--
Jim C. Nasby, Database Consultant [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
@ 2005-02-27 02:12 ` Christopher Browne <[email protected]>
2 siblings, 0 replies; 15+ messages in thread
From: Christopher Browne @ 2005-02-27 02:12 UTC (permalink / raw)
To: [email protected]
The world rejoiced as [email protected] ("Jim C. Nasby") wrote:
> On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
>> On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
>> > Thanks!
>> >
>> > Is there any documentation on how to upgrade to 8.0?
>> >
>> > Is it possible to upgrade from 7.4 to 8.0 while keeping a production
>> > database running "in place"? Or should I install 8.0 in another
>> > directory/machine and then restore the database into it? Are there any
>> > incompatibilities/modifications to databases from the earlier veresion
>> > required?
>> >
>>
>> You might want to check out Slony-I <http://www.slony.info; for the
>> purpose of upgrading. Slony is actually a replication engine, but it can
>> be used to upgrade with little or no downtime. Otherwise, just
>> dump/upgrade/restore like normal.
>
> Has anyone tried moving a database from one location to another on the
> HD? I'd like to use slony to minimize downtime, but I'd also like my
> data to end up in the same place it is right now when I'm done.
Yes, that certainly ought to work.
If what you're meaning is that you make a replica that sits in
/opt/VERSION8, and then, once the upgrade is complete, rename that to
/opt/MYDATABASE which was where your version 7.4 DB used to be.
We have copied databases from one server to another by copying the
files; making it work was as easy as making sure we ran "pg_ctl -D
$RIGHT_DIRECTORY start" :-).
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/lisp.html
"I don't know why, but first C programs tend to look a lot worse than
first programs in any other language (maybe except for FORTRAN, but
then I suspect all FORTRAN programs look like `firsts')" -- Olaf Kirch
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
@ 2005-02-27 12:19 ` Christopher Browne <[email protected]>
2 siblings, 0 replies; 15+ messages in thread
From: Christopher Browne @ 2005-02-27 12:19 UTC (permalink / raw)
To: [email protected]
Yes, that certainly ought to work.
If what you're meaning is that you make a replica that sits in
/opt/VERSION8, and then, once the upgrade is complete, rename that to
/opt/MYDATABASE which was where your version 7.4 DB used to be.
We have copied databases from one server to another by copying the
files; making it work was as easy as making sure we ran "pg_ctl -D
$RIGHT_DIRECTORY start" :-).
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/lisp.html
"I don't know why, but first C programs tend to look a lot worse than
first programs in any other language (maybe except for FORTRAN, but
then I suspect all FORTRAN programs look like `firsts')" -- Olaf Kirch
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
@ 2005-02-27 20:27 ` Tino Wildenhain <[email protected]>
2005-02-28 19:36 ` Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
2 siblings, 1 reply; 15+ messages in thread
From: Tino Wildenhain @ 2005-02-27 20:27 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Jeff Davis <[email protected]>; [email protected]; PgSQL General List <[email protected]>
Hi,
Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > > Thanks!
> > >
> > > Is there any documentation on how to upgrade to 8.0?
> > >
> > > Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> > > database running "in place"? Or should I install 8.0 in another
> > > directory/machine and then restore the database into it? Are there any
> > > incompatibilities/modifications to databases from the earlier veresion
> > > required?
> > >
> >
> > You might want to check out Slony-I <http://www.slony.info; for the
> > purpose of upgrading. Slony is actually a replication engine, but it can
> > be used to upgrade with little or no downtime. Otherwise, just
> > dump/upgrade/restore like normal.
>
> Has anyone tried moving a database from one location to another on the
> HD? I'd like to use slony to minimize downtime, but I'd also like my
> data to end up in the same place it is right now when I'm done.
I used a straight copy of the filesystem with running database
(over the net in my case) and immediately after that,
stop the db and rsync for the last changes. This took only
10 minutes (compared to 1.5h for the full filesystem copy)
and I could start up the db in new location.
this could work for you too.
Regards
Tino
^ permalink raw reply [nested|flat] 15+ messages in thread
* Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages)
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
2005-02-27 20:27 ` Re: postgresql 8.0 advantages Tino Wildenhain <[email protected]>
@ 2005-02-28 19:36 ` Jim C. Nasby <[email protected]>
2005-02-28 20:27 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Martijn van Oosterhout <[email protected]>
2005-03-17 05:02 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 Bruce Momjian <[email protected]>
0 siblings, 2 replies; 15+ messages in thread
From: Jim C. Nasby @ 2005-02-28 19:36 UTC (permalink / raw)
To: Tino Wildenhain <[email protected]>; +Cc: Jeff Davis <[email protected]>; [email protected]; PgSQL General List <[email protected]>; pgsql-docs
On Sun, Feb 27, 2005 at 09:27:41PM +0100, Tino Wildenhain wrote:
> Hi,
>
> Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby:
> > On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> > > On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> > > > Thanks!
> > > >
> > > > Is there any documentation on how to upgrade to 8.0?
> > > >
> > > > Is it possible to upgrade from 7.4 to 8.0 while keeping a production
> > > > database running "in place"? Or should I install 8.0 in another
> > > > directory/machine and then restore the database into it? Are there any
> > > > incompatibilities/modifications to databases from the earlier veresion
> > > > required?
> > > >
> > >
> > > You might want to check out Slony-I <http://www.slony.info; for the
> > > purpose of upgrading. Slony is actually a replication engine, but it can
> > > be used to upgrade with little or no downtime. Otherwise, just
> > > dump/upgrade/restore like normal.
> >
> > Has anyone tried moving a database from one location to another on the
> > HD? I'd like to use slony to minimize downtime, but I'd also like my
> > data to end up in the same place it is right now when I'm done.
>
> I used a straight copy of the filesystem with running database
> (over the net in my case) and immediately after that,
> stop the db and rsync for the last changes. This took only
> 10 minutes (compared to 1.5h for the full filesystem copy)
> and I could start up the db in new location.
>
> this could work for you too.
I hadn't thought about using rsync; that's a great idea!
Is there somewhere this could be documented? In an FAQ maybe?
--
Jim C. Nasby, Database Consultant [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages)
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
2005-02-27 20:27 ` Re: postgresql 8.0 advantages Tino Wildenhain <[email protected]>
2005-02-28 19:36 ` Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
@ 2005-02-28 20:27 ` Martijn van Oosterhout <[email protected]>
2005-03-01 19:14 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Martijn van Oosterhout @ 2005-02-28 20:27 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Tino Wildenhain <[email protected]>; Jeff Davis <[email protected]>; [email protected]; PgSQL General List <[email protected]>; pgsql-docs
On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote:
> > I used a straight copy of the filesystem with running database
> > (over the net in my case) and immediately after that,
> > stop the db and rsync for the last changes. This took only
> > 10 minutes (compared to 1.5h for the full filesystem copy)
> > and I could start up the db in new location.
> >
> > this could work for you too.
>
> I hadn't thought about using rsync; that's a great idea!
>
> Is there somewhere this could be documented? In an FAQ maybe?
It works only in the special case where the PostgreSQL version number
is the same and you're running on the same platform. How often are you
transferring databases like that. Even transferring from i386 to amd64
wouldn't work like this AFAIUI.
--
Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages)
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
2005-02-27 20:27 ` Re: postgresql 8.0 advantages Tino Wildenhain <[email protected]>
2005-02-28 19:36 ` Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
2005-02-28 20:27 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Martijn van Oosterhout <[email protected]>
@ 2005-03-01 19:14 ` Jim C. Nasby <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Jim C. Nasby @ 2005-03-01 19:14 UTC (permalink / raw)
To: Tino Wildenhain <[email protected]>; Jeff Davis <[email protected]>; [email protected]; PgSQL General List <[email protected]>; pgsql-docs
On Mon, Feb 28, 2005 at 09:27:46PM +0100, Martijn van Oosterhout wrote:
> On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote:
> > > I used a straight copy of the filesystem with running database
> > > (over the net in my case) and immediately after that,
> > > stop the db and rsync for the last changes. This took only
> > > 10 minutes (compared to 1.5h for the full filesystem copy)
> > > and I could start up the db in new location.
> > >
> > > this could work for you too.
> >
> > I hadn't thought about using rsync; that's a great idea!
> >
> > Is there somewhere this could be documented? In an FAQ maybe?
>
> It works only in the special case where the PostgreSQL version number
> is the same and you're running on the same platform. How often are you
> transferring databases like that. Even transferring from i386 to amd64
> wouldn't work like this AFAIUI.
Absolutely true, although in the case of database version PostgreSQL
will check that itself. But in the context this was originally brought
up in (using Sloney to upgrade a machine from 7.4.x to 8.x), it would
work great, and rsync would make a huge difference in downtime.
--
Jim C. Nasby, Database Consultant [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
2005-02-25 17:20 ` Re: postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-26 09:27 ` Re: postgresql 8.0 advantages Jeff Davis <[email protected]>
2005-02-26 21:35 ` Re: postgresql 8.0 advantages Jim C. Nasby <[email protected]>
2005-02-27 20:27 ` Re: postgresql 8.0 advantages Tino Wildenhain <[email protected]>
2005-02-28 19:36 ` Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
@ 2005-03-17 05:02 ` Bruce Momjian <[email protected]>
1 sibling, 0 replies; 15+ messages in thread
From: Bruce Momjian @ 2005-03-17 05:02 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Tino Wildenhain <[email protected]>; Jeff Davis <[email protected]>; [email protected]; PgSQL General List <[email protected]>; pgsql-docs
Jim C. Nasby wrote:
> > > Has anyone tried moving a database from one location to another on the
> > > HD? I'd like to use slony to minimize downtime, but I'd also like my
> > > data to end up in the same place it is right now when I'm done.
> >
> > I used a straight copy of the filesystem with running database
> > (over the net in my case) and immediately after that,
> > stop the db and rsync for the last changes. This took only
> > 10 minutes (compared to 1.5h for the full filesystem copy)
> > and I could start up the db in new location.
> >
> > this could work for you too.
>
> I hadn't thought about using rsync; that's a great idea!
>
> Is there somewhere this could be documented? In an FAQ maybe?
Added to documentation, patch attached.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v
retrieving revision 2.56
diff -c -c -r2.56 backup.sgml
*** doc/src/sgml/backup.sgml 25 Feb 2005 04:56:01 -0000 2.56
--- doc/src/sgml/backup.sgml 17 Mar 2005 05:01:54 -0000
***************
*** 374,379 ****
--- 374,388 ----
</para>
<para>
+ Another option is to use <application>rsync</> to perform a file
+ system backup. First, while the database server is running,
+ run <application>rsync</>, then shut down the database
+ server and perform a second <application>rsync</>, then
+ restart the database server. This allows a file system backup to be
+ performed with minimal downtime.
+ </para>
+
+ <para>
Note that a file system backup will not necessarily be
smaller than an SQL dump. On the contrary, it will most likely be
larger. (<application>pg_dump</application> does not need to dump
Attachments:
[text/plain] /bjm/diff (998B, 2-%2Fbjm%2Fdiff)
download | inline:
Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v
retrieving revision 2.56
diff -c -c -r2.56 backup.sgml
*** doc/src/sgml/backup.sgml 25 Feb 2005 04:56:01 -0000 2.56
--- doc/src/sgml/backup.sgml 17 Mar 2005 05:01:54 -0000
***************
*** 374,379 ****
--- 374,388 ----
</para>
<para>
+ Another option is to use <application>rsync</> to perform a file
+ system backup. First, while the database server is running,
+ run <application>rsync</>, then shut down the database
+ server and perform a second <application>rsync</>, then
+ restart the database server. This allows a file system backup to be
+ performed with minimal downtime.
+ </para>
+
+ <para>
Note that a file system backup will not necessarily be
smaller than an SQL dump. On the contrary, it will most likely be
larger. (<application>pg_dump</application> does not need to dump
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: postgresql 8.0 advantages
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 16:15 ` Re: postgresql 8.0 advantages Tom Lane <[email protected]>
@ 2005-02-27 10:58 ` Julian Scarfe <[email protected]>
1 sibling, 0 replies; 15+ messages in thread
From: Julian Scarfe @ 2005-02-27 10:58 UTC (permalink / raw)
To: postgresql-general mailing list <[email protected]>
From: "Tom Lane" <[email protected]>
> There are some speed improvements in 8.0 too, though that wasn't the
> main focus of the release cycle. For instance, Lonni Friedman's nearby
> thread reports on a case where 8.0 consistently finds a much better
> query plan for a complex query than prior releases did, because we fixed
> some issues in the GEQO planner module.
Could you give an example or two of the sorts of queries for which
performance is improved under 8.0 compared with 7.4, please Tom?
Thanks
Julian Scarfe
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2005-03-17 05:02 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-25 14:41 postgresql 8.0 advantages Si Chen <[email protected]>
2005-02-25 14:53 ` Sean Davis <[email protected]>
2005-02-25 16:15 ` Tom Lane <[email protected]>
2005-02-25 17:20 ` Si Chen <[email protected]>
2005-02-25 17:20 ` Lonni J Friedman <[email protected]>
2005-02-26 09:27 ` Jeff Davis <[email protected]>
2005-02-26 21:35 ` Jim C. Nasby <[email protected]>
2005-02-27 02:12 ` Christopher Browne <[email protected]>
2005-02-27 12:19 ` Christopher Browne <[email protected]>
2005-02-27 20:27 ` Tino Wildenhain <[email protected]>
2005-02-28 19:36 ` Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
2005-02-28 20:27 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Martijn van Oosterhout <[email protected]>
2005-03-01 19:14 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 advantages) Jim C. Nasby <[email protected]>
2005-03-17 05:02 ` Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0 Bruce Momjian <[email protected]>
2005-02-27 10:58 ` Julian Scarfe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox