Re: Update

> Am 11.04.2013 10:29, schrieb jpui:
> > Hi,
> > I'm running a server using postgres 8.3 and i was adviced to update it...
> > what i have to do in order to update it and don't stop the service?
>
> 8.3 is out of support so you will need to at a very minimum 8.4. This
> cannot be done without restarting. Please check for HowTo for upgrading
> postgres.
>

As Frank has stated 8.3 is no longer supported.If you are upgrading anyway,
you might as well upgrade to a version that still is supported. For
upgrading from a major version (ie 8.3 to 8.4 or higher), you need to dump
the database to a (large) file, upgrade postgres, then restore the database
dump. These actions obviously do require that the database processes be
stopped and started. Depending on your application and your schema, you may
require no changes and everything will work. But it's probably worth
testing this first on another machine to validate. the PG configuration
file postgresql.conf is different from one major version to the next, so
read the docs and tune carefully. Have a look at the release notes for
helpful details. For example:
http://www.postgresql.org/docs/9.2/static/release-9-1.html

If have never used pg_dump or pg_dump_all to generate dumps, nor have
restored them, you should read up on and be proficient at those tasks.
http://www.postgresql.org/docs/9.2/static/backup.html

Kind Regards,
-Joshua