| 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: | Whole Thread | Raw Message | 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 |