| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problem with postgres SQL db |
| Date: | 2006-08-19 17:46:57 |
| Message-ID: | 20060819174657.GA31601@phlogiston.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 17, 2006 at 10:52:24PM +0200, Rodion Raskolnikov wrote:
>
> now i dont remember SYNTAX what we use when we export db.
You need to use the _latest_ pg_dump. If you used the 7.2 pg_dump,
it for sure won't work.
There are functional changes between 7.2 and 8.1 that might make this
upgrade a little tough. Test everything very carefully.
It is possible that it will go more smoothly if you first upgrade to
7.4, and then dump from that to 8.1. I can't say for sure.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reece Hart | 2006-08-19 20:59:17 | text formatting in a query, a la sprintf |
| Previous Message | Bruce Momjian | 2006-08-19 16:53:11 | Re: Cast null string '' to integer 0 |