pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan you help me
4+ messages / 3 participants
[nested] [flat]
* Can you help me
@ 2005-06-05 08:45 Talal Mahyoub Abdo <tmm@norconsult.com.sa>
0 siblings, 1 reply; 4+ messages in thread
From: Talal Mahyoub Abdo @ 2005-06-05 08:45 UTC (permalink / raw)
To: pgsql-admin
Hi,
I have older version for postgresql 7.2,I want upgread the version
how to upgread postegresql 7.2 to postgresql 8.0
Can ypou help me, Please.
regards
Talal
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can you help me
@ 2005-06-06 16:58 Bruno Wolff III <bruno@wolff.to>
parent: Talal Mahyoub Abdo <tmm@norconsult.com.sa>
0 siblings, 1 reply; 4+ messages in thread
From: Bruno Wolff III @ 2005-06-06 16:58 UTC (permalink / raw)
To: Talal Mahyoub Abdo <tmm@norconsult.com.sa>; +Cc: pgsql-admin
On Sun, Jun 05, 2005 at 11:45:37 +0300,
Talal Mahyoub Abdo <tmm@norconsult.com.sa> wrote:
> Hi,
> I have older version for postgresql 7.2,I want upgread the version
> how to upgread postegresql 7.2 to postgresql 8.0
Read the 8.0 release notes.
You are going to want to do a complete dump of your 7.2 databases while
the 7.2 server is running. (If you can, you should use the 8.0 version
of pg_dumpall.) Then once you have got the 8.0 server running, you will
need to reload the databases using psql or pg_restore (depending on which
options you used while running pg_dumpall).
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can you help me
@ 2005-06-06 17:34 Michelle Konzack <linux4michelle@freenet.de>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 4+ messages in thread
From: Michelle Konzack @ 2005-06-06 17:34 UTC (permalink / raw)
To: pgsql-admin; +Cc: Bruno Wolff III <bruno@wolff.to>; Talal Mahyoub Abdo <tmm@norconsult.com.sa>
Am 2005-06-06 11:58:41, schrieb Bruno Wolff III:
> On Sun, Jun 05, 2005 at 11:45:37 +0300,
> Talal Mahyoub Abdo <tmm@norconsult.com.sa> wrote:
> > Hi,
> > I have older version for postgresql 7.2,I want upgread the version
> > how to upgread postegresql 7.2 to postgresql 8.0
>
> Read the 8.0 release notes.
>
> You are going to want to do a complete dump of your 7.2 databases while
> the 7.2 server is running. (If you can, you should use the 8.0 version
> of pg_dumpall.) Then once you have got the 8.0 server running, you will
> need to reload the databases using psql or pg_restore (depending on which
> options you used while running pg_dumpall).
I am using Debian GNU/Linux 3.0 with pgsql 7.4 (backport)
and want to upgrade to SARGE 3.1 and pgsql 8.0
Because I can not upgrade my production system to SARGE,
I need to install SARGE on a new system with pgsql 8.0.
Now, is it possibel to copy only pg_dumpall from SARGE
to the WOODY Server to dump it ?
Please note, that my postgresql AFTER vacumization is
over 120 GByte in size and locates on a Raid-5 Server
with 4 x 147 GByte which mean, I have 420 GByte diskspace.
Greetings
Michelle
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)
Attachments:
signature.pgp (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can you help me
@ 2005-06-06 20:36 Bruno Wolff III <bruno@wolff.to>
parent: Michelle Konzack <linux4michelle@freenet.de>
0 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2005-06-06 20:36 UTC (permalink / raw)
To: Michelle Konzack <linux4michelle@freenet.de>; +Cc: pgsql-admin
On Mon, Jun 06, 2005 at 19:34:24 +0200,
Michelle Konzack <linux4michelle@freenet.de> wrote:
>
> I am using Debian GNU/Linux 3.0 with pgsql 7.4 (backport)
> and want to upgrade to SARGE 3.1 and pgsql 8.0
>
> Because I can not upgrade my production system to SARGE,
> I need to install SARGE on a new system with pgsql 8.0.
>
> Now, is it possibel to copy only pg_dumpall from SARGE
> to the WOODY Server to dump it ?
You can run pg_dumpall on the new server connecting to the old server.
> Please note, that my postgresql AFTER vacumization is
> over 120 GByte in size and locates on a Raid-5 Server
> with 4 x 147 GByte which mean, I have 420 GByte diskspace.
If you can't afford to be down for the time it will take to dump and
reload 120 GB, you can look at using Slony to help with the conversion.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-06-06 20:36 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-05 08:45 Can you help me Talal Mahyoub Abdo <tmm@norconsult.com.sa>
2005-06-06 16:58 ` Bruno Wolff III <bruno@wolff.to>
2005-06-06 17:34 ` Michelle Konzack <linux4michelle@freenet.de>
2005-06-06 20:36 ` Bruno Wolff III <bruno@wolff.to>
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