From: | Richard Terry <rterry(at)internode(dot)on(dot)net> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Conversion from 8.4 to >9 version question |
Date: | 2013-04-16 22:21:06 |
Message-ID: | 516DCED2.6070309@internode.on.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hope this has not been just recently covered if so apologies.
I'm after a simple way to upgrade from 8.4 to the latest version of
postgres (my server is a ubuntu 10 LTS I think)
When I back up my work database I just use pgadmin > backup as plain
text > take it home, rebuild it on my home machine which does run 9.1 -
on the command line using: psql databasename -f the-backup-filename
This seems to work ok and my software runs ok and I can access all my data
Can I just do a server upgrade to the latest ubuntu version and postgres
version and then do a similar command line import safely or is this too
simplistic a way of looking at it? If one does do the upgrade what
happens to the actual database itself if one doesn't explicity do anything?
Thanks in anticipatation.
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | JORGE MALDONADO | 2013-04-17 21:58:23 | PostgreSQL version upgrade (9.1 to 9.2) |
Previous Message | Birchall, Austen | 2013-04-16 15:56:40 | Another pg_restore question - indexes |