Right. A restart is enough.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
09.Eyl.2010 tarihinde 22:44 saatinde, Chris Barnes > şun
Is there a procedure to upgrade from 8.4.x to 8.4.4 or am I over thinking it?
I'm hoping I can just yum upgrade postgresql and have it just upgrade it
without having to dump and restore the whole db.
It would be nice if I had to only bounce postgresql to start using the newer
version :)
Thank
Thank you all for the valuable advices.
I'll try them on a test server and will come back.
Thanks again!
Iv
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi,
If the downtime is a concern, you could use Slony-1 for the migration.
Philippe Ferreira.
[EMAIL PROTECTED] napisał(a):
Could anybody point to an on-line resource about the steps involved with
upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
downtime (i.e. 1 - stop
[EMAIL PROTECTED] napisał(a):
> Could anybody point to an on-line resource about the steps involved with
> upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
> downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 -
> upgrade (ports) 4 - import 5- start db).
>
here you
[EMAIL PROTECTED] wrote:
Could anybody point to an on-line resource about the steps involved with
upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 -
upgrade (ports) 4 - import 5- start db).
You want to make yo
On Feb 23, 2006, at 9:21 AM, [EMAIL PROTECTED] wrote:
Could anybody point to an on-line resource about the steps involved
with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with
minimum downtime (i.e. 1 - stop db so that no changes happen 2 -
dump 3 - upgrade (ports) 4 - import 5
Could anybody point to an on-line resource about the steps involved with
upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 -
upgrade (ports) 4 - import 5- start db).
Thanks,
Iv Ray
---(
Under FreeBSD, you should be using the ports. In this case, you could
simply use the following commands in the postgresql port directory:
make
pkg_delete postgresql-6.5.2
make install
Though the procedure was simple, there was a little gotcha. You need to:
psql template1
select oid,* from pg_data
I got the file <<.patch>> and tried to upgrade postgres
sous FreeBSD with the command patch from the version 6.5.2 to
the version 6.5.3 but it doesn't work. Could somebody
explain to me how to upgrade postgres on my server.
Thank's for your help
__
Matthias
10 matches
Mail list logo
