| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alban Hertroys <haramrae(at)gmail(dot)com> |
| Cc: | BrunoSteven <aspenbr(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem for restoure data base Postgre |
| Date: | 2012-03-16 13:36:54 |
| Message-ID: | 7068.1331905014@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alban Hertroys <haramrae(at)gmail(dot)com> writes:
> On 16 Mar 2012, at 24:53, BrunoSteven wrote:
>> I am trying restoure data base from Postgre running on Windows Server 2003 32bits with Postgre with 9.0.3 for a Linux running Centos 6 with Postgre 9.0.7 , but wasnt working very well .
>>
>> I post follow link for paste bin with some message error
>>
>> http://pastebin.com/94qnc8Hj
>>
>> I dont understand very well functions Postgre, but I need help for solve this problem.
> You may want to check the preferred spelling of the product, it's definitely not Postgre.
> It looks like you're using an old version of pg_restore to attempt the restore. CREATE EXTENSION is new to Postgres 9.x, so your pg_restore is probably from a Postgres 8.x installation.
More to the point, CREATE EXTENSION is new as of 9.1. So that dump did
not come from a 9.0.x server, and you're not going to be able to restore
it into a 9.0.x server.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | salah jubeh | 2012-03-16 14:06:05 | serial- sequence priveleges |
| Previous Message | Tom Lane | 2012-03-16 13:32:49 | Re: Zero-length character breaking query? |