| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jay McGaffigan <hooligan495(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Restoring a database dump from 9.0 to 9.2 |
| Date: | 2013-02-09 03:11:39 |
| Message-ID: | 5797.1360379499@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jay McGaffigan <hooligan495(at)gmail(dot)com> writes:
> So my first question.
> If I can't use a psql 9.2.2 instance to create the backup. Are there
> 'best' practices I should follow in creating the backup. All my googling
> hasn't really been able to point to the best approach.
We do recommend using the newer pg_dump in an upgrade scenario when you
conveniently can, but 99% of the time the older pg_dump should work
fine. That recommendation is mainly to forestall issues like
that-particular-older-version-has-a-bug, and at the moment there's no
evidence that that's your problem.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2013-02-09 05:02:25 | Use case for deferrable check constraints, given inherited tables |
| Previous Message | Gavan Schneider | 2013-02-09 03:09:53 | Re: Swapping volumes under tablespaces: supported? |