Le mardi 18 avril 2006 à 14:32 +0100, Andy Shellam a écrit :
> If you're using your 8.1 already, try the 7.3, to rule out the possibility
> of anything in your DB causing a problem to the 8.1 pg_dump.
Something along the line of creating a ssh tunnel to the intranet server
from the public server.
p.
Andy
> -Original Message-
> From: tony [mailto:[EMAIL PROTECTED]
> Sent: 18 April 2006 2:28 pm
> To: [EMAIL PROTECTED]
> Cc: pgsql-admin@postgresql.org
> Subject: RE: [ADMIN] downward dump compatibility
>
> Le mardi 18 avril 2006 à 14:18 +0100, Andy Shellam a écr
Le mardi 18 avril 2006 à 14:18 +0100, Andy Shellam a écrit :
> Nothing to do with file size limitations is there?
Not to my knowledge
> What are your system specs?
The public server has about 20 Gb free. It is a RHEL3 system with 1Gb
RAM.
I think that I am running up against the impossibility t
Nothing to do with file size limitations is there?
What are your system specs?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-admin-
> [EMAIL PROTECTED] On Behalf Of tony
> Sent: 18 April 2006 2:16 pm
> To: pgsql-admin@postgresql.org
> Subject: Re: [AD
Le lundi 17 avril 2006 à 19:23 +0100, Guido Barosio a écrit :
> Dunno, but it sounds like a "no" at a first sight.
>
> What about dumping with INSERTS instead of COPY ?
> That should work tho.
Something is preventing the creation of all the tables, about three key
tables are missing...
Back to t
Le lundi 17 avril 2006 à 19:23 +0100, Guido Barosio a écrit :
> Dunno, but it sounds like a "no" at a first sight.
>
> What about dumping with INSERTS instead of COPY ?
> That should work tho.
INSERTS in a heap of data then blocks the CPU at 90% abd just sits
there...
I'm thinking up a better pl
On Mon, Apr 17, 2006 at 14:38:24 +0200,
tony <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Is it possible to import a 8.1.1 dump file (standard format) into a
> 7.3.9 database?
>
> I have an intranet with the most recent version and a public serveur
> with selected data which is still running 7.3.
>
Dunno, but it sounds like a "no" at a first sight.
What about dumping with INSERTS instead of COPY ?
That should work tho.
g.-
On 4/17/06, tony <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Is it possible to import a 8.1.1 dump file (standard format) into a
> 7.3.9 database?
>
> I have an intranet wit
